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 |
|
Movember
Starting Member
12 Posts |
 Posted - 2009-10-21 : 17:35:22
|
| I am trying to update some records with a ID letter that are joined as a family. The primary member is marked as with 1 and they all have the same linkid and I am trying to give each member a unique letter like below. Not sure if this is possible?i.e.NAME LINKID PRIMARY IDJohn Smith - 1234 - 1 - A Joan Smith - 1234 - 0 - BTom Smith - 1234 - 0 - C |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2009-10-21 : 18:22:55
|
| Duplicate: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=134761 |
 |
|
|
Movember
Starting Member
12 Posts |
Posted - 2009-10-22 : 00:04:34
|
| Thanks that works well, just getting some weird values. Most lines do go A B C D etc, but some records with are not in a group so should just get A are get C D F or whatever, and some do not start a A? |
|
|
|
|
|
|
nested cursor?