It would be best if you started a new thread for this question. You will get more attention to it and you'll be able to provide more details.

Could you...

Are you refferring to his challenge???

I'm not the one to ask question and answer them (on purpuse anyways). So that's not how I got to 3.6k .

Thanx Bkelley .

Please post the table definition and some sample data and most importantly the expected output after the update... It's not something we can screw up on

Have you tried running this??

Select convert(varchar(12),GetDate(),103)

Check bol for all other possibilities (in convert/dates).

Well I'd vote for myself so I get at least one vote .

Did we just start an infinite loop??

It's probabely by design. You'd have to ask an Sql engeneering guy to answer why it's not possible. Also another answer would be that sql server is not...

This article is just 1 week late .

http://www.sqlservercentral.com/columnists/cherring/replacingcursorsandwhileloops.asp

That might start a little war... not sure it's a good idea.

As far as I know it's impossible to link tables directly between 2 sql servers (unless you are talking about replication).

One option I've seen that could serve that purpuse (if...

Alright... just make sure you don't accidentally delete system procs/view... that'll surely cause other problems down the road .

Usually you import the data into a temp table in the first dts stepts. Then you can do validation and import/cancel the operation as needed from there.

Most likely is that you have someone using that table.

Execute this :

sp_who2 and check the column blkby.

Then for any column with an id run this :

dbcc inputbuffer (spid)

This...