Forum Discussion
how to count data from a specific variable reporting services and management studio stored procedure
Hi I'm kind of new with management studio and reporting services, sorry for this newbies question in advance. I'm trying to count a variable's value each time its value changes. The flow is the f...
PabloN820 , use the aggregation function SUM for the result.
-------------------------- Output ------------------------ select SUM(yourColumn) AS Result from #MyTable
PabloN820 , use the aggregation function SUM for the result.
-------------------------- Output ------------------------
select SUM(yourColumn) AS Result from #MyTable
Thank you! This did the magic. Afterwards my temporal table was kind of destroyed and couldn’t get any other data from it. But managed to get it anyways. Could you suggest me some material to learn more about this?
Thank you again!! You helped me a lot.
Regards
Thank you again!! You helped me a lot.
Regards
