If you use SQL Compare in concert with SQL Packager you can create "batch" jobs that will create the script and apply it against the target database automatically.

You want to read this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=175525#bm188799

This is a much more complicated problem than even you imagine.

On the Clustered Primary Key: If the insertion order matters then add a column...

If you're trying to build a message body that contains Global Variables it might have to code an ActiveX/VBScript to set another Global Variable that has the contains the entire message...

Ah.. I get it. There's only one correspondence to delete. There may be multiple party entries, but they're deleted with

DELETE FROM PARTY WHERE CORRESPONDENCE_ID=@corrid

It's the PARTY_COMMENT and PHONE...

Delete C

From

      PARTY_COMMENT C JOIN PARTY P ON C.PARTY_ID=P.PARTY_ID

Huh?

I don't follow this one at all. How does this relate them back to the @corrid parameter passed into the...

     WHERE <A href="mailto.CORRESPONDENCE_ID=@corrid">P.CORRESPONDENCE_ID=@corrid

I'm never sure about joins...

No fragmentation. The index was built after the table was populated and there haven't been any adds or deletes since building the index. I double-checked anyway with DBCC and it...

Can Exec accept a scalar UDF as a parameter? If so you can pass the group to a UDF that COALESCEs the relevant group email addresses into a comma or...

Could be...

Yup. In fact I posted this thread as a response to the article as another example...

If you don't believe this example take a look at the example I posted which Noeld and Remi helped me convert:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=197948

This went from 2 hours to 6:46 to 0:26...

I don't do it every day, I only get involved in about 1 SQL project a month so I don't even get regular exposure.  Oftentimes I look at these set-based...

Understood. I've never subscribed to the argument that cursors or procedural code is the best way to do things, but when you take an "old" programmer and make him a...

Not me, but then again I never did. It's always been "how to", not "whether to". I can understand the solution once I see it, but I can't always figure...