Automobile Updates

http://www.automobileupdates.com/honda-cb-shine-review/#more-1526

How to do number formatting to 1 decimal point in SSRS?

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/19c600df-bcc4-4663-bc0b-12c8ab226d48

SQL SERVER – TRIM() Function – UDF TRIM()

http://blog.sqlauthority.com/2007/04/24/sql-server-trim-function-udf-trim/

Fun with Date Functions in SQL Reporting Services Report Builder

http://blogs.msdn.com/b/bimusings/archive/2005/09/13/464836.aspx

More Tips to Improve SSRS Performence

http://www.keepitsimpleandfast.com/2011/07/more-tips-to-improve-performance-of.html

http://www.keepitsimpleandfast.com/2010/05/tips-to-improve-performance-of.html

SSIS Tutorial

http://f5debug.net/ssis-tutorial/

Getting Started with SSRS

http://f5debug.net/category/sql-server/ssrs/

SQL Server DBA Tips

http://www.mssqltips.com/sql_server_dba_tips.asp

Useful Built-in functions of SSRS

http://bisqlserver2005.blogspot.in/2008/06/useful-built-in-functions-of-ssrs.html

Row number within an SQLSERVER

declare @test table (ChecklistTypeID
 int, HeaderDescription
 varchar(50),SubHeaderDescription varchar(50));

insert into @test values('1960','Sampling/Audit','Leases/Tenant Info Changes');
insert into @test values('1960','Sampling/Audit','Leases/Tenant Info Changes');
insert into @test values('2163','Sampling/Audit','Military Customer');
insert into @test values('2164','Sampling/Audit','Military Customer');
insert into @test values('2165','Sampling/Audit','Military Customer');

select ChecklistTypeID, HeaderDescription,SubHeaderDescription,
row_number() over(partition by SubHeaderDescription order by ChecklistTypeID ASC) as mySelection
 from @test
order by ChecklistTypeID desc


select *, ROW_NUMBER() OVER(partition by HeaderDescription order by mySelection  ) as myRanking from #Temp1
order by ChecklistTypeID desc, HeaderDescription