Yet another print and temp table guy.

Such a common thing to do I generally have an input parameter in the proc @debug bit = 0 and that way...

With you on those suggestions Steve.

I do think there is lots of info out there, I can't imagine how MS could make it easier to aid the planning and...

Not quite sure exactly where you are coming from or what answer you expect. BUT surely you are right. SQL server requires CPU to do anything (else why bother with...

Ever thought of putting the query inside a stored Proc, then you would just have an Update to some control table within the proc ie:

Create Proc dbo.P_query as

Set Nocount ON

Declare...

Hey Thanks Sean, I knew there would be a non-cursor/looping method, just didn't know it , now I do, Thanks.

Live and Learn.

I've had to deal with this sort of thing too. I couldn't resolve it nicely, so keen to see what works.

Thanks

Good luck.

I have very successfully moved Log files to a SSD system (*) and received huge (2-5) times improvements in speed. I'd have thought moving the Log files would be more...

Talking of sillier things dealing with MYSQL. Only Yesterday I had a Linked server that would work if the Linked server and the DSN name were in CAPS. ...

Almost anything is possible, and certainly this is. Trouble is I can only think of a looping mechanism right now and they are slow, but if you do the thing...

You're right plenty of Word to PDF convertors around. But most require Word installed on the machine. We had a need whereby the Compliance Officer would be able to alter...

I've made use of a CLR to do this, very fast, did pay about $US 300 for the DLL's but that paid for itself many times over. If you're keen...

Triggers are hard to test and debug, have you tested the insert string outside of the trigger (obviously needs a bit of rewriting) ?

Your problem sounds like less to do...

Not sure I get all that you are saying, as it seems simple enough just use "where Salesdate between campaignstartdate and Campaignenddate"

Or am I missing something..

Have you tried looking at the Activity Moniter? I'm sort of assuming you can see this activity going on , so the Activity Moniter may help identify the process.

Hey I script my views up (not using the GUI) and I don't ever get that problem.