Quote performance view

[Ofina]

I'm trying to make a quote performance query and get the results to look like this:

quote# item quoted qty order 1 Supp 1 ordered qty 1 order 2 Supp 2 ordered qty 2 order …
1 item A 10 100 Supp A 10
1 item B 20 101 Supp B 20
1 item C 30 100 Supp A 25

The formatting got messed up when I pasted. I hope you can make sense of that.

I want it to have as many columns to the right as necessary, depending on how many suppliers' items are ordered off of this one quote.

Any thoughts?

I'm doing this in SSMS right now in preparation for making it a view unto itself so that I can easily bring it into Excel via an MS Query file.

 

[markros]

I think you need to look into Power Pivot for Excel. In other words, Excel allows pivoting and it may be easier than get result using dynamic SQL in T-SQL.

PluralSight Learning Library

 

[Ofina]

Oh most definitely.
However, I'm trying to get the results for the users without their having to do anything extra.

 

[starsky51]

Sounds like you will have to build a dynamic pivot query in a stored procedure. It won't be possible from a view. There is a good example of a dynamic pivot here:

http://www.sqlprof.com/blogs/sqldev...-dynamic-columns-in-sql-server-2005-2008.aspx

 

[Qik3Coder]

Sorry, somehow my post this morning wound up in a different thread.

Read this thread:
thread183-1649930

Lodlaiden

You've got questions and source code. We want both!