• Replies 4 replies
  • Subscribers 338 subscribers
  • Views 45 views
  • Users 0 members are here
Related

CASE statement help

Graeme Ellis
$organization

Hello everyone

I am trying to alter one of our stored procedures and SQL is driving me a bit loopy.  I’m trying to put an IF statement inside a CASE statement e.g.

 

case @HoldDetail when 1 then if ps.seat_status = 4 then 1 else 0 end else 0 end,

 

but SQL is having none of it.  Basically I was it to return ‘1’ if @HoldDetail is ‘1’ and ps.seat_status is ‘4’ otherwise it should return ‘0’.

 

Could you help at all?  I’m sure its pretty obvious but beyond my SQL knowledge I’m afraid

 

Thanks everso

 

Graeme

Young Vic Theatre

Parents
  • $organization


    Hi Greame

     

    You nee to use the following syntax!

     

    Helps

     

    Nick

     

    case

          when @HoldDetail = 1 and ps.seat_status = 4 then 1

          else 0

    end

     

    Nicholas Insell
    Rheolwr Cronfa Ddata
    Database Manager
    Canolfan Mileniwm Cymru
    Wales Millennium Centre

    029 2063 4672
    www.wmc.org.uk

    Dy Le Di
    Make it Yours this year

    Cysylltwch yn Gymraeg neu'n Saesneg fel dymunwch
    Contact us in English or Welsh as you prefer

    Meddyliwch am yr amgylchedd cyn printio / Please consider the environment before printing this email

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Graeme Ellis
    Sent: 29 September 2009 14:37
    To: Nick Insell
    Subject: [Tessitura Technical Forum] CASE statement help

     

    Hello everyone

    I am trying to alter one of our stored procedures and SQL is driving me a bit loopy.  I’m trying to put an IF statement inside a CASE statement e.g.

     

    case @HoldDetail when 1 then if ps.seat_status = 4 then 1 else 0 end else 0 end,

     

    but SQL is having none of it.  Basically I was it to return ‘1’ if @HoldDetail is ‘1’ and ps.seat_status is ‘4’ otherwise it should return ‘0’.

     

    Could you help at all?  I’m sure its pretty obvious but beyond my SQL knowledge I’m afraid

     

    Thanks everso

     

    Graeme

    Young Vic Theatre




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!



    Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

    This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL
Reply
  • $organization


    Hi Greame

     

    You nee to use the following syntax!

     

    Helps

     

    Nick

     

    case

          when @HoldDetail = 1 and ps.seat_status = 4 then 1

          else 0

    end

     

    Nicholas Insell
    Rheolwr Cronfa Ddata
    Database Manager
    Canolfan Mileniwm Cymru
    Wales Millennium Centre

    029 2063 4672
    www.wmc.org.uk

    Dy Le Di
    Make it Yours this year

    Cysylltwch yn Gymraeg neu'n Saesneg fel dymunwch
    Contact us in English or Welsh as you prefer

    Meddyliwch am yr amgylchedd cyn printio / Please consider the environment before printing this email

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Graeme Ellis
    Sent: 29 September 2009 14:37
    To: Nick Insell
    Subject: [Tessitura Technical Forum] CASE statement help

     

    Hello everyone

    I am trying to alter one of our stored procedures and SQL is driving me a bit loopy.  I’m trying to put an IF statement inside a CASE statement e.g.

     

    case @HoldDetail when 1 then if ps.seat_status = 4 then 1 else 0 end else 0 end,

     

    but SQL is having none of it.  Basically I was it to return ‘1’ if @HoldDetail is ‘1’ and ps.seat_status is ‘4’ otherwise it should return ‘0’.

     

    Could you help at all?  I’m sure its pretty obvious but beyond my SQL knowledge I’m afraid

     

    Thanks everso

     

    Graeme

    Young Vic Theatre




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!



    Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

    This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL
Children
No Data