thanks so much for the help. My resulting sql looks like this:
Total 94561 7855
One row with 2 or 3 columns. I can change it around though if needed.
So I'm trying to get the top of the gague to be 94,561, and the filler part to only read 7,855. The goal of 94,561 is a monthly goal and onlu changes at the beginning of every month. The "actual" number of 7,855 increases steadily throughout the month as we try to reach our goal.
My script looks like this:
SELECT
'Total',(SELECT SUM(totalprocessed) FROM vw_total_numbers_0
WHERE RIGHT(trust,4) = 'goal') AS 'Total Goal',(SELECT SUM(totalprocessed) FROM vw_total_numbers_0
WHERE RIGHT(trust,4) <> 'goal') AS 'Actual'
Thanks again!