The question I have, is this, the last date of what year? Using today, 2012-07-02, as the date of reference, what year do you want the end of; this...

Please remember, the primary key does NOT have to be the clustered index.

What edition of SQL Server are you running?

Rogman (7/2/2012)

---

That would be a safe assumption, though we're not the...

Rogman (7/2/2012)

---

Sorry for the delay, been slammed with other stuff today.

Query- Please ignore the syntax. I changed it to ANSI joins as a test and the query plan...

Not sure about others, but when I viewed your attachment, it is all run together. I'm not about to run this code on my computers when I can't even...

Yes. BETWEEN is actually converted to >= and <=.

Basically, when you query data based on dates (particularly when using date/time data type that can have time portion) you want a closed end comparision on the beginning part of...

Something like this should work. Remove the CTE porition and replace the CTE name (TestData) with your table name.

with TestData as (

select lp from

(values

('5.46.200.1.462222.2.1.2.3.4.5.1'),

('5.46.200.1.462222.2.1.2.3.4.5')

) sampledata(lp)

)

select

reverse(substring(reverse(lp),...

I had to make some changes to your code. One, I don't have your database. Two, I don't have your file groups. Three, I don't have your...

Gullimeel (7/2/2012)

---

This was not so show you, how to reproduce the eager spool. It was similar situation as OP has but at smaller scale like in 100 thousands rather than...

From BOL:

-bbatch_size

Specifies the number of rows per batch of imported data. Each batch is imported and logged as a separate transaction that imports the whole batch before being committed. By...

Bill Talada (7/2/2012)

---

@ Lynn Pettis

I don't remember you posting code for your 8k splitter. We all knew there was a general splitter function being used. It doesn't matter...

As I said, at a previous employer. I don't have access to the script I used to setup Robocopy to copy the...

Looks like MIRROR TO requires the Enterprise Edition to work.

At a previous employer I setup robocopy to automatically copy backup files from the local backup directory to an offsite location...