I'm trying to generate row numbers for each row returned in my query:
SELECT *, (SELECT COUNT(t2.TabId)
FROM rbpo.rb_Tabs t2
WHERE t2.TabId = t1.TabId ) AS RowNum
FROM rbpo.rb_Tabs t1
WHERE ParentTabId = @SJTabId
ORDER BY RowNum ASC
The RowNum is coming back all 1's
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people