Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

SubQuery Expand / Collapse
Author
Message
Posted Monday, September 19, 2011 8:47 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 11:07 PM
Points: 19,587, Visits: 17,852
palotaiarpad (9/19/2011)
Nice question! Thanks!


You're welcome




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1177282
Posted Monday, September 19, 2011 10:39 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:46 PM
Points: 4,921, Visits: 3,988
Got it right, but it took me twenty minutes of head scratching.

Thanks!
Post #1177357
Posted Monday, September 19, 2011 2:55 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, January 19, 2016 2:00 PM
Points: 1,142, Visits: 2,716
Thanks for the question. I got it right. I haven't used this functionality yet so I was guessing a little that this is how it works.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Post #1177492
Posted Monday, September 19, 2011 4:37 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:54 AM
Points: 3,870, Visits: 2,216
I, like some others, got the question right for the wrong reason. I focused on the date declaration in the parameters and only caught the renaming of the sub-query columns after I had chosen the correct answer. Interesting behavior in regards to aliasing this way. Thanks for the question, I learned something new today!
Post #1177553
Posted Monday, September 19, 2011 4:41 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 11:07 PM
Points: 19,587, Visits: 17,852
Kenneth Wymore (9/19/2011)
I, like some others, got the question right for the wrong reason. I focused on the date declaration in the parameters and only caught the renaming of the sub-query columns after I had chosen the correct answer. Interesting behavior in regards to aliasing this way. Thanks for the question, I learned something new today!


Good to hear and glad you learned.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1177558
Posted Monday, September 19, 2011 4:41 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 11:07 PM
Points: 19,587, Visits: 17,852
Trey Staker (9/19/2011)
Thanks for the question. I got it right. I haven't used this functionality yet so I was guessing a little that this is how it works.


Good guess




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1177560
Posted Monday, September 19, 2011 4:44 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:54 AM
Points: 3,870, Visits: 2,216
Any idea as to why they would allow this behavior in a join? Seems to me like it would actually introduce more confusion than convenience.
Post #1177567
Posted Monday, September 19, 2011 4:50 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 11:07 PM
Points: 19,587, Visits: 17,852
Kenneth Wymore (9/19/2011)
Any idea as to why they would allow this behavior in a join? Seems to me like it would actually introduce more confusion than convenience.


I think they have to allow it due to the requirement that a subquery that is based on values instead of a query requires the same syntax.

Here's an article on that. http://jasonbrimhall.info/2011/08/31/bitwise-and-derived-table-revisited/




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1177572
Posted Monday, September 19, 2011 6:34 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:54 AM
Points: 3,870, Visits: 2,216
Ah, Thanks Jason. I'll check that out.
Post #1177596
Posted Tuesday, September 20, 2011 5:22 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 12:51 AM
Points: 15,023, Visits: 12,989
Nice question, thanks!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1177776
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse