Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1852

Re: CASE issue

Show all headers | View raw

In article <XnsA3F3E7E5D4C04Yazorman@127.0.0.1>, esquel@sommarskog.se 
says...
> 
> Erland Sommarskog (esquel@sommarskog.se) writes:
> > Indeed. Books Online leaves no doubt that it works like twenty-six
> > expected. I need to discuss this with Microsoft. Will first have to
> > check older versions. 
> 
> It seems like in SQL 6.5 it works like described in Books Online. SQL 2000
> works like later versions as does SQL 7. Although, note that there are 
> two patterns here: newid() and a subquery like in:
> 
>  select
>    case  (SELECT a FROM bluddrig)
>          when 1  then 'Jan'
>          when 2  then 'Feb'
>          when 3  then 'Mar'
>          when 4  then 'Apr'
>          when 5  then 'May'
>          when 6  then 'Jun'
>          when 7  then 'Jul'
>          when 8  then 'Aug'
>          when 9  then 'Sep'
>          when 10 then 'Oct'
>          when 11 then 'Nov'
>          when 12 then 'Dec'
>          when 13 then 'was 13!'
>          when 0 then 'was 0!'
>          else 'Unknown'
>    end
>      from sysobjects
> 
> 
> newid() is overall special, since it's reevaluated for every row, while
> other built-in functions are evaluated once - at least as they only appear
> once.
> 
> There is no newid() on SQL 6.5, so I can say what happens there. But on SQL 
> 7 and later, the query with the subquery, has 14 access to the table 
> bluddrig - SQL 6.5 has one.
> 
> I have not gotten any response, but the likelihood that Microsoft would
> accept this as a regression from 6.5 and change it is minimal. Not the
> least since there is a possible backwards compatibility here.
> 
> So I have filed a doc bug: 
> https://connect.microsoft.com/SQLServer/feedback/details/1042044

Very good.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

CASE issue "twenty-six@b-mint.net" <twenty-six@b-mint.net> - 2014-11-24 10:22 +0000
  Re: CASE issue Erland Sommarskog <esquel@sommarskog.se> - 2014-11-24 11:26 +0000
    Re: CASE issue bradbury9 <ray.bradbury9@gmail.com> - 2014-11-24 04:16 -0800
      Re: CASE issue Erland Sommarskog <esquel@sommarskog.se> - 2014-11-24 14:28 +0000
        Re: CASE issue Erland Sommarskog <esquel@sommarskog.se> - 2014-11-28 22:47 +0100
          Re: CASE issue Jim <jgeissman@socal.rr.com> - 2014-11-28 17:19 -0800
    Re: CASE issue "twenty-six@b-mint.net" <twenty-six@b-mint.net> - 2014-11-24 13:32 +0000
      Re: CASE issue Erland Sommarskog <esquel@sommarskog.se> - 2014-11-24 14:25 +0000
        Re: CASE issue "twenty-six@b-mint.net" <twenty-six@b-mint.net> - 2014-11-24 16:06 +0000
    Re: CASE issue Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2014-11-24 17:18 +0100
      Re: CASE issue Erland Sommarskog <esquel@sommarskog.se> - 2014-11-24 23:37 +0100
        Re: CASE issue Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2014-11-25 06:25 +0100
          Re: CASE issue Jim <jgeissman@socal.rr.com> - 2014-11-28 16:07 -0800
            Re: CASE issue Erland Sommarskog <esquel@sommarskog.se> - 2014-11-29 10:43 +0100

csiph-web