Table Value Constructor 1

Question

Table Value Constructor 1

Ron McCullough

SSC Guru

Points: 63877
More actions
February 25, 2012 at 7:13 pm

#252191

Comments posted to this topic are about the item Table Value Constructor 1
If everything seems to be going well, you have obviously overlooked something.
Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]
February 27, 2012 at 2:20 am

This was removed by the editor as SPAM

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

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Nice question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

baabhu SSCertifiable Points: 6205 More actions · Answer 2

Good Question. Today I learned something new !!!!.

honza.mf SSCertifiable Points: 5519 More actions · Answer 3

Nice constructor. Alas we are limited by older version.

See, understand, learn, try, use efficient
© Dr.Plch

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 4

(sorry for cheating) but I really don't get it 🙁

(by the way the question is really cool, i know remember one requirement which I had on the similar thing where there are two dates column and each can contain null and actually i need to list all the values in DESC (from both column) as one column, if A is null then take it from B....) I can understand this but I having hard time understanding the logic and the ways the SQL statement is written.:w00t:

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

call.copse SSCoach Points: 18048 More actions · Answer 5

FFS worked the answer out but still selected the wrong one in the list. Must stop doing that - twice this year now.

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 6

nice question !!!

thanks Ron!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Thomas Abraham SSChampion Points: 10761 More actions · Answer 7

Thanks for the question. It was very useful, and presented in a way that required thought, but without parsing dozens of lines of text. Excellent.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Dana Medley SSCertifiable Points: 6764 More actions · Answer 8

To get my mind going I can think of no better way than answering the question of the day! Great question. 🙂

Everything is awesome!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Thanks for the ¿

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

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

Very good question.

I really really really learnt a new good feature.

Thank you a lot.

😛

EL Jerry SSCertifiable Points: 7063 More actions · Answer 11

Great question!!! Learned something new today.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 12

great question. had to read more into this as I hadn't used VALUES in this way before.

TomThomson SSC Guru Points: 104773 More actions · Answer 13

Good question - made me think hard.

When I first looked at it I hadn't a clue what it was doing, it took me quite a few minutes staring it and wondering what on earth it meant to realise that a single column table was being generated for each row of the starting table and the max taken from that.

Good references in the explanation too (although as the question specified SQL 2008 R2 and Denali it was a bit odd to reference the SQL 2008 BoL page instead of the SQL 2008 R2 one).

But something seems to be wrong with the wording of the explanation, I can't work out what the bit before the comma means.

Tom