I'm working on this:
SELECT *
INTO #TmpContactInfo1
FROM ContactInfo1
SET @NumberRecords = @@ROWCOUNT
SET @RowCount = 1
WHILE @RowCount <= @NumberRecords
BEGIN
SELECT Name = @Name,
Company = @Company,
Category = @Category
FROM #TmpContactInfo1
WHERE RowID = @RowCount
SET @RowCount = @RowCount + 1
END
DROP TABLE #TmpContactInfo1
How do I get RowId as part of my result set?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
