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 |
|
pavansagar
Starting Member
2 Posts |
 Posted - 2006-11-03 : 07:10:50
|
| hai friends, please help me.Here is my doubtIn a table I have fields like this TABLE NAME : table1 COLUMN NAME : ids---------------- ids-----------------1,3,43,437,111166,71i want to get all the ids used i.e., 1,2,3,6,7,11i want to update another table based on the id, which are not listed here.I am doing like belowdeclare @IDs varchar(200)select IDs=ids from table1update table where(id not in(select ID from timeSplitter(@IDs)))please help me.it is urgent thanks in advance bye pavansagarpavansagar |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
how to split and get the unique ids