Hi,.. to all..
I have quierry in stored procecedure. ie:
select distinct Member_ID,m_displayname,brand_name,Brand_ID,produc t_id,
count(product_id) as ImagesCount from dbo.vSMgr_ImageReport
where brand_owner = @MemberID
group by brand_id, brand_name,product_id,Member_ID,m_displayname.
In the above quierry ImagesCount is the sum(product_id)...
Now i need sum(ImagesCount) how can i get using that same quierry...
Help shold be thankfull...
@shraf