ADDING NEW RESULTSETS...Possible or impossible?

Question

Post reply

ADDING NEW RESULTSETS...Possible or impossible?

Viewing 9 posts - 1 through 10 (of 10 total)

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

mrpolecat SSCertifiable Points: 7074 More actions · Answer 1

your result set is a broken image, paste the text so we can see it.

erdem1973 SSCommitted Points: 1843 More actions · Answer 2

I think this is not important.The major point is

How can I get

"results" columns as data cells

"StoreID" columns as Columns

"Question" columns as Rows

Is this a multidimensional query? I really dont know this..

erdem1973 SSCommitted Points: 1843 More actions · Answer 3

erdem1973

SSCommitted

Points: 1843

March 14, 2007 at 8:54 am

#694970

This seems a cubic structure.Right?

mrpolecat SSCertifiable Points: 7074 More actions · Answer 4

My current guess is that you want a pivot table but without knowing the table stucture I have no clue what Questions is or what Results is. the query output or table stucture is required to help you

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

Actually both are required in addition of the sample data and required output from that data.

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 6

Hey Remi! My car won't start... can you tell me what's wrong with it?...

Waddaya mean you want to pop the hood?

--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)

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

Simple problem Jeff. Nobody is in your car and no one is using the remote starter so it will remain off untill any of those conditions change .

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 8

Will a cursor fix 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)

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 9

Ninja's_RGR'us

SSC Guru

Points: 294069

March 14, 2007 at 7:41 pm

#695131

I'm sure it could .