How to do a quick / generic pivot?

[Lost User]

In MS SQL 2008 I'm often doing big SELECT * statements from a couple tables looking for data in various fields, and have to scroll sideways in the SSMS window. What I'd like to do is for every field in whatever table I'm selecting, to pivot so its name goes into FieldName, and its value into FieldValue. Then I can use sorts and quickly find what I'm looking for. I've seen some articles on PIVOTs but they are almost always hardcoded for a specific table, and use aggregates. I want something dynamic and simple. ie: SELECT * FROM AnyTable Column 1, Column 2, Column 3 Data 1, Data 2, Data 3 Into: Column 1, Data 1 Column 2, Data 2 Column 3, Data 3 I'm guessing some stored procedure is necessary but I haven't been able to find any. Does anyone have something simple in the toolbox?

[Mycroft Holmes]

Ahh now I have to explain to my collegues why I am sitting here chuckling - quick, generic and pivot all in the same sentence. There is nothing quick or generic about pivot tables. I have an article[^] that uses dynamic sql to avoid the hard coding but it is not quick and generic.

Never underestimate the power of human stupidity RAH