June 28, 2013 at 1:21 pm
Hello there
I have same query for running on two different database servers with identical views, the views have same data
when I execute the query, on one server it returns the first column on ascending order(A_Id).
the same query returns unsorted on a different server on the same view
Select count(distinct Acc_nt.A_Id) as AliasOne, Acc_nt.A_ID as AliasTwo
From Acc_nt Where Acc_nt.StateNum=1 and caseyear=2013
group by Acc_nt.AccID
Acc_nt is View
what do you think is the problem.
June 28, 2013 at 1:30 pm
The problem is that you don't have an ORDER BY clause. Without it, SQL Server can't guarantee an order of the returned rows.
June 28, 2013 at 1:43 pm
Check out this article. It not only explains the "issue" you are facing, but also it can reproduce it.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply