How and where to use CASE

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Archive: Business Intelligence Troubleshoot Web service issues in SQL Server 2005 Reporting Services Ordering the results of a SQL query Using MDX and UDM in a SQL Server Analysis Services environment SSIS error message due to installation problem on SQL Server 2005 Configuring SQL Server with a changed computer name Resources for business intelligence and data mining in SQL Server 2005 Problems exporting to Excel The pros and cons of data warehousing Visual Studio report processing error Problems running SQL Server 2000 RTM without service pack SQL/Transact SQL (T-SQL) SQL language crash course (just enough to be dangerous) Working with IntelliSense in SQL Server 2008 Management Studio SQL Server Mailbag: Stored procedures, triggers and SSRS reports Working with sparse columns in SQL Server 2008 Determining the source of full transaction logs in SQL Server New GROUP BY option provides better data control in SQL Server 2008 Using the OPENROWSET function in SQL Server Loading data files with SQL Server's BULK INSERT statement Importing and exporting bulk data with SQL Server's bcp utility Testing transaction log autogrowth behavior in SQL Server SQL/Transact SQL (T-SQL) Research

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary ACID  (SearchSQLServer.com) Collaboration Data Objects  (SearchSQLServer.com) commit  (SearchSQLServer.com) container  (SearchSQLServer.com) DAO  (SearchSQLServer.com) fetch  (SearchSQLServer.com) OLE DB  (SearchSQLServer.com) query  (SearchSQLServer.com) SQL  (SearchSQLServer.com) T-SQL  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

There's an excellent article on the t-sql case statement here. This is one of my favorite sites for database development info.