Question asked do not mention anything about table tblUsers
When executed the query ;
WITH Users(UserID, UserName) AS
(
SELECT TOP 1 intUserID, strUserName FROM tblUsers
)
SELECT TOP 2 tblUsers.*, Users.* FROM tblUsers, Users
Reults into following error:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'tblUsers'.
Looks like other's have also faced the same issue here :hehe:
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."