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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:33 AM
Points: 2,670, Visits: 19,244
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: Thursday, August 28, 2014 4:00 AM
Points: 21,397, Visits: 9,612
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: Tuesday, August 19, 2014 3:12 PM
Points: 268, Visits: 306
Thought this had been beaten to death... Time to unsubscribe as well!
Post #884172
Posted Tuesday, March 30, 2010 8:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Saturday, August 30, 2014 4:20 PM
Points: 11,194, Visits: 11,142
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: Thursday, August 28, 2014 11:00 PM
Points: 211, Visits: 1,113
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: Monday, August 18, 2014 3:26 AM
Points: 262, Visits: 232
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