Professional Web Applications Themes

Syntax help - Microsoft SQL / MS SQL Server

INSERT StartStop_Case_ID SELECT value1, value2 FROM personnel WHERE ogin_name = Host_Name() AND Var1 IN ('PT', 'PA', 'SA', 'LT') "Buddy G" <Buddy at gcsbend dot com> wrote in message news:phx.gbl...  it.  get ...

  1. #1

    Default Re: Syntax help

    INSERT StartStop_Case_ID
    SELECT value1, value2 FROM personnel
    WHERE ogin_name = Host_Name()
    AND Var1 IN ('PT', 'PA', 'SA', 'LT')



    "Buddy G" <Buddy at gcsbend dot com> wrote in message
    news:phx.gbl... 
    it. 
    get 


    Aaron Guest

  2. #2

    Default Re: Syntax help

    Ah, the IN "thing"
    Maybe I should have included the whole code snippet:

    CREATE PROCEDURE stp_get_case_status AccID int AS

    begin
    DECLARE Var1 varchar (30)
    DECLARE Var2 varchar (30)
    DECLARE Var3 char (2)

    SELECT Var1 = Left(First_name,1)+Last_name FROM personnel (nolock)
    WHERE login_name = Host_Name()
    SELECT Var2 = Accession_No FROM Accession (nolock)
    WHERE id = AccID
    SELECT Var3 = persnl_class_id FROM personnel (nolock)
    WHERE login_name = Host_Name()
    IF Var3 = 'PT' OR 'PA' OR 'SA' OR 'LT
    INSERT INTO StartStop_Case_ID (UserName, Accession_No)
    Values (var1, var2)
    end

    Can you make this elegant?

    Thanks, Buddy G

    "Aaron Bertrand - MVP" <com> wrote in message
    news:phx.gbl... 
    > it. 
    > get 
    >
    >[/ref]


    Buddy Guest

  3. #3

    Default Re: Syntax help

    Well, I can eliminate one of your SELECTs, but that's about it



    CREATE PROCEDURE stp_get_case_status
    AccID INT AS
    BEGIN
    SET NOCOUNT ON
    DECLARE Var1 VARCHAR(30),
    Var2 VARCHAR(30)
    Var3 CHAR(2)

    SELECT
    TOP 1
    Var1 = Left(First_name,1)+Last_name,
    Var3 = persnl_class_id
    FROM
    personnel (nolock)
    WHERE
    login_name = Host_Name()
    AND persnl_class_id IN ('PT', 'PA', 'SA', 'LT')
    -- ORDER BY something?

    IF ROWCOUNT = 1
    BEGIN
    SELECT
    Var2 = Accession_No
    FROM
    Accession (nolock)
    WHERE
    id = AccID

    INSERT StartStop_Case_ID
    (
    UserName,
    Accession_No
    )
    VALUES
    (
    var1,
    var2
    )
    END
    END


    "Buddy G" <Buddy at gcsbend dot com> wrote in message
    news:#phx.gbl... [/ref][/ref]
    do [/ref][/ref]

    > >
    > >[/ref]
    >
    >[/ref]


    Aaron Guest

  4. #4

    Default Re: Syntax help

    Aaron, thank you!

    Buddy G
    "Aaron Bertrand - MVP" <com> wrote in message
    news:%phx.gbl... [/ref]
    > do [/ref][/ref]
    if 
    > >
    > >[/ref]
    >
    >[/ref]


    Buddy Guest

Similar Threads

  1. if/else tag syntax
    By negttid in forum Macromedia Flex General Discussion
    Replies: 8
    Last Post: March 20th, 02:15 AM
  2. Syntax again - Help!
    By Geoff in forum Macromedia Flash Sitedesign
    Replies: 4
    Last Post: November 18th, 11:23 PM
  3. Need Help With Syntax!
    By Aaron Bertrand - MVP in forum ASP Database
    Replies: 10
    Last Post: August 7th, 03:44 PM
  4. Syntax
    By yma in forum ASP.NET General
    Replies: 1
    Last Post: July 3rd, 02:00 PM
  5. Help with DB2 Syntax.
    By sharads in forum IBM DB2
    Replies: 1
    Last Post: July 3rd, 09:04 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