Try this one too. http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

Sounds like dynamic sql. You can't create a varchar variable and then select from it. You would build your string as you did and then execute it via sp_executesql.

Been a...

Seems that the bigger question is what are hoping to do with this information? I have a feeling that you want to see if the data right now contains anything...

Pretty hard to figure out what you are trying to do but it sounds like it may be a dynamic pivot??

Take a look at these articles from Jeff Moden.

Cross Tabs...

SandyD (4/10/2012)

---

I think the higher than expected number of incorrect answers may be due to people finding the question a little unclear. Here is another way of phrasing what...

Looks like Lynn was typing with his uber fast response keys again while I was typing. 😀

You have TableA in both schemas. When you execute your proc with a specific schema it will first try to find a table with that name under the schema of...

njdevils39 (4/9/2012)

---

Lynn Pettis (4/9/2012)

---

njdevils39 (4/9/2012)

---

Sean Lange (4/9/2012)

---

Wow here we have another last minute addition to the specs...sheesh.

The code Lutz posted about 20-30 posts ago was more than 99% of what...

Wow here we have another last minute addition to the specs...sheesh.

The code Lutz posted about 20-30 posts ago was more than 99% of what you needed.

declare @emp_id int = 7

;WITH...

Not really too hard. Just hard code something like this but with the values you expect.

select 1 as RowNum, 3 as EMP_ID, 'Whitehead, Molly' as EMP_NAME, 'Silver Manor' as EMP_ORGANIZATION,...

Well here is the challenge...for some reason our "net nanny" does not allow images from ssc. Maybe somebody else that can view the image can help? Otherwise can you post...

Can you put together what you want as desired output? Hard code into a table or whatever. That way I have an idea that what I get is matching what...

How can you say that providing the ddl and sample data to the people trying to help you won't help...

I don't know that I would call this a problem. In order to have a persisted column that uses a scalar function the function must be deterministic, hence the reason...

You're welcome. So did you get it resolved now or did you still need some help?