Home
Topics
SQL Server Business Intelligence (BI) and Data Warehousing
Microsoft SQL Server Reporting Services (SSRS)
Ordering the results of a SQL query

Ordering the results of a SQL query

Mark Kromer, Mark Kromer, Database Platform Specialist, Microsoft

I am using a case statement to order data on a SQL Server Reporting Services report. When the statement runs it returns the correct order, but when I save the Report Definition Language (RDL) and preview it, it returns to ascending order. How do I correct this?

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

It is a little hard to verify this without seeing the code. However, the typical rule of thumb is that if you do not explicitly order the results in a SQL query, then you are at the mercy of the database or API engine that is producing the results. Try explicitly adding an ORDER BY to your statement.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- SQL Server 2012

This was first published in September 2008

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Wixom: BI applications need visual appeal
  
  Business intelligence teams should upgrade their visual design skills to create winning applications for BI users, says IT professor Barbara Wixom.
- Business intelligence program needs long-term tending to fully blossom
  
  The evolution of Quicken Loans' business intelligence strategy from static reporting to self-service BI holds useful lessons for other organizations.
- O'Reilly Strata conference tackles big topics in data science, Hadoop
  
  The O'Reilly Strata conference was the place to be to learn about the role of the data scientist and big data technologies.
Data Center
- Is energy-efficient software the next step to reduce operating costs?
  
  When the limits of hardware innovation have been reached, energy-efficient software could be way to cut electricity costs.
- Q&A;: Markley looks to lighten load as an IaaS provider
  
  Interest in cloud continues to gain traction, so how does a small infrastructure services provider compete with the Amazon Web Services of the world?
- Big data analytics software for intelligence community goes commercial
  
  IT shops that need to analyze huge volumes of data can look to a newly available big data analytics tool that was previously reserved for the intelligence community.
Data Management
- Wikibon analyst scopes big data market, predicts explosive growth
  
  Big data technologies challenge the status quo. In this Q&A;, analyst Jeff Kelly sorts through the issues and sees big-time growth in new methods.
- Gartner Magic Quadrant finds rising demand for data warehouse services
  
  A look at the latest Gartner Magic Quadrant for Data Warehouse Database Management Systems and more data management news from around the Web.
- Business capability model helps data pros sell MDM, Gartner says
  
  Data management pros need business buy-in to get funding for MDM initiatives. Modeling business capabilities can help, according to a Gartner analyst.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Oracle Sun hardware is not for hobbyists, by a long shot
  
  Old Sun enthusiasts lament the way it used to be, and the way it will never be again. Oracle Sun hardware is a whole other animal.
- Why Ray Wang is excited about Collaborate 2013
  
  Find out what analyst R 'Ray' Wang of Constellation Research is most excited about regarding the upcoming 2013 Oracle Collaborate conference.
- What's out there for Oracle third-party tools
  
  Oracle products come with an array of integrated tools, but an ecosystem of third-party tools exists that can make an Oracle developer's life even easier.
Content Management
- Chief content officer can create value from content management noise
  
  The Google Reader RSS controversy could give chief content officers an opportunity to see what matters in content management and what doesn't.
- Rich media flood pushes digital asset management strategy to forefront
  
  Without an effective plan for managing digital assets, the increasing digital content collected by organizations could end up being a real headache.
- Avoid the pitfalls of cloud collaboration management
  
  Analyst Tim Walters explains how to build a strong case for cloud collaboration management and how to avoid problems that pop up along the way.
Windows Server
- Five things you might not know about the Hyper-V virtual switch
  
  One of the most significant improvements in Windows Server 2012 might be the Hyper-V virtual switch. What makes this low-cost option such a big deal?
- A quick look at BitLocker installation requirements
  
  A basic BitLocker installation doesn't require any unusual steps, but deploying it on Windows Server 2012 comes with a few caveats.
- How to use the BitLocker recovery options in Windows Server 2012
  
  BitLocker offers two recovery methods in Windows Server 2012. Our expert defines the options and explains how to use recovery passwords and keys.

All Rights Reserved,Copyright 2005 - 2013, TechTarget