A Mixed TVC

Question

A Mixed TVC

Steve Jones - SSC Editor

SSC Guru

Points: 736063
More actions
March 15, 2018 at 8:18 pm

#344433

Comments posted to this topic are about the item A Mixed TVC

Viewing 7 posts - 1 through 6 (of 6 total)

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

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

Nice question to end the week on, thanks Steve

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

Kaye Cahs SSCarpal Tunnel Points: 4135 More actions · Answer 2

Certainly thought-provoking and interesting.
I didn't know the TVC could include SELECTs. I'm not sure how I'll use this knowledge (perhaps prototyping or what-if analysis), but it's kinda fun to play with.
Thanks!

Ken SSCoach Points: 17191 More actions · Answer 3

I never considered doing this before. Fun question. Thanks Steve.

Steve Jones - SSC Editor SSC Guru Points: 736063 More actions · Answer 4

Glad you all liked it. I thought it was interesting as well.

t.ovod-everett Default port Points: 1487 More actions · Answer 5

This strikes me as similar to the use of the VALUES clause in unpivoting data.

Jason A. Long SSC-Insane Points: 23786 More actions · Answer 6

Should probably include "TOP (1)" in the selects... If, for whatever reason, the predicates allowed more than a single row in their respective result sets, you would get the following error: "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."