Table Value Constructor 1

Question

Table Value Constructor 1

Viewing 7 posts - 16 through 21 (of 21 total)

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

msurasky-905715 SSC Enthusiast Points: 195 More actions · Answer 1

This was an absolutely wicked T-SQL, but also a great challenge to understand how things are parsed. I was having a hard time understanding that the expression in the derived table in the SELECT statement was being executed for each row in #t!, but once I got it, the answer was quite obvious.

crashdan SSCommitted Points: 1990 More actions · Answer 2

OzYbOi d(-_-)b (2/27/2012)
great question. had to read more into this as I hadn't used VALUES in this way before.

same here, excellent question

j-1064772 SSCertifiable Points: 5316 More actions · Answer 3

Excellent !

First the new features of VALUES.

Then the very good link provided.

First class.

Keep 'em coming.

yannick.dinger SSC Veteran Points: 206 More actions · Answer 4

yannick.dinger

SSC Veteran

Points: 206

March 7, 2012 at 1:46 am

#1455793

This one was good... 😉

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 5

Nice question. Thanks for submitting.

http://brittcluff.blogspot.com/

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 6

SQL_Hunt

SSC-Dedicated

Points: 33518

March 15, 2012 at 1:13 am

#1459658

Very Nice Question...

Thanks.

kapil_kk SSC-Insane Points: 21316 More actions · Answer 7

nice question..

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/