This page http://www.karaszi.com/SQLServer/info_datetime.asp will let you know all you could ever want to know about dates in sqlserver.

Grant Fritchey (2/3/2011)

---

I have to say, it's entertaining as hell. You guys should keep poking him/her (most likely him). I'm so glad that's the exception, not the rule, for youngsters...

Please see this link ... http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

EDIT :

Basically , no , but you can improve your situation by using sp_executesql

Can you show us what you have tried so far ?

Gus however, is on the Christmas card list , lovely work there :Wow:

questionhacker , is certainly on my 'one to watch' list.

http://www.sqlservercentral.com/Forums/Topic1057295-391-1.aspx

Because its equivalent to

Select * from Sys.sysobjects where id in(Select sysobjects.id from sys.identity_columns)

So there is no syntax error

The TOP clause is in direct relevance to the order by clause

in your case

ORDER BY r.bill_code_cnt DESC

So it doesent matter if you

Select top(100) 1,2,3,4

or

Select top(100) 4,3,2,1

The top 100 rows will...

The column order has nothing to do with the TOP operator.

You can just simply reorder the columns in your select statement , though , IMO, relying on column order anywhere...

+1 from me for that suggestion , http://kimballscd.codeplex.com/

Try this link http://tinyurl.com/64674ot

Take a look at this article that i wrote a little while back.

http://www.sqlservercentral.com/articles/T-SQL/71571/

You just need top(1).

use "order by newid()"

Sorry , i need SQL code i can run , not a vague description.

Can you provide a full reproduction script ?

please include DDL (Create Table ) , data inserts and Select that show your issue