Yes, and thanks for putting all this effort into my post. I've yet to find some time to examine your extensive treatment, but I surely will !!

That is certainly true, the syntax has to be slightly different though as the alias has to be referenced first to make this work..

From my point of view the performance issue is secondary , since we're talking in the range of 5000 - 100000 records for a table. With SQL server 2005 and...

Yep,

Hans, This seems to work out right. Pretty obvious, but the more one stares, the more one misses such details.

Thanks again for your input!

I have the following table:

GEBIDLOAD_DTS LOAD_END_DTS

10017-7-2008 0:00:00 NULL

10028-7-2008 0:00:00 14-7-2008 0:00:00

100215-7-2008 0:00:00 NULL

100220-8-2008 0:00:00 NULL

10031-8-2008 0:00:00 NULL

100320-8-2008 0:00:00...

I have only had 1 chance to test the first suggestion by Hans, but it did not have the proper result. Looks like it gave the proper result for the...

Thanks, this makes things pretty clear!

Well, I was trying to prevent creating UDF's, cause this is just 1 example from many. Since this is allowed in VB, I hoped it would work in T-SQL.

But thanks...

The issue at hand is that SQL server 2000 does not provide the EXCEPT/MINUS set operators, so you need to roll your own construction to get at the missing combinations.

One...

Post what you got in terms of SQL and perhaps we can think of some suggestions. I still think running the data through a stored procedure would be the best...

SQL alone is not quite suitable for this kind of query. Actually, it is not a real query in that sense.

What you need is a procedure that loops through the...

I am curious whether it is possible to capture executed SQL statements through this SQL trace manager?

We have a Cognos frontend and would like to investigate in the exact translation...

What did surprise me was the mentioning of Oracle 10g having the facility to choose between setting for either OLTP or DWH. I know DB2 tackled that many, many years...

I found this:

http://support.microsoft.com/default.aspx/kb/811891/en-us

and:

http://support.microsoft.com/default.aspx/kb/822164/en-us

which only adds to the confusion. Can anyone of shed some light on this?

ann,

did installing fixpack 3 resolve the problem? I have exactly the same problem,so your experience with this one will be very beneficial!

Ties Blom