dmartin 38210 , I am a huge fan of Itzik. This is a great option, thanks!
I agree Jeff however, we do...

thank you very much, I will check it out!

Hello All,

How would you do this with any and all dates?

I am trying to think of a way to create a Greatest Value that will handle dates, different date formats,...

You are correct. Sorry I did not give more details. Our department was using it to parse query and print dynamic T-SQL statements. We were not using it with SSIS...

I had the same concern, our team was also using this feature and when I researched and found the same warning on MSDN, Do not use this feature. This feature...

No problemo, glad to be of help!!

Sure. SO here is a screen shot of the procedure as a keyboard short cut and a snap shot of the table highlighted, now hit Ctrl + 6 to display...

Hello Timothy,

Question where did you get the figure 1073741822?

SET @sSQL = SUBSTRING(@sSQL, @CurrentEnd+@Offset, 1073741822)

here you go, ask and you receive.

sp_helplinkedsrvlogin

How about options like this?

update t

set someValue = s.SomeValue

from openquery(lnk_sB,'

select *

xref.dbo.Symbols s') s

inner join #myTab t

on t.id = s.id

update t

set someValue = s.SomeValue

from #myTab t with...

Luis,

Thanks! I was trying to figure out how to use COLLATE Latin1_General_BIN in the function, but I was unable. Thank again and it tests out fine!

EXEC ('

DROP VIEW schema.TableName_New;

');

EXEC('

CREATE...

Hello Adi,

This worked great! This does wok for my solution. But now curiosity has the best of me and I truly wonder how to use the replace function and replace...

Hello Igor,

In the question, are you assuming the correct database has been selected from the drop down menu?

Thanks,

Tim

GM Shawn,

Thanks for the reply, I will also test out your idea as well, thanks a bunch, I appreciate it. I did not know this was an option.

GM Adam,

Sorry about that. Yes they are all SQL servers, SSMS 2008 R2. I thought about using Execute At using linked server, which is a great idea. I just do...