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 «««123

??Bug in ROW_NUMBER() + Partition BY in CTE Expand / Collapse
Author
Message
Posted Friday, November 11, 2011 5:11 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Thursday, May 17, 2012 11:38 PM
Points: 21,289, Visits: 9,326
SQL Kiwi (11/11/2011)
Ninja's_RGR'us (11/11/2011)
Cancel that... seems like the upgrade failed.
Who said there was no risk?

No-one - the phrase was "pretty small risk".



I know, hence TEST server .

Nothing corrupt, just failed... trying again.
Post #1204047
Posted Friday, November 11, 2011 5:18 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Thursday, May 17, 2012 11:38 PM
Points: 21,289, Visits: 9,326
Ok, I'm just playing with ya'll.


id10t error.

The SSMS is installed in english but part ofthe install is done in french.

I don't even want to know how they managed that.


Trying again the test in 10 minutes once THAT upgrade works. Hopefully 50% of the time is enough .
Post #1204048
Posted Friday, November 11, 2011 5:34 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Thursday, May 17, 2012 11:38 PM
Points: 21,289, Visits: 9,326
Ninja's_RGR'us (11/11/2011)
Brandie Tarvin (11/11/2011)
If you can resolve the problem by moving your WHERE clause, though, is it really that big of a deal?

I personally think you should upgrade to SP4, BTW. I'm just playing devil's advocate with the above question.



I just did update to SP4 on the test server. Still not resolved.


I'll try the same code on my other versions.


I keep on going because I don't want bugs in "my" product .




Repeat that... same results with =>


SELECT @@VERSION
--Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005
--Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)



Back to trying with other versions (our admindoesn't use non SP updates)!
Post #1204050
Posted Friday, November 11, 2011 6:16 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Thursday, May 17, 2012 11:38 PM
Points: 21,289, Visits: 9,326
I've shrunk down the db so tha I can move it around more easily and use it on express.


The bug seems gone in express R2 and Denali CTP3.


So I'll call this closed. For real this time!


Thanks again y'all.
Post #1204059
Posted Friday, November 11, 2011 6:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:10 AM
Points: 5,863, Visits: 4,701
Glad you found a solution, even if it doesn't help you right now.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Unlatched and Latchkeys: The Ugly Little Bloke (Scooby Doo meets Goosebumps meets Doctor Who) now available on Kindle U.S., Kindle U.K., and Nook. Also available on Amazon's German, French, Spanish and Italian sites.
Post #1204065
Posted Friday, November 11, 2011 6:26 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Thursday, May 17, 2012 11:38 PM
Points: 21,289, Visits: 9,326
Brandie Tarvin (11/11/2011)
Glad you found a solution, even if it doesn't help you right now.



I had the solution, I wanted to know if it was a known bug before wasting 4 hours to post the connect item for it .
Post #1204068
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse