Sorting issue when deployed

Question

Post reply

Sorting issue when deployed

mbrady5

SSCrazy

Points: 2835
More actions
January 12, 2012 at 6:21 am

#248843

Hello,
I am having an issue where my column sort is recognized and working in BIDS but when deployed it is not sorting properly. I am developing using 2008R2 and deploying to a 2008 non-R2 environment. Could that be an issue? Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

does your dataset have an ORDER BY?

remember, there is no "default" sorting.

if you do not explicitly order your results, there's no guarantee they will be in any given order.

SQL would be free to get the data in whatever order it deems to be fastest, which you are seeing here varies from one server, or one database to teh other.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mbrady5 SSCrazy Points: 2835 More actions · Answer 2

I do not have an order by in the statement by design

mbrady5 SSCrazy Points: 2835 More actions · Answer 3

Got it...sorted in row groups....now everything is PERFECT. Thanks for your response.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

I take it that means you have a Sort transformation in your data flow instead? What makes you think your data isn't being sorted properly?

John

Lowell SSC Guru Points: 323518 More actions · Answer 5

glad you got it all sorted out!

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!