CrossTab Query-URGENT PLEASE!

Question

CrossTab Query-URGENT PLEASE!

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

CAGreensfelder SSC Eights! Points: 919 More actions · Answer 1

'...performance will be terrible compared to the "UPDATE" method I wrote about, but the group sizes are small enough where most folks won't notice...'

Do you have a link to your description of the "UPDATE" method? I'm having trouble finding it.

I have learned a great deal from your posts and greatly appreciate your time and effort. I also TRUELY appreciate your formatting. Makes is so much easier to follow.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 2

Sure thing, CA... thanks for asking...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

... and thanks for the kudo on formatting. I do it mostly so I can read it 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

erdem1973 SSCommitted Points: 1843 More actions · Answer 3

Hello Again,

How can I prevent duplicate values on a row without using Primary keys?

For example you can easily see that Sales price2 and sales price3 are same.How can I prevent this?

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 4

erdem (2/28/2008)
Hello Again,
How can I prevent duplicate values on a row without using Primary keys?
For example you can easily see that Sales price2 and sales price3 are same.How can I prevent this?

Prevent the duplicate values where? In the report or in the original table?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 5

This topic seems very much alike this one

http://www.sqlservercentral.com/Forums/Topic475244-8-1.aspx

N 56°04'39.16"
E 12°55'05.25"

Antares686 SSC Guru Points: 125444 More actions · Answer 6

Ian Yates (2/17/2008)
And I would get your reporting tool to do the cross-tab rather than trying to bend a SQL resultset to do it. For example, both Crystal Reports and SQL Server Reporting Services can easily do cross-tabs or matrices.
A cross-tab is a display/presentation method. Use SQL to return data and then let your display package format it.

I agree, these tools will do the job more effectively than writing it in SQL. Besides what happens when you find you need to change the query? Consider what you are trying to accomplish and accomplish it with the proper tool.