Professional Web Applications Themes

Nesting IF's in Stored Proc - Microsoft SQL / MS SQL Server

I am getting an error on a nested IF statement. Is this not possible in a stored procedure? For example; Create Procedure Test Variable VARCHAR(10) AS If Variable = Whatever BEGIN If (Select Count(*) from Table)) > 0 BEGIN INSERT INTO Table... END ELSE BEGIN INSERT something else INTO Table... END END...

  1. #1

    Default Nesting IF's in Stored Proc

    I am getting an error on a nested IF statement. Is this not possible in a
    stored procedure?

    For example;

    Create Procedure Test
    Variable VARCHAR(10)
    AS

    If Variable = Whatever
    BEGIN
    If (Select Count(*) from Table)) > 0
    BEGIN
    INSERT INTO Table...
    END
    ELSE
    BEGIN
    INSERT something else INTO Table...
    END
    END


    Gary Guest

  2. #2

    Default Re: Nesting IF's in Stored Proc

    You have an extra closing bracket ')' in the second IF clause. Remove it and
    SP will work fine.


    "Gary" <tuffboystlhotmail.com> wrote in message
    news:OZfxEqCRDHA.1072TK2MSFTNGP10.phx.gbl...
    > I am getting an error on a nested IF statement. Is this not possible in a
    > stored procedure?
    >
    > For example;
    >
    > Create Procedure Test
    > Variable VARCHAR(10)
    > AS
    >
    > If Variable = Whatever
    > BEGIN
    > If (Select Count(*) from Table)) > 0
    > BEGIN
    > INSERT INTO Table...
    > END
    > ELSE
    > BEGIN
    > INSERT something else INTO Table...
    > END
    > END
    >
    >

    Sudaraka Wijesinghe Guest

  3. #3

    Default Re: Nesting IF's in Stored Proc

    That was a typo in my example...but you're saying the general concept is
    sound?

    Thanks,
    Gary

    "Sudaraka Wijesinghe" <sudarakaidnw.com> wrote in message
    news:%23PLQuLDRDHA.712TK2MSFTNGP12.phx.gbl...
    > You have an extra closing bracket ')' in the second IF clause. Remove it
    and
    > SP will work fine.
    >
    >
    > "Gary" <tuffboystlhotmail.com> wrote in message
    > news:OZfxEqCRDHA.1072TK2MSFTNGP10.phx.gbl...
    > > I am getting an error on a nested IF statement. Is this not possible in
    a
    > > stored procedure?
    > >
    > > For example;
    > >
    > > Create Procedure Test
    > > Variable VARCHAR(10)
    > > AS
    > >
    > > If Variable = Whatever
    > > BEGIN
    > > If (Select Count(*) from Table)) > 0
    > > BEGIN
    > > INSERT INTO Table...
    > > END
    > > ELSE
    > > BEGIN
    > > INSERT something else INTO Table...
    > > END
    > > END
    > >
    > >
    >
    >

    Gary Guest

  4. #4

    Default Re: Nesting IF's in Stored Proc

    >>but you're saying the general concept is
    >> sound?
    Absolutely ...

    You could explain us if you have any unexpected behaviour ...

    --
    HTH,
    Vinod Kumar
    MCSE, DBA, MCAD
    SCT Software Solutions
    [url]http://www32.brinkster.com/sqlvinod[/url]


    "Gary" <tuffboystlhotmail.com> wrote in message news:ejcnjbDRDHA.2036TK2MSFTNGP12.phx.gbl...
    > That was a typo in my example...but you're saying the general concept is
    > sound?
    >
    > Thanks,
    > Gary
    >
    > "Sudaraka Wijesinghe" <sudarakaidnw.com> wrote in message
    > news:%23PLQuLDRDHA.712TK2MSFTNGP12.phx.gbl...
    > > You have an extra closing bracket ')' in the second IF clause. Remove it
    > and
    > > SP will work fine.
    > >
    > >
    > > "Gary" <tuffboystlhotmail.com> wrote in message
    > > news:OZfxEqCRDHA.1072TK2MSFTNGP10.phx.gbl...
    > > > I am getting an error on a nested IF statement. Is this not possible in
    > a
    > > > stored procedure?
    > > >
    > > > For example;
    > > >
    > > > Create Procedure Test
    > > > Variable VARCHAR(10)
    > > > AS
    > > >
    > > > If Variable = Whatever
    > > > BEGIN
    > > > If (Select Count(*) from Table)) > 0
    > > > BEGIN
    > > > INSERT INTO Table...
    > > > END
    > > > ELSE
    > > > BEGIN
    > > > INSERT something else INTO Table...
    > > > END
    > > > END
    > > >
    > > >
    > >
    > >
    >
    >
    Vinodk Guest

  5. #5

    Default Re: Nesting IF's in Stored Proc

    My problem was dumb. I had an invalid condition in my if statement, but the
    error message given was so vague I didn't realize it. I assumed the nesting
    wasn't possible. I couldn't find a good example of it online.

    Thanks for your help.

    Gary

    "Vinodk" <vinodk_scthotmail.com> wrote in message
    news:OwvWMzDRDHA.2344TK2MSFTNGP12.phx.gbl...
    >>but you're saying the general concept is
    >> sound?
    Absolutely ...

    You could explain us if you have any unexpected behaviour ...

    --
    HTH,
    Vinod Kumar
    MCSE, DBA, MCAD
    SCT Software Solutions
    [url]http://www32.brinkster.com/sqlvinod[/url]


    "Gary" <tuffboystlhotmail.com> wrote in message
    news:ejcnjbDRDHA.2036TK2MSFTNGP12.phx.gbl...
    > That was a typo in my example...but you're saying the general concept is
    > sound?
    >
    > Thanks,
    > Gary
    >
    > "Sudaraka Wijesinghe" <sudarakaidnw.com> wrote in message
    > news:%23PLQuLDRDHA.712TK2MSFTNGP12.phx.gbl...
    > > You have an extra closing bracket ')' in the second IF clause. Remove it
    > and
    > > SP will work fine.
    > >
    > >
    > > "Gary" <tuffboystlhotmail.com> wrote in message
    > > news:OZfxEqCRDHA.1072TK2MSFTNGP10.phx.gbl...
    > > > I am getting an error on a nested IF statement. Is this not possible
    in
    > a
    > > > stored procedure?
    > > >
    > > > For example;
    > > >
    > > > Create Procedure Test
    > > > Variable VARCHAR(10)
    > > > AS
    > > >
    > > > If Variable = Whatever
    > > > BEGIN
    > > > If (Select Count(*) from Table)) > 0
    > > > BEGIN
    > > > INSERT INTO Table...
    > > > END
    > > > ELSE
    > > > BEGIN
    > > > INSERT something else INTO Table...
    > > > END
    > > > END
    > > >
    > > >
    > >
    > >
    >
    >

    Gary Guest

Similar Threads

  1. cfc and stored proc
    By mcoop in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: April 13th, 05:09 PM
  2. Stored Proc problem
    By mitaka in forum ASP Database
    Replies: 1
    Last Post: May 3rd, 05:11 PM
  3. ASP vs Stored Proc vs UDF
    By Brad in forum ASP Database
    Replies: 11
    Last Post: October 28th, 01:46 AM
  4. Stored proc problem on 9.30.UC1
    By Weaver, Bill in forum Informix
    Replies: 1
    Last Post: July 9th, 02:35 PM
  5. stored proc and tcp/ip
    By Helmut Wöss in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: June 30th, 08:13 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