What you're doing makes sense. It's a good way to handle this kind of thing. I'm just not sure I can offer any help on debugging your loop...

Try a UNC path instead of a mapped drive letter.

Lots of possibilities here. Could be the scripts don't do anything because they aren't applicable (like Where clauses that cause no rows to be affected). Could be they...

It should keep the compatibility level you started with. The upgrades are in the database actual structure, etc. That's usual when restoring from a lower version of SQL...

It sounds to me like you have a business definition for a workflow, and you need to turn it into a technical specification, then work out an implementation path.

Judging by...

ScottPletcher (12/17/2012)

---

TheSQLGuru (12/16/2012)

---

My statement about making "queries" faster is about the ENTIRE process. The act of populating a temp table with an index already on the temp table before...

Something that many don't know about SARGability is that some functions, regardless of side of equation in a Where clause, are SARGable.

Try this:

SET NOCOUNT ON;

USE ProofOfConcept;

GO

CREATE TABLE dbo.SARGTest (

DT DATETIME...

bleroy (12/14/2012)

---

As GSquared said:

It is still beyond me...

CELKO (12/14/2012)

---

Yeah, it was awful! :crazy:

What I wanted to do was...

CELKO (12/13/2012)

---

Please read just one little book on SQL and RDBMS. Please, just one little book! This is not a table; it has no key; it...

ScottPletcher (12/13/2012)

---

I'd suggesting not using that particular new "enhancement" at all while you still have ANY older instances / compatability settings.

It doesn't save you that much anyway. Not worth...

I'm not really familiar with your table. That makes it kind of hard to know what to suggest.

You're welcome. Glad I could help.

Really? I always just assumed a Jawa stole...

delete from MyTable

where Col1 is null and Col2 is null and Col3 is null

or Col1 is null and Col2 is null and Col4 is null

or Col1 is null and Col3...