Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Pivot Data based on Unknown Field Items

By James Travis,

I was posed a question a few months back on another site about being about to create a Pivot Table (Horizontal version of vertical data) and I saw the question again today. This will allow you to do that, just make changes to the query where the title is the replacement need. It will build a dynamic query (sorry there is an 8000 character limit) to do this without you having too. You can also specify a time frame. Any question let me know.

Total article views: 1288 | Views in the last 30 days: 7
 
Related Articles
FORUM

Question!

Question

FORUM

Question

Question

FORUM

Question!!

Question!!

FORUM

Newbie questions

Questions....questions......did I mention questions?

FORUM

interview questions

interview questions

Tags
miscellaneous    
t-sql    
 
Contribute