Click here to Skip to main content
       

Database

 
GeneralRe: Dynamic Query Question PinmemberPIEBALDconsult13-Aug-11 9:29 
GeneralRe: Dynamic Query Question PinmemberS Douglas13-Aug-11 22:30 
GeneralRe: Dynamic Query Question PinmemberPIEBALDconsult13-Aug-11 7:15 
QuestionUPDATE Multiple tables on one filed. [modified] PinmemberMember 808202113-Jul-11 11:12 
AnswerRe: UPDATE Multiple tables on one filed. PinmemberBlue_Boy13-Jul-11 23:29 
AnswerRe: UPDATE Multiple tables on one filed. PinmemberShameel14-Jul-11 0:09 
AnswerRe: UPDATE Multiple tables on one filed. Pinmembersmcnulty200014-Jul-11 22:39 
AnswerRe: UPDATE Multiple tables on one filed. [modified] PinmemberNiladri_Biswas18-Jul-11 2:12 
Hi, I am providing a solution to this problem but ideally you should follow as what Shameel has said..
 
Let us create 4 tables (one master and three child tables) as under
 
CREATE TABLE [dbo].[tblmaster](
	[testID] [varchar](50) NULL,
	[Name] [varchar](50) NULL
) ON [PRIMARY]
 

CREATE TABLE [dbo].[tblChild1](
	[testID] [varchar](50) NULL,
	[Name] [varchar](50) NULL,
	[Age] [int] NULL
) ON [PRIMARY]
 

CREATE TABLE [dbo].[tblChild2](
	[testID] [varchar](50) NULL,
	[Name] [varchar](50) NULL,
	[Address] [varchar](50) NULL
) ON [PRIMARY]
 
CREATE TABLE [dbo].[tblChild3](
	[testID] [varchar](50) NULL,
	[Sex] [varchar](6) NULL,
	[Address] [varchar](50) NULL,
	[Phone Number] [varchar](50) NULL
) ON [PRIMARY]
 
insert into tblmaster
select 's401', 'name10' union all
select 's402', 'name11' union all
select 's403', 'name12' union all
select 's404', 'name14'
 
insert into tblChild1 
select 's401', 'name20', 20 union all
select 's402', 'name21', 21 union all
select 's403', 'name22', 22 union all
select 's404', 'name23',23
 
insert into tblChild2 
select 's401', 'name30', 'address30' union all
select 's402', 'name31', 'address31' union all
select 's403', 'name32', 'address32' union all
select 's404', 'name33', 'address33' 
 
insert into tblChild3 
select 's401', 'male', 'address40','9885446789' union all
select 's402', 'female', 'address41','12345678' union all
select 's403', 'male', 'address42','34567891' union all
select 's404', 'female', 'address43','0986234' 
 
Select * from tblmaster
Select * from tblChild1
Select * from tblChild2
Select * from tblChild3
 
Now fire the below query
 
exec sp_msforeachtable N'
  IF EXISTS(SELECT 1 FROM sys.columns WHERE object_id=OBJECT_ID(''?'') AND name = ''testID'')
    EXEC (''UPDATE ? SET testID= case when testID = ''''s401'''' then ''''I00010'''' 
				      when testID = ''''s402'''' then ''''I00020'''' 
				      when testID = ''''s403'''' then ''''I00030'''' 
				      when testID = ''''s404'''' then ''''I00040'''' 
                                  end'')'
N.B.~
Use this example as a reference for your problem.
 
Thanks
Niladri Biswas
modified on Tuesday, July 19, 2011 5:48 AM

QuestionCalculate and display a progressive balance PinmemberRameez Raja11-Jul-11 20:48 
AnswerRe: Calculate and display a progressive balance Pinmemberdjj5512-Jul-11 4:40 
AnswerRe: Calculate and display a progressive balance Pinmembersmcnulty200014-Jul-11 22:34 
GeneralRe: Calculate and display a progressive balance PinmemberRameez Raja16-Jul-11 22:49 
GeneralRe: Calculate and display a progressive balance Pinmembersmcnulty200018-Jul-11 13:36 
QuestionSelecting multiple columns from several tables without using JOIN PinmemberDisIsHoody11-Jul-11 4:41 
AnswerRe: Selecting multiple columns from several tables without using JOIN PinmemberBlue_Boy11-Jul-11 4:55 
GeneralRe: Selecting multiple columns from several tables without using JOIN PinmemberDavid Mujica11-Jul-11 5:28 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pinmemberkmoorevs11-Jul-11 10:08 
AnswerRe: Selecting multiple columns from several tables without using JOIN PinmemberShameel11-Jul-11 21:30 
AnswerRe: Selecting multiple columns from several tables without using JOIN PinmemberDavid Skelly12-Jul-11 3:54 
AnswerRe: Selecting multiple columns from several tables without using JOIN PinmemberAnnieMacD14-Jul-11 6:24 
GeneralRe: Selecting multiple columns from several tables without using JOIN PinmemberShameel14-Jul-11 18:52 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pinmembersmcnulty200014-Jul-11 22:46 
GeneralRe: Selecting multiple columns from several tables without using JOIN PinmemberShameel15-Jul-11 2:22 
GeneralRe: Selecting multiple columns from several tables without using JOIN PinmemberAnnieMacD15-Jul-11 2:45 
GeneralRe: Selecting multiple columns from several tables without using JOIN PinmemberShameel15-Jul-11 7:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.140709.1 | Last Updated 12 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid