April 21, 2010

ROW_NUMBER In SQL Server

SELECT
ROW_NUMBER() OVER (ORDER BY ID) AS [SR NO],
Name AS 'USER NAME',
LoginDateTime AS 'LOGIN',
LogoutDateTime AS 'LOGOUT' FROM UserLoginTrapper,UserInfo
WHERE
UserLoginTrapper.UserName = UserInfo.Login
AND
LoginDateTime BETWEEN @FDATE AND @TDATE
AND
IpAddress NOT IN ('172.23.4.26','127.0.0.1')
AND
CallType = @CT

No comments:

Post a Comment