edstewart (7/17/2012)

---

Please forgive if this has been asked and answered... I have to move content from one system to another. In the first system, FirstName and LastName are separate columns,...

This can be done using a Tally Table.

Thanks to Wayne Sheffield for the concept on doing this.

declare @LongText varchar(255) = 'Rang the client and agreed they would begin to pay...

dndaughtery (7/17/2012)

---

I was told someone interviewing me would ask this. In my 7 years of DB Development Ive never had a need like this but thought I could vaguely remember...

Lowell also has one that he has posted several times. His does a few things different than mine. His is also resource intensive so DO NOT RUN THIS IN PRODUCTION!!!!

CREATE...

There is no easy or fast way to do this. You are asking to search all columns in all tables. This is horribly slow. I wrote the following proc several...

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1330452-1550-1.aspx

With over 700 points you are well aware of the benefits and reasons we always ask for ddl, sample data and desired output. Read the first link in my signature...

Not sure what you mean here. Are you asking if you can declare a variable in such a way as...

Learned something today from a good question, although it was fairly easy to deduce the correct answer. Given the binary nature of computers the max number of columns without...

L' Eomot Inversé (7/15/2012)

---

Thanks to "El" Jerry, Jason, Lynn, Paul, Stefan, Gianluca, Bex, Grant, Brandie, Greg, Kiara, Revenant, Sean, Craig, Rodders, Dwain, Ray, Jeff, Jack, Wayne, Jan, and Gus ...

You started with posting some really useful ddl and sample data. Then unfortunately you lost it. You have a number of tables that have some sort of ID but no...

So it has been two days since you posted and not a single person has responded. That is because you didn't even really provide a question. Step back and read...

amritasehdave (7/15/2012)

---

Thanks for replying. This SP runs every night as a TMU file. I do not have access to DDL file.

I am not a DBA, I was asked to tweak...

Well it is obvious you didn't bother to read that article or you would realize that what you posted is not helpful. The point of ddl and sample data is...

Take a look at this article. It explains what to post for performance issues.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D