Simple:

Add to the first query (A) the condition to be present, so it becames A'. The same with B and C.

So now you can use:

A' union all B' union all...

Also consider triggers as the source of the 'problem'. Remember the NOT FOR REPLICATION clause.

Totally agree on 1. and 2.

Use a bat if necessary

🙂

quote:

---

1. Always search for a SET oriented approach.

2. Smack developers who present...

Better yet:

Put a BEGIN TRAN before, (specially if it is late late..), triple check the resultset, pray, then COMMIT, and then, by instict, erase the COMMIT of your QA.

......

This is RAC: http://www.rac4sql.com, I guess ojn is a fan user or maybe the CEO 🙂

By the way, if you retrieve this data in an excel sheet, you...

Check this out

Bug ID:54978

Link:Q225501

FIX: SQL-DMO Operations on SQL Server 7.0 Uses More Memory

at: http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q225501

Since you are not talking about a time consuming process, a posibillity is:

Not all the clients are using the same version of SQL Server Objects...

Check (question), are all your clients...

In adition to my previous post, and, if you have no problem with disk space, then you should try (only for this exceptional critical case), one of 2 posible indexes:

(SITEID,CALLID,callwhen,seconds)...

Really simple, you are extracting the hour from a datetime column then comparing.

If you use convert (or any other op over a column), the index wont work.

So, insted, convert...