Agree with the DELETE statement, would suggest to use BEGIN TRAN to be on a safe side and then COMMIT

Thanks Thomas, that's correct

i mean if we have to run your report for multiple departments.

eg. Finance, Marketing, Production same time

Hope that makes sense

Thanks for your very informative post.

if you can add how to pass multiple parameters over the stored procedure will be very useful.

Thanks again.

Hi

[Code = "sql"]

DECLARE @dayofmonth int

DECLARE @dateprmonth datetime

/* stores one day before day of the month */

SET @dayofmonth = datepart( dd,dateadd (mm,-1 ,getdate()) ) -1

/* stores the previous...

Thanks H4K, Exactly what i needed

you can make dynamic.

create table #TestTable

(

ClientId int

,Ad varchar(10)

,TagID int

,[Name] varchar(10)

,Total int

)

Insert #TestTable values (1 , 'D1', 47, 'American', 1000)

Insert #TestTable values (1 , 'D2', 47, 'American', 500)

Insert #TestTable values (1 , 'D3', 47,...

google for Cube and Rollup in sql, might be that's your answer:w00t:

Thanks Ray