Hello All,
How to get Top 1 rows in Sql server 2000 version we are using for your production server.
I need to get First row with out using Rowcount is there any option to bring to bring Top 1 row and Top 1 is not working in sql server 2000.
SET ROWCOUNT 1
SELECT errorcode,errordescription,name,logdate FROM msdb.dbo.sysdtspackagelog
WHERE WHERE[name] = 'ProjectModel_xfer2'
ORDER BY logdate
SET ROWCOUNT 0
Please help me.