Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
 Posted - 2010-10-09 : 07:40:51
|
| Hi all.. I have a master table and 9 client tables ...Master table contains all the datas ... Client table only contains the datas of today ..Based on the updated_date column it must be selected..Note... All the other values in the client table must be truncated and the values of today's date must be inserted...In a single query all the client tables must be updated ... Help me!!.. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-09 : 08:35:26
|
| Here you go again....We had just a long thread on how you should frame a question & inspite of the assurance given by you http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151218#594241 you still haven't learned.I am NOT going to waste my time visualizing your data & the table structure.PBUH |
 |
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-09 : 08:51:57
|
| My table is like this..Tbl_masterid...des...mer...client...updated_date1....xxxx..xxx..c1.........(today_date)...19....xxx...xxx.c1.......(today_date)20....xxxx...xx..c2......(today_date)...30..xxx..xxx.c2.......(today_date)31....xxxx...xx..c3......(today_date)...40...xxxx...xxx...c3.....(today_date) . . .90...xxxx...x....c9......(today_date)...100...xxx...xxxxc9.......(today_date)I need C1(client 1)id...des...mer...client...updated_date1....xxxx..xxx..c1.........(today_date)...10.......C2(client 2)id...des...mer...client...updated_date1....xxxx..xxx....c2.........(today_date)......Like this i need for my 9 client tables.. |
|
|
|
|
|
|
Help on creating efficient query....