Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

  • RE: Help with Query

    OK, so the dynamics of this query have changed. While it serves its purpose, I'd like to view the data in a different way. Instead of just telling me what...

  • RE: Help with Query

    Nope. Just need to spit out the list based on those factors into a CSV file and I'm going to apply a simple markup in excel. Of course, doing that...

  • RE: Help with Query

    OK, sorry about that.

    table1

    prefix cost

    201220 0.50

    201221 0.49

    table2

    prefix cost

    201220 0.49

    201221 0.52

    table3

    prefix cost

    201220 0.46

    201221 0.49

    The ultimate goal...

  • RE: Help with Query

    OK, so something like this?

    WITH Table1 (ID, Val) AS

    (

    SELECT prefix, cost

    UNION ALL SELECT prefix, cost

    UNION ALL SELECT prefix,...

  • RE: Help with Query

    OK, the second query I don't quite understand. It looks like I would have to hand code each ID.

Viewing 5 posts - 1 through 6 (of 6 total)