Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1169
| Path | csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Erland Sommarskog <esquel@sommarskog.se> |
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: how to use case in sql query |
| Date | Mon, 09 Jul 2012 23:47:16 +0200 |
| Organization | Erland Sommarskog |
| Lines | 18 |
| Message-ID | <XnsA08BF1FB74AEDYazorman@127.0.0.1> (permalink) |
| References | <jtf216$633$1@dont-email.me> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=windows-1252 |
| Content-Transfer-Encoding | 8bit |
| Injection-Info | mx04.eternal-september.org; posting-host="nBFDv6s1VJQDuF1w6hpX2A"; logging-data="24354"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18zJ29tDlshXcWKrp465bXx" |
| User-Agent | Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) |
| Cancel-Lock | sha1:lsWkxYt+5Gi/11g3jNk334SEMgc= |
| Xref | csiph.com comp.databases.ms-sqlserver:1169 |
Show key headers only | View raw
Tony Johansson (johansson.andersson@telia.com) writes: > I tried below but I get error probably of not understanding this fully. And the error message is? At a glance it looks correct, but you know error messages are damned helpful at times. Then again, Bob's suggestion is worth pursuing, since that could permit the optimizer to use a plan that evades a sort. With long ORDER BY you have, the sort is inevitable. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar
how to use case in sql query "Tony Johansson" <johansson.andersson@telia.com> - 2012-07-09 18:48 +0200 Re: how to use case in sql query "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2012-07-09 15:13 -0400 Re: how to use case in sql query Erland Sommarskog <esquel@sommarskog.se> - 2012-07-09 23:47 +0200
csiph-web