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

Now we can all see the code. However as already stated you need to post ddl, sample data and desired output before anybody has a chance at helping.

Why all the...

For those of you too nervous to open a text file...

CREATE Procedure [dbo].

--@evt_keys nvarchar(4000)=null

@last_export nvarchar(20)=null

as

--select @last_export = null

Create table #temp_keys (Id uniqueidentifier)

--if rtrim(isnull(@evt_keys, ''))=''

--insert into #temp_keys select evt_key from...

You need to provide ddl, sample data and desired output. Take a look at the first link in my signature for best practices when posting questions.

Lynn Pettis (7/13/2012)

---

Are you volunteering to do...