Professional Web Applications Themes

redefine 2nd question on my SP help needed??? - Microsoft SQL / MS SQL Server

Here is the sql.... if quotePrice is NULL I need to copy ASKING_PRI to quotePrice. Not sure how to do it with the Join??? SELECT tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI FROM tempQuote INNER JOIN tempQuoteDetail ON tempQuote.tempQuoteID = tempQuoteDetail.tempQuoteID INNER JOIN InventoryRecord ON tempQuoteDetail.machineID = InventoryRecord.machineID WHERE (tempQuote.tempQuoteQuidID = N'7fcb611d-1321-43c2-be5d-fc97f1c2d639') AND (tempQuoteDetail.quotePrice IS NULL) -- ______________________ David Fetrow HelixPoint LLC. [url]http://www.helixpoint.com[/url] [email]davefhelixpoint.com[/email] Interested in Affordable Email Marketing? Check out the HelixMailer at [url]http://www.helixpoint.com/helixmailer.asp[/url] If you are interested in becoming a Reseller of HelixPoint products, contact [email]davefhelixpoint.com[/email] ______________________...

  1. #1

    Default redefine 2nd question on my SP help needed???

    Here is the sql.... if quotePrice is NULL I need to copy ASKING_PRI to
    quotePrice. Not sure how to do it with the Join???



    SELECT tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI
    FROM tempQuote INNER JOIN
    tempQuoteDetail ON tempQuote.tempQuoteID =
    tempQuoteDetail.tempQuoteID INNER JOIN
    InventoryRecord ON tempQuoteDetail.machineID =
    InventoryRecord.machineID
    WHERE (tempQuote.tempQuoteQuidID =
    N'7fcb611d-1321-43c2-be5d-fc97f1c2d639') AND (tempQuoteDetail.quotePrice IS
    NULL)

    --

    ______________________
    David Fetrow
    HelixPoint LLC.
    [url]http://www.helixpoint.com[/url]
    [email]davefhelixpoint.com[/email]

    Interested in Affordable Email Marketing?
    Check out the HelixMailer at [url]http://www.helixpoint.com/helixmailer.asp[/url]
    If you are interested in becoming a Reseller of HelixPoint products, contact
    [email]davefhelixpoint.com[/email]
    ______________________


    Helixpoint Guest

  2. #2

    Default Re: redefine 2nd question on my SP help needed???

    select coalesce( tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI) as
    price
    from ....

    OR

    select case when tempQuoteDetail.quotePrice is null
    then InventoryRecord.ASKING_PRI
    else tempQuoteDetail.quotePrice ) as price
    from ....

    OR

    select isnull( tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI) as
    price
    from ....


    jobi
    "Helixpoint" <davehelixpoint.com> wrote in message
    news:uWd7EOVRDHA.560TK2MSFTNGP10.phx.gbl...
    > Here is the sql.... if quotePrice is NULL I need to copy ASKING_PRI to
    > quotePrice. Not sure how to do it with the Join???
    >
    >
    >
    > SELECT tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI
    > FROM tempQuote INNER JOIN
    > tempQuoteDetail ON tempQuote.tempQuoteID =
    > tempQuoteDetail.tempQuoteID INNER JOIN
    > InventoryRecord ON tempQuoteDetail.machineID =
    > InventoryRecord.machineID
    > WHERE (tempQuote.tempQuoteQuidID =
    > N'7fcb611d-1321-43c2-be5d-fc97f1c2d639') AND (tempQuoteDetail.quotePrice
    IS
    > NULL)
    >
    > --
    >
    > ______________________
    > David Fetrow
    > HelixPoint LLC.
    > [url]http://www.helixpoint.com[/url]
    > [email]davefhelixpoint.com[/email]
    >
    > Interested in Affordable Email Marketing?
    > Check out the HelixMailer at [url]http://www.helixpoint.com/helixmailer.asp[/url]
    > If you are interested in becoming a Reseller of HelixPoint products,
    contact
    > [email]davefhelixpoint.com[/email]
    > ______________________
    >
    >

    jobi Guest

  3. #3

    Default Re: redefine 2nd question on my SP help needed???

    I need to copy ASKING_PRI to quotePrice



    "jobi" <jobireply2.group> wrote in message
    news:beejte$9ot$1reader08.wxs.nl...
    > select coalesce( tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI)
    as
    > price
    > from ....
    >
    > OR
    >
    > select case when tempQuoteDetail.quotePrice is null
    > then InventoryRecord.ASKING_PRI
    > else tempQuoteDetail.quotePrice ) as price
    > from ....
    >
    > OR
    >
    > select isnull( tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI) as
    > price
    > from ....
    >
    >
    > jobi
    > "Helixpoint" <davehelixpoint.com> wrote in message
    > news:uWd7EOVRDHA.560TK2MSFTNGP10.phx.gbl...
    > > Here is the sql.... if quotePrice is NULL I need to copy ASKING_PRI to
    > > quotePrice. Not sure how to do it with the Join???
    > >
    > >
    > >
    > > SELECT tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI
    > > FROM tempQuote INNER JOIN
    > > tempQuoteDetail ON tempQuote.tempQuoteID =
    > > tempQuoteDetail.tempQuoteID INNER JOIN
    > > InventoryRecord ON tempQuoteDetail.machineID =
    > > InventoryRecord.machineID
    > > WHERE (tempQuote.tempQuoteQuidID =
    > > N'7fcb611d-1321-43c2-be5d-fc97f1c2d639') AND (tempQuoteDetail.quotePrice
    > IS
    > > NULL)
    > >
    > > --
    > >
    > > ______________________
    > > David Fetrow
    > > HelixPoint LLC.
    > > [url]http://www.helixpoint.com[/url]
    > > [email]davefhelixpoint.com[/email]
    > >
    > > Interested in Affordable Email Marketing?
    > > Check out the HelixMailer at [url]http://www.helixpoint.com/helixmailer.asp[/url]
    > > If you are interested in becoming a Reseller of HelixPoint products,
    > contact
    > > [email]davefhelixpoint.com[/email]
    > > ______________________
    > >
    > >
    >
    >

    Helixpoint Guest

  4. #4

    Default Re: redefine 2nd question on my SP help needed???

    so you want to update the table containing quotePrice ?

    update tempQuoteDetail
    set tempQuoteDetail.quotePrice = InventoryRecord.ASKING_PRI
    FROM tempQuote
    INNER JOIN
    tempQuoteDetail
    ON tempQuote.tempQuoteID =
    tempQuoteDetail.tempQuoteID
    INNER JOIN
    InventoryRecord
    ON tempQuoteDetail.machineID =
    InventoryRecord.machineID
    WHERE tempQuote.tempQuoteQuidID = N'7fcb611d-1321-43c2-be5d-fc97f1c2d639'
    AND tempQuoteDetail.quotePrice IS NULL

    jobi
    "Helixpoint" <davehelixpoint.com> wrote in message
    news:OKTeZyWRDHA.2240TK2MSFTNGP11.phx.gbl...
    > I need to copy ASKING_PRI to quotePrice
    >
    >
    >
    > "jobi" <jobireply2.group> wrote in message
    > news:beejte$9ot$1reader08.wxs.nl...
    > > select coalesce( tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI)
    > as
    > > price
    > > from ....
    > >
    > > OR
    > >
    > > select case when tempQuoteDetail.quotePrice is null
    > > then InventoryRecord.ASKING_PRI
    > > else tempQuoteDetail.quotePrice ) as price
    > > from ....
    > >
    > > OR
    > >
    > > select isnull( tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI)
    as
    > > price
    > > from ....
    > >
    > >
    > > jobi
    > > "Helixpoint" <davehelixpoint.com> wrote in message
    > > news:uWd7EOVRDHA.560TK2MSFTNGP10.phx.gbl...
    > > > Here is the sql.... if quotePrice is NULL I need to copy ASKING_PRI to
    > > > quotePrice. Not sure how to do it with the Join???
    > > >
    > > >
    > > >
    > > > SELECT tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI
    > > > FROM tempQuote INNER JOIN
    > > > tempQuoteDetail ON tempQuote.tempQuoteID =
    > > > tempQuoteDetail.tempQuoteID INNER JOIN
    > > > InventoryRecord ON tempQuoteDetail.machineID =
    > > > InventoryRecord.machineID
    > > > WHERE (tempQuote.tempQuoteQuidID =
    > > > N'7fcb611d-1321-43c2-be5d-fc97f1c2d639') AND
    (tempQuoteDetail.quotePrice
    > > IS
    > > > NULL)
    > > >
    > > > --
    > > >
    > > > ______________________
    > > > David Fetrow
    > > > HelixPoint LLC.
    > > > [url]http://www.helixpoint.com[/url]
    > > > [email]davefhelixpoint.com[/email]
    > > >
    > > > Interested in Affordable Email Marketing?
    > > > Check out the HelixMailer at [url]http://www.helixpoint.com/helixmailer.asp[/url]
    > > > If you are interested in becoming a Reseller of HelixPoint products,
    > > contact
    > > > [email]davefhelixpoint.com[/email]
    > > > ______________________
    > > >
    > > >
    > >
    > >
    >
    >

    jobi Guest

Similar Threads

  1. Tab Order always greyed out, need to redefine order but can't
    By Dominic_De_Lello@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 5
    Last Post: July 14th, 05:06 AM
  2. Newbie question (tutorial pointers needed)
    By x.chen in forum Macromedia Dynamic HTML
    Replies: 3
    Last Post: May 14th, 12:50 PM
  3. Replies: 9
    Last Post: April 27th, 04:44 AM
  4. newbie question about compiled code--files needed
    By Steve C. Orr, MCSD in forum ASP.NET General
    Replies: 2
    Last Post: August 1st, 04: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