I would suggest reading Jeff Moden's aticle here on SSC at:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

I would suggest reading Jeff Moden's aticle here on SSC at:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Rather hard to assist you ... what were you attempting to do execute a T-SQL...

Brandie Tarvin (7/6/2012)

---

One thing I strongly advise: Do not take this career path just for the possibility of high pay. If you do not like what you are doing, then...

Emphasis (bolding) added by this poster

BrainDonor (7/6/2012)

---

That explanation requires expanding slightly, because there is more than one type of temporary table.

Local temporary tables (prefixes with '#') go out of...

Excellent article here on SSC

4-4-5 Calendar Functions, Part 1

By Cliff Corder, 2010/09/06 (first published: 2009/09/28)

http://www.sqlservercentral.com/articles/function/67046/

...

CONGRATULATIONS

I would use something like this

DECLARE @T1 DATETIME

DECLARE @T2 DATETIME

SET @T1 = '7/02/2012' | The 2 parameters passed to your T-SQL statement

SET...

Use the DATEDIFF function - check it out on Books On Line (BOL) or read this:

http://msdn.microsoft.com/en-us/library/ms186724.aspx#GetDateandTimeDifference

You are close to your problem, unfortunately we are not. Could you give us the pertinent table definition(s), some sample data and your desired results in a readily consumable...

Koen Verbeeck (6/29/2012)

---

Ron's series on transactions led me to believe it should be 2. 🙂

Got it wrong, but definately learned something. Good question!

(3 wrong in a row, this is not...

oops

First step I would take, and have taken is to run the upgrade advisor available at:

http://www.microsoft.com/en-us/download/details.aspx?id=11455

then do what has to be done.