Professional Web Applications Themes

"IF" statement and views - Microsoft SQL / MS SQL Server

Is it possible to use an if statement in a view? example of what I would like to do: select contribid, sum(iif(contribtype = 'mon', amt, 0) as moncontrib, sum(iid(contribtype = 'prd', amt, 0) as prdcontrib from hcontrib IIF does not seem to work when I am generating the view. Any suggestions that do not require me to create subqueries and then join them -jeff...

  1. #1

    Default "IF" statement and views

    Is it possible to use an if statement in a view?

    example of what I would like to do:

    select contribid,
    sum(iif(contribtype = 'mon', amt, 0) as moncontrib,
    sum(iid(contribtype = 'prd', amt, 0) as prdcontrib
    from hcontrib

    IIF does not seem to work when I am generating the view.
    Any suggestions that do not require me to create
    subqueries and then join them

    -jeff
    Jeff Guest

  2. #2

    Default Re: "IF" statement and views

    Look into using the CASE function instead. Refer to BOL for sytax help.

    HTH
    Prasad.

    "Jeff Friedman" <com> wrote in message
    news:102701c35aa7$7c1b0650$gbl... 


    Prasad Guest

  3. #3

    Default Re: "IF" statement and views

    hi jeff,

    the query can be re-written using Case Statement

    SELECT contribid,
    CASE WHEN (contribtype ='mon')
    THEN sum(Amt) ELSE 0 END as moncontrib,
    CASE WHEN (contribtype ='prd')
    THEN sum(Amt) ELSE 0 END as prdcontrib
    FROM hcontrib
    GROUP BY contribid, contribtype

    regards
    Hari Sharma, India


    "Jeff Friedman" <com> wrote in message news:<102701c35aa7$7c1b0650$gbl>... 
    hkvats_1999@yahoo.com Guest

Similar Threads

  1. How can I callError ocurring when Event Listener methodein "for statement" is called
    By aljeskica in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: May 2nd, 08:40 AM
  2. Replies: 21
    Last Post: August 18th, 04:32 PM
  3. Is Win32::OLE qw(EVENTS) ~ to the VBA "Impliments" statement?
    By psyshrike in forum PERL Miscellaneous
    Replies: 0
    Last Post: September 14th, 07:35 PM
  4. Replies: 2
    Last Post: July 10th, 06:37 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139