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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-06 : 07:44:36
|
| Doran writes "Greetings.My problem, in its simplest form:A result set:FLD1----AABDDDWould like to add a field (FLD2) with a 1 on first occurence, or 0 on all others:FLD1 FLD2---- ----A 1A 0B 1D 1D 0D 0Actually, I dont care if its the first or last occurence.Thanks for any help!Doran" |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-07-06 : 08:51:41
|
| Without a primary key on your table, you can't really do much of anything useful with your data in SQL Server. And, in fact, even if you can I don't recommend that you try until you go back and set up your database properly.It's like writing a 10 page document in Word but not using an punctation at all, and then wondering how you can get Word to format the output properly.- Jeff |
 |
|
|
|
|
|
SQL - Numbering Problem