Sorry,

Must have been the lack of coffee.

I had @stamp defined as TIMESTAMP, if I define it as VARCHAR(23) then all is as should be..

No,

When I take the entire SQL string and run it, then the result is:

INSERT INTO [dbo].[H_DATUM_KEY] SELECT T.*,'Sep 16 2008 12:00AM' FROM [dbo].[V_H_I_DATUM_KEY] T

When I take your example the result...

Thanks Gary,

With batch I wasn't really thinking of running a command file, but really more of a solution on how to perform a similar action on a collection of tables.

I...

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...