Professional Web Applications Themes

Compound SQL query Q - Microsoft SQL / MS SQL Server

Hey. I need to do this Copy Total operation in one, compound, SQL statement. I'd appreciate a fix for this attempt: CREATE PROCEDURE CopyBasketTotal ( FromBasketNum int, ToBasketNum int ) AS UPDATE Baskets SET Total = SELECT Total FROM Baskets WHERE BasketNumber = FromBasketNum WHERE Basketnumber = ToBasketNum I'd like to do it in one SQL statement, thanks Justin Dutoit...

  1. #1

    Default Compound SQL query Q

    Hey. I need to do this Copy Total operation in one, compound, SQL statement.
    I'd appreciate a fix for this attempt:

    CREATE PROCEDURE CopyBasketTotal
    (
    FromBasketNum int,
    ToBasketNum int
    )

    AS

    UPDATE Baskets

    SET
    Total = SELECT Total

    FROM Baskets

    WHERE BasketNumber = FromBasketNum

    WHERE
    Basketnumber = ToBasketNum


    I'd like to do it in one SQL statement, thanks

    Justin Dutoit


    Justin Guest

  2. #2

    Default Re: Compound SQL query Q

    Justin


    CREATE PROCEDURE CopyBasketTotal
    (
    FromBasketNum int,
    ToBasketNum int
    )

    AS

    UPDATE Baskets
    SET
    Total = (SELECT top 1 Total FROM Baskets WHERE BasketNumber =
    FromBasketNum)
    WHERE
    Basketnumber = ToBasketNum


    --
    I hope this helps
    regards
    Greg O MCSD
    SQL Scribe Doentation Builder
    Doent any SQL server database in minutes
    Programmers love it, DBA dream of it
    AGS SQL Scribe download a 30 day trial today
    http://www.ag-software.com/ags_scribe_index.asp




    "Justin Dutoit" <com> wrote in message
    news:OdSL%238$phx.gbl... 
    statement. 


    Greg Guest

  3. #3

    Default Re: Compound SQL query Q

    Justin,

    The procedure you posted already consists of just
    one SQL statement, but there are missing parentheses.

    Try

    UPDATE Baskets
    SET
    Total = (
    SELECT Total
    FROM Baskets
    WHERE BasketNumber = FromBasketNum
    )
    WHERE Basketnumber = ToBasketNum

    -- Steve Kass
    -- Drew University
    -- Ref: F9B4372D-6A59-45BB-848B-6A8823244CE3

    "Justin Dutoit" <com> wrote in message
    news:OdSL#8$phx.gbl... 
    statement. 


    Steve Guest

Similar Threads

  1. mySQL compound query
    By dylan in forum MySQL
    Replies: 1
    Last Post: September 18th, 11:47 PM
  2. Compound and foreign keys
    By Jimi Hullegård in forum MySQL
    Replies: 3
    Last Post: October 22nd, 10:23 AM
  3. possible bug with compound index.
    By Stephan in forum PostgreSQL / PGSQL
    Replies: 7
    Last Post: February 17th, 01:46 PM
  4. Compound Paths in CS
    By Steph_Bannister@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 7
    Last Post: March 2nd, 10:19 PM
  5. Compound Key vs Composite Key
    By CJM in forum ASP Database
    Replies: 4
    Last Post: October 30th, 12:30 PM

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