I particularly liked his last comment.

I know exactly where the problem is...that big blob right between the keyboard and...

opc.three (4/27/2012)

---

Yeah...for once I need to stop violating my rule...

This post, http://www.sqlservercentral.com/Forums/FindPost1291791.aspx is when it is nice to show stupid amounts of patience. It seems this person is finally starting to realize the importance of posting ddl and sample...

njdevils39 (4/27/2012)

---

Sean Lange (4/27/2012)

---

This looks excellent!!! I do have a question about your proc. It looks like you want to have this proc return data for 1 employee? If we...

This looks excellent!!! I do have a question about your proc. It looks like you want to have this proc return data for 1 employee? If we used employee #3...

I seriously doubt you need a loop for this. Take a look at the first link in my signature for best practices on posting questions. After you post ddl, sample...

LOL I honestly didn't really look very closely. The OP said they wanted to see if they could do it without sys.syscolumns. I simply used the version ChrisM wrote and...

I have worked with a few EAV systems in the past and I can tell you from my experience I would run away from this as fast as possible. It...

With this type of schema you have create a 1:1 relationship from Person to Address. You did not gain any of the advantages of normalization with this. You will 1...

That is kind of nasty. You first have to split your string, then you have a dynamic cross tab.

This really should be done in the front end. If there is...

If you are using .NET the application side of this is trivial. Just bind a datagrid to your datasource and it will generate the columns dynamically.

The sql side of this...

What is wrong with the answer you got in your other thread?

http://www.sqlservercentral.com/Forums/FindPost1290018.aspx

Please don't cross post. It just fragments responses. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1291608-1292-1.aspx

You should read the article in my signature about splitting strings. It will blow this away for performance and it will explain how to use it.

Great question!!! Glad to see some of the more obscure stuff from 2012. Makes the research more challenging since there is not much coverage of this stuff. Keep them coming...