+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 11 to 13 of 13

Thread: SQL where clause help

  1. #11
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    played with rollup...no luck. so let me see if I can just get those values in asp and then i can do the math there.

    Thanks w00f w00f!

  2. #12
    Wolfmaster Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy's Avatar
    Join Date
    Mar 2008
    Location
    Peoria, IL
    Posts
    2,386
    Blog Entries
    5
    Real Name
    Wolff
    Rep Power
    15

    Yes, after I looked at you data again, you are really wanting a Partial Rollup, which I don't think exists.
    Wolffy
    .-- ----- ..-. ..-. -.--
    Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Void where prohibited by law. Not valid in California. Your mileage may vary.

  3. #13
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    Thanks W0lffy,

    Yea, I was just trying to make it easy when pulling into asp by having the results already in sql but for this don't think its gonna happen like that, so hopefully tomorrow I'll be able to see if some "If" statements do the trick in asp to get my value then easily do the math for the rest.
    Wish me luck...i'm gonna need it.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Similar Threads

  1. Including SQL Function in WHERE Clause
    By BLaaaaaaaaaarche in forum Microsoft SQL Server
    Replies: 2
    Last Post: July 16th, 2009, 12:36 PM
  2. Using a field value in an IN(...) clause
    By richyrich in forum MySQL
    Replies: 5
    Last Post: April 13th, 2008, 12:56 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

SEO by vBSEO