VIEWS 5

Question

VIEWS 5

Ron McCullough

SSC Guru

Points: 63877
More actions
April 2, 2012 at 9:15 pm

#255872

Comments posted to this topic are about the item VIEWS 5
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]

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

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

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

Easy one, thanks!

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

Stuart Davies SSCoach Points: 19505 More actions · Answer 2

Koen Verbeeck (4/3/2012)
Easy one, thanks!

Seconded - thanks

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 3

thanks for easy point.. 🙂

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

baabhu SSCertifiable Points: 6205 More actions · Answer 4

Hi Bit Bucket,

Thanks for the easy question.

--- Babu

Jaroslav Pfauser SSC Eights! Points: 826 More actions · Answer 5

I thought that there are radiobuttons not checkboxes 🙂

So I checked only one solution and than I was surprised, that it is wrong 🙂

M&M SSC-Insane Points: 21700 More actions · Answer 6

M&M

SSC-Insane

Points: 21700

April 3, 2012 at 4:48 am

#1468105

Good question. Thanks.

M&M

EL Jerry SSCertifiable Points: 7061 More actions · Answer 7

Thank you for the easy question and point. Made me think a little bit.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

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

Andre Guerreiro SSCertifiable Points: 7319 More actions · Answer 8

After reading through the excellent debate around views last week, I was sure what to answer even though there were few answers to choose this time. Thank you for making us not forget about this important issue. 🙂

Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA

Skanker Hall of Fame Points: 3059 More actions · Answer 9

Thanks for this. I must be learning something as I got it right, though I did hesitate before answering as it appeared too easy.

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

tks for the question.

Wonder how many would have jumped at "6 columns" for STEP 2 if it were an option...

Ron McCullough SSC Guru Points: 63877 More actions · Answer 11

OzYbOi d(-_-)b (4/3/2012)
tks for the question.
Wonder how many would have jumped at "6 columns" for STEP 2 if it were an option...

Wondered the same, but alas and alack after my series of QOD's concerning VIEWS I decided to leave this one rather simple to answer, correctly.

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]

tmhohl SSC Journeyman Points: 86 More actions · Answer 12

I <newbie> also hesitated before submitting, but got it. I'd heard some discussion regarding this from some of my peers...

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Koen Verbeeck (4/3/2012)
Easy one, thanks!

Agreed

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

Alex Fekken Ten Centuries Points: 1109 More actions · Answer 14

Thanks for rubbing it in again 🙂

And I MUST apologise for calling this a bug in another discussion: I have checked some other database engines (Firebird, trying it, and MySQL, reading some specs) and they show the same behaviour. So perhaps it *is* even prescribed by the standard?

Must be just me then not getting why this makes any sense... (walking away in shame, throwing this experience in my "don't think of SQL as a real programming language" bucket)