[dba-SQLServer] SQL question

Jim Lawrence jlawrenc1 at shaw.ca
Thu Sep 27 19:58:14 CDT 2007


Can a sequence of numbers be created in a sequel list?

Example:
Given a list like:

George
Sally
Robert
Henry
John
Mary

Can the piece of sequel code be modified to produce/create the following
list?

George	0
Sally		1
Robert	0
Henry		1
John		0
Mary		1

TIA
Jim





More information about the dba-SQLServer mailing list