pretea (2/28/2014)

---

Thanks Sean, but this does not give me column names.

Going back to my initial scenario. I have stored procedure created in one database but in the stored proc itself,...

Why don't you do some performance...

I was thinking the same thing Steve. Not sure I can commit to this one at the moment since I still owe you an article on another topic.

Not sure why I made my query so over complicated in my previous post. I guess it was near the end of the day and my brain had already shut...

Lowell (2/28/2014)

---

take a look at this DMV, and run this in the database you think has external references:

i think this view is supposed to populate with values, even if the...

pixeldude (2/28/2014)

---

Sean Lange (2/28/2014)

---

You absolutely do not need a cursor for this. Cursors are horrible for performance as you obviously realize. We can help you but first you need to...

JoshDBGuy (2/28/2014)

---

Sean Lange (2/28/2014)

---

JoshDBGuy (2/28/2014)

---

Do you have a best practice for cursors? Just don't use them at all or only in certain situations? I tend to use them for small...

As a shot in the dark...have you updated statistics? That could very likely be the issue here. How much data is being affected by this query?

From what you posted I don't see any need for any looping construct or dynamic sql.

In order to help we will need a few things:

1. Sample DDL in the form...

I tried below query it works fine when @extract = 'Yes' but not the other way .. i am getting way too many records

DECLARE @Extract VARCHAR(10)

DECLARE @desc VARCHAR(10)

SET @desc =...

JoshDBGuy (2/28/2014)

---

Do you have a best practice for cursors? Just don't use them at all or only in certain situations? I tend to use them for small sets of data,...

JoshDBGuy (2/28/2014)

---

Depending on how many rows you're looking at, you can use a cursor or you can probably use a loop with IF then statements with a temporary table or...

You absolutely do not need a cursor for this. Cursors are horrible for performance as you obviously realize. We can help you but first you need to help us by...

Did you actually read my response? I would not even attempt to script this if accuracy is even a second thought. There are just...

Sounds like a good opportunity. I have a couple of ideas in mind. Of course I have another article I need to get finished first...