Whatever the whys and wherefores , the tool is being blamed for a bad job by a bad workman.

Any developer can screw up any development.

Please see this article

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

datetimes are NOT stored in any particular format.

See this link for all that you will ever need to know about dates.

http://www.karaszi.com/SQLServer/info_datetime.asp

I suspect that this is a homework question.

Investigate pivot.

ankur_dba (5/12/2010)

---

I also have a similar scenario, (as suggested) i am trying to do the grouping at front end (SSRS report in my case)

Now the problem, when the results set...

Have you tried comparing the execution plans of the hanging and non hanging statements ?

Can you post the UPDATE statement that it is hanging on ?

Sounds like a bad query plan....

Please also see this http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

All depends on the quality of your .net developers.

SSIS removes all the framework from an ETL Process, (ie you dont have to worry about the nitty gritty of reading and...

Use a case statement on a row_number function to say that when RowNumber <>1 then show ''

Maybe an indexed view could be a quick solution to those issues ?

Id still like to see how the view i gave effects things in this case.

Use a calendar table

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Thanks , Id like to thank the academy and wish for world peace 🙂

No random generator can guarantee truly unique , you will have to check for this you self.

Try this link ...

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/a-faster-tsql-random-length-random-string-generator.aspx

You have also posted in the 2000 forums , please confirm which version you are using.

Also please read this http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Please keep to 1 thread.....

http://www.sqlservercentral.com/Forums/Topic919464-392-1.aspx