mike 57299 (1/27/2010)
How do I get the values from the select statement into vars that can be work with so that I can return a single amount?
What are you trying to do here/ I'm asking about the actual problem that you're trying to solve, as there may be another way to go about it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability