Adding a row to a column set

Question

Adding a row to a column set

Steve Jones - SSC Editor

SSC Guru

Points: 736183
More actions
September 10, 2018 at 8:19 pm

#77202

Comments posted to this topic are about the item Adding a row to a column set

Viewing 15 posts - 1 through 15 (of 28 total)

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

Stewart "Arturius" Campbell SSC Guru Points: 72625 More actions · Answer 1

Nice question, thanks, Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

ildjarn.is.dead Ten Centuries Points: 1164 More actions · Answer 2

ildjarn.is.dead

Ten Centuries

Points: 1164

September 11, 2018 at 12:37 am

#2005185

Shouldn't the query read 'WHERE uc.UserID = 8'?

Stewart "Arturius" Campbell SSC Guru Points: 72625 More actions · Answer 3

ildjarn.is.dead - Tuesday, September 11, 2018 12:37 AM
Shouldn't the query read 'WHERE uc.UserID = 8'?

That thought did occur to me as well.
It is still a good question, despite that.....

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

edwardwill SSCertifiable Points: 5851 More actions · Answer 4

Stewart "Arturius" Campbell - Tuesday, September 11, 2018 12:43 AM
ildjarn.is.dead - Tuesday, September 11, 2018 12:37 AM
Shouldn't the query read 'WHERE uc.UserID = 8'?
That thought did occur to me as well.
It is still a good question, despite that.....

How can it be a good question if it's a terrible question?

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 5

I've got it right, but the first and second answer seems to be equal!
Can someone clearyfy me?

ildjarn.is.dead Ten Centuries Points: 1164 More actions · Answer 6

Carlo Romagnano - Tuesday, September 11, 2018 1:14 AM
I've got it right, but the first and second answer seems to be equal!
Can someone clearyfy me?

The three sparse columns aren't returned, so 'all columns' isn't correct.

Andy sql SSCrazy Eights Points: 9496 More actions · Answer 7

Thanks Steve,
I had no idea about Column Sets before today, so your question has done exactly what it should - expand my knowledge. Perfect.
Andy

Giles Sutcliffe Ten Centuries Points: 1070 More actions · Answer 8

Queries as written return no data whatsoever, so none of the answers is correct, surely?

edwardwill SSCertifiable Points: 5851 More actions · Answer 9

Giles Sutcliffe - Tuesday, September 11, 2018 2:20 AM
Queries as written return no data whatsoever, so none of the answers is correct, surely?

That's the option I was looking for.

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 10

Giles Sutcliffe - Tuesday, September 11, 2018 2:20 AM
Queries as written return no data whatsoever, so none of the answers is correct, surely?

You aren't correct! The query returns an empty resultset with the columns and types defined in the first answer.

edwardwill SSCertifiable Points: 5851 More actions · Answer 11

Carlo Romagnano - Tuesday, September 11, 2018 2:55 AM
Giles Sutcliffe - Tuesday, September 11, 2018 2:20 AM
Queries as written return no data whatsoever, so none of the answers is correct, surely?
You aren't correct! The query returns an empty resultset with the columns and types defined in the first answer.

Not on my box it didn't!

Giles Sutcliffe Ten Centuries Points: 1070 More actions · Answer 12

Carlo Romagnano - Tuesday, September 11, 2018 2:55 AM
Giles Sutcliffe - Tuesday, September 11, 2018 2:20 AM
Queries as written return no data whatsoever, so none of the answers is correct, surely?
You aren't correct! The query returns an empty resultset with the columns and types defined in the first answer.

The UserConfigKey, the UserID, and the Options column with 3 XML nodes.

The options column contains nothing. Option 1 says it contains 3 XML nodes. None of the answers is correct.

GaryV Hall of Fame Points: 3307 More actions · Answer 13

Since you're filtering on an identity column which would only have the value 1, why would any data be returned?

William Vach SSCertifiable Points: 5538 More actions · Answer 14

Actually no rows are returned. I guessed the first answer correctly. The WHERE clause needs to be changed.