If you have SQL Server 2005 you can use the RANK() FUNCTION

SELECT TOP 1 RANK() OVER (ORDER BY COL1,COL2,COL2,COL3,COL4,COL5) AS RANK

My SQL concatenates all the columns and then I send it to a text file as delimited not as a fixed length. I don't append anything to the end of the...

We just started using SSIS and have the same problem. Until I can resolve the problem I use a work around of concatenating all the columns in a query making sure...

Here is a simple approach:

declare

@date1 datetime,@date2 datetime

select

@date1=CURRENT_TIMESTAMP

select

@date2=