May i know what is the SQL query to create another intermediate column which is used to store the sum of two columns of each and every record. Thank you.

Maybe this is not what you want, can you please describe more about your requirements? SELECT column1, column2, (column1+column2) AS SumColumn FROM Table1 Shyam

Thanks for your reply, it is what i want but the output is slightly different from my expectation. cuz the new column called SumColumn displayed the sums of two zero values as 00and non zero values as 03.4, may i know how to get rid of the first zero. Thank you.

Are the columns strings? If so, you need to cast them to numbers before adding them.

you can convert to decimal like this: CONVERT(DECIMAL(9, 2), Column1+Column2) AS SumColumn Shyam Pleasemark the post as answer.

Or you can format the field in your report like this: Format(Fields!SumColumn.Value, "#.0") Shyam

Thanks for solution for sum of two column.

Thanks for sum i used it like this may be helpfull to other fellows as well. SELECT distinct(dbo.table1.ProductNum), (cast(Column1 as int) + cast(Column2 as int) + cast(Column3 as int) + cast(Column4 as int) + cast(Column5 as int) + cast(Column6 as int) + cast(Column7 as int) + cast(Column8 as int)) as sumofcolumns from Table2 Inner join dbo.Table1 on dbo.Table2.ProductNum=dbo.Table1.ProductNum where (dbo.Table2.Datestamp between CONVERT(datetime, '2010-09-01 06:00:00',102)and CONVERT(datetime, '2010-09-01 18:00:00',102)) ________________ Eric Ericcisco

in ms sql if want to create space between columns +' '+ sorry for missing before Eric