Without an ORDER BY, you cannot guarantee anything about a SELECT TOP query.

Just because it seemed to happen a certain way every day for the last 2 years doesn't...

All of the code above is "joining" the data, the difference is just in the syntax.

Joining using the WHERE part is old-style SQL, using the INNER JOIN syntax in the...

You only need to join to Trans once, and do conditional summing based on the type:

SELECT Account.Name,

  Sum(Case Trans.Type When 'A' Then Trans.Amount Else 0 End) as Actual,

 ...

sp_help reports the actual size of the column in bytes.

nvarchar is unicode, 2 bytes per character, therefore you can only store 50 characters in it, but the physical size of...

>>Jan comes after Dec thats why I have 1/1/2005,1/2/2005 at last position.

So ? July comes after December too, yet you have July dates *before* December dates in your example.

And I don't understand your "answer"

You gave us a table, containing dates the way you'd like them ordered. In that table,...

>>I need the dates in order

Yes. But in what order ?

Why is January coming after December, if July & August are coming before December ?

How about just accurately telling us the requirements, instead of presenting a table of data and playing a game of "go fish" while we all guess at what's actually required...

They aren't in the information schema views. You'll need to query sysindexes, using 'Where IndID = 1' for clustered index.

You need to "unpivot" table1, or bite the bullet and design the table in correct normalized form.

This is an unpivot query.

Select 'United' As Airline, united As SomeNumber

Union All

Select 'Delta' As...

There is an error in the SQL. Use the '%' operator for modulus:

SELECT TOP 7000 * FROM YourTable WHERE (ID % 10) = 1

You need to "unpivot" the data. This can be done in T-SQL using a UNION ALL query that converts columns to rows.

eg:

SELECT Name, City, State, Email, 1 As ID, Q1...

>>What could be wrong?

Which SQL did you try ? What do the Row ID's in your table start at ?

>>I agree with Carl as it seems there would be identical rows in the resultset which doesn't make any sense to me.

No-one in the forum really knows, do they...

LOL .. so I wasn't the only 1 having a slow Friday at work. I did some benchmarking too and came to the conclusion that ... I'd learned something new....