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?

Well sort of...but your order by column is not unique so which value of 'A' is first? This makes it rather challenging.

this is close...

IF OBJECT_ID('tempdb..#GETID') IS NOT NULL drop table...

Well since it is public facing Windows Authentication is not going to work. You could add a SysModUID column or something along those lines to each table, make it not...