make sth. like pivot with mssql 2000

Expand Post »

--query of a very large table
SELECT
abc AS 'productname',
xyz AS 'quantity'

INTO #tmptable

FROM
dfg

WHERE
blah

--
--content of #tmptable:
--productname quantity
--product1 5
--product2 3
--product1 2
--product2 8
--product1 5
--

how does a query on #tmptable look like, if I want to receive the following result?

productname quantity
product1 12
product2 11
???

thank you in advance!

phantom.der.oma

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jan 2009

Permalink

Jan 14th, 2009

Re: make sth. like pivot with mssql 2000

Have a look on http://sqlserver2000.databases.aspfa...vot-query.html

Ramy Mahrous

Featured Poster

Reputation Points: 480

Solved Threads: 276

Postaholic

Offline

2,189 posts
since Aug 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Where is AlwaysUseDefaultCodePage?

Next Thread in MS SQL Forum Timeline: Copying ASP.NET's default member info database

DaniWeb Message

Cancel Changes

User Name
Password