Sean beat me to it, but here is a setup that also creates a 1,000,000 row data set to test.

CREATE TABLE #Transactions

(

ID INT IDENTITY PRIMARY KEY,

CardID INT,

TranDate DATETIME

);

create index CardID_TranDate...

Anyone know why the pulled Database Mail from Standard Edition? Doesn't make sense to me.

Looks good, but I am going to quibble a bit here. The semicolon (;) is a statement terminator, not a statement begininator. The following snippet from your post:

CREATE...

Valid values for...

Steve Jones - SSC Editor (7/20/2012)

---

AFAIK, the tool comes with the Litespeed install. Unless things are changed, there was a converter to move compressed->native that was a .exe in the...

Not going to try and convince you it is right or better. I can see why your Senior DBA wants it done that way, I would not have a...

Four separate threads for the same problem and none of them have an answer. Why? Because you won't provide the information requested in the format needed to help you.

Read...

Is this the part you are asking about?

fetch NameOfFirstCursor into @parms

select @t_status = @@fetch_status <<--- specifically this immediately after the fetch?

while (@t_status = 0)

Actually,...

sqlfriends (10/17/2011)

---

I prefer to use the native backup tool too.

But one problem I often comes with how to select to backup all user databases but to exclude one or more...

Steve Jones - SSC Editor (10/17/2011)

---

The mature third party backup tools provide utilities, for free, without license, that convert their compressed/encrypted backups to native formats. You can get those for...

I can't recreate the problem using the date you provided.

Can you post a script that actually fails for you?

Separate query and change the computation to include dividing the time by 15 to give you the portion of the route (or whatever you called it).

The problem looks to be the scalar functions. Unfortunately, we can't see what you see, so all we can give you is a shot in the dark.

I would look...

Could be one of those used to be type situations. Perhaps in an older versions of the software (meaning the optimizer) people found that the order of the values...

Okay, forget you getting frustrated, I'm frustrated. Just how many different threads do you need for the same problem????