The most efficient in terms of CPU cycles is probably the following:

dateadd(day,datediff(day, 0,getdate()),0)

This strips hours, minutes, seconds and milliseconds from the date. Just replace GETDATE() with the name...

Please post your code, so we can understand what you need the declare statement for. You may be able to do what you want using a user defined,...

I'm assuming you commented the following EXEC and replaced it with the PRINT statement before sending us the code, and that in production it is uncommented.

--EXEC SP_CMDSHELL @SQL

PRINT @SQL

Remember that...

That would certainly be better for stress-relief, and probably for productivity too. 😛

You are not wrapping the date columns themselves in a function, which is the usual performance killer.

Using BETWEEN with dates can be perilous, for example if you...

WWJMD?

Jeff would probably drive the moneylenders from the temple with pork chops flung freely.

insert into Table_Destination (Col_c)

select ISNULL(Col_A,cast(Col_B as varchar(max))

from Table_Source

-- or

insert into Table_Destination (Col_c)

select COALESCE(Col_A,cast(Col_B as varchar(max))

from Table_Source

You're welcome. Sorry we didn't get to hear the story. 😉

Sounds great 🙂

Perhaps I'm not being clear.... the point is that you have a database on each server. You aren't trying to run code across linked servers as your original...

Yes... but you still have a DB on each server, yes?

You're going to need separate copies of your code database for each server.

Where'd you get the hat? I have to make do with a colander reinforced with tin foil.

Jeff, I thought maybe Lynn was using The Force on you to fill in for him while he was on vacation. Sort of a long-distance Jedi mind trick?

Hey Barry.... click here. 😛