Viewing 5 posts - 1 through 6 (of 6 total)
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...
March 2, 2014 at 7:16 am
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...
December 16, 2013 at 6:38 pm
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...
December 16, 2013 at 6:15 pm
OK, so something like this?
WITH Table1 (ID, Val) AS
(
SELECT prefix, cost
UNION ALL SELECT prefix, cost
UNION ALL SELECT prefix,...
December 16, 2013 at 5:48 pm
OK, the second query I don't quite understand. It looks like I would have to hand code each ID.
December 16, 2013 at 5:39 pm
Viewing 5 posts - 1 through 6 (of 6 total)