Microsoft Business Intelligence TOOLS(SSIS,SSRS and SSAS)
Learning about Sql server2005/2008,SSIS,SSRS and SSAS
http://reddymsbitools.blogspot.com
Home
SQL Server2008
Tuesday, 30 November 2010
Finding Top and Bottom records
SELECT * FROM [dbo].[Users] WHERE [PK]
IN(SELECT TOP 1 MIN([PK]) FROM [dbo].[Users] UNION ALL SELECT TOP 1 MAX([PK])
FROM [dbo].[Users]);
How To Set Page Break in a report Conditionally
How To Set Page Break in a report Conditionally
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
