Professional Web Applications Themes

Please help write this query - Microsoft SQL / MS SQL Server

Assuming that Date is the primary key: SELECT SUM(myvalue) FROM Mytable WHERE [date]> (SELECT MAX([date]) FROM Mytable WHERE position<0) -- David Portas ------------ Please reply only to the newsgroup --...

  1. #1

    Default Re: Please help write this query

    Assuming that Date is the primary key:

    SELECT SUM(myvalue)
    FROM Mytable
    WHERE [date]>
    (SELECT MAX([date])
    FROM Mytable
    WHERE position<0)

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --



    David Guest

  2. #2

    Default Re: Please help write this query

    SELECT SUM(myvalue)
    FROM Mytable
    WHERE [date]>
    (SELECT MAX([date])
    FROM Mytable M1
    WHERE sign(m1.position)<>sign(Mytable.position)
    )

    Vadim Rapp

    ----------------------------------------
    Vadim Rapp Consulting
    SQL, Access, VB Solutions
    847-685-9073
    Vadim Guest

  3. #3

    Default Re: Please help write this query

    G> What about the more general problem of summing from an
    G> arbitrary date backwards until the sign of position changes?
    G> ie:

    same as my previous one, with an extra and [date]<=targetDate

    Vadim
    Vadim Guest

Similar Threads

  1. how write query to get hourly rate based on multiconditions
    By shaoguan in forum Coldfusion Database Access
    Replies: 0
    Last Post: August 9th, 07:07 PM
  2. Query of Queries on query New type query
    By david_h in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 6th, 08:55 PM
  3. Replies: 2
    Last Post: June 1st, 08:38 PM
  4. How to write this query... please help!
    By Paul Dussault in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 7th, 02:45 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