Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««89101112»»

How many rows are returned from the query below? Expand / Collapse
Author
Message
Posted Tuesday, March 16, 2010 6:28 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 22, 2012 7:08 AM
Points: 233, Visits: 112
I really apologize for those who felt this question is wrong.

Thanks,

Ashka Modi
Software Engineer || credEcard Technologies (india) Pvt. Ltd.
Post #883705
Posted Tuesday, March 16, 2010 10:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 20, 2014 11:55 AM
Points: 1,330, Visits: 19,306
Ninja's_RGR'us (3/16/2010)
Where's the frighing unsubscribe button????
lol top of the page, just above the page numbers, Edit Subscriptions. Think I'll follow you there...


---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #883954
Posted Tuesday, March 16, 2010 12:42 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 4:15 AM
Points: 20,581, Visits: 9,619
jcrawf02 (3/16/2010)
Ninja's_RGR'us (3/16/2010)
Where's the frighing unsubscribe button????
lol top of the page, just above the page numbers, Edit Subscriptions. Think I'll follow you there...


I wish you better luck than I'll have!!!

7,323 subscriptions, Page 1 of 367
Post #884104
Posted Tuesday, March 16, 2010 2:14 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, October 19, 2014 2:57 PM
Points: 271, Visits: 310
Thought this had been beaten to death... Time to unsubscribe as well!
Post #884172
Posted Tuesday, March 30, 2010 8:19 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, October 17, 2014 8:13 AM
Points: 9,926, Visits: 11,188
Interesting question today - a bit odd, but it makes you think, I guess.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #892820
Posted Tuesday, April 13, 2010 8:49 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 7:49 AM
Points: 212, Visits: 1,117
Aam-624390 (3/3/2010)
Seems to be a lot missing assumptions. Each given answer can be correct given different starting conditions.



Sure; and That's why i lost one point.... for the first time :)
Post #902468
Posted Monday, April 19, 2010 12:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 19, 2013 2:00 PM
Points: 183, Visits: 479
ziangij (3/3/2010)
i fail to understand what is the learning in this question. anybody plz. suggest...


It is pointless to try to find the answer to the wrong question.

Post #906287
Posted Friday, July 16, 2010 6:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 28, 2013 2:23 AM
Points: 77, Visits: 43
I also failed to understand the logic beyond this question because if I try to fire this query
WITH Users(UserID, UserName)
AS( SELECT TOP 1 intUserID, strUserName FROM tblUsers)
SELECT TOP 2 tblUsers.*, Users.* FROM tblUsers, Users
it will give me an error because the table is not existing in my database
Post #953802
Posted Thursday, January 31, 2013 5:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:11 AM
Points: 270, Visits: 236
This is act as a cross join. so 2*1 rows = 2 rows... if there is any where condition provided it acts as a normal join And we have to assume the tblUsers table is exists.....nice question.....Thanks...






Manik
************


Manik
You cannot get to the top by sitting on your bottom.
Post #1414028
Posted Thursday, August 8, 2013 8:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, November 24, 2013 11:49 PM
Points: 108, Visits: 60
Could you please explain with some data as i did not get the concept.
Post #1482352
« Prev Topic | Next Topic »

Add to briefcase «««89101112»»

Permissions Expand / Collapse