How does SQL 2005 tabulate works?

Asked By derick karpoff 20 points N/A Posted on - 01/30/2013

Hi TechyV users and forumers!

May I ask you, how is SQL 2005 tabulate data works? Can I create my own tabular data? What is the benefit of this data?
 

Thank You and Have a Good Day!

Derick Karpoff

• Status: Open
• Question Views: 766
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Security Software

Answered By Williams Todd 0 points N/A #156005

How does SQL 2005 tabulate works?

 

Hello,

Here is an example to show you how to use crosstab queries PIVOT in SQL Server 2005.  In this example a table is created with 3 columns. Column SalesAss, ColumnFR1 and ColumnFR2. 

// selects the three columns

SELECT SalesAssis, [FR1] AS FR2, [FR2] AS FR2

// create cross-tab results. The (ps) used to create a temporary table for the query result. 

FROM 

(SELECT SalesAssis, Product, Amount

FROM Sales ) ps

PIVOT

(

// pvt will collect the data from the query

SUM (Amount)

FOR Product IN

( [FR1], [FR2])

) AS pvt

 

The brackets are necessary so that the pivot treats the name inside the brackets as columns.

 

I hope this is helpful.

 

About Williams Todd

Questions
4

Answers
143

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 02/14/2013
• Question Category: Security Software