ROFL! :laugh:

Beautiful, Ken.

The other thing that I would suggest for building Clustered Keys on big tables like this is to make sure that you MDF, LDF and TempDB's are all on seperate...

This is large for a clustered key, I suggest that you find a smaller one (on none at all as previously suggested). ReOrdering 12M rows will take a while.

I...

You don't need the DISTINCT for an IN(..), and you can make the update_date test's more sarg-able:

SELECT user_key AS User_id, update_date AS createDate

FROM accounting.dbo.user

WHERE user_key NOT...

Let us know how it works out. 🙂

Glad we could help. Let us know how it works out.

You need an IF, not "SELECT.. CASE.. THEN.."

IF 1 = (SELECT 1)

BEGIN

...

END

ELSE

BEGIN

...

END

try this:

/*

1 use union, not join

2 Use INFORMATION_SCHEMA.TABLES

3 include columns for ordering, remove in final

4 put commas at beginning, NOT end

*/

Select CmdOut

From(Select 'EXEC dbo.spGenerateInsUpdate N'''...

...?

Use the SOUNDEX or DIFFERENCE functions?

Jezemine: SUM for numbers, COUNT...

Well, you could install Powershell, write a Powershell script to do it (which I am told is comparatively easy), then call the Powershell script from your .BAT file.

Yeah, I just looked it up and I cannot see hot to do it either (I must have been thinking about some other DB interface, like SMO or something).

The only...

Upon further consideration, I think that I may have spoken too soon. It turns out that these are difficult elements to script out from the SQL command line. ...

Chris Hall (6/24/2008)

---

Good idea checking SYSPROCESSES, rbarryyoung. I'll give it a try. I won't worry about SQL 2000. Although I can't have the code falling over, I'm prepared...

Yeah, I just saw this the other day, but I don't have my Visual Studio up to test it.

If you have yours up, edit the parameters of the "cmd.Parameters.Add (1,...