Virtual table

CREATE TABLE #Report(
Cell int,
CellValue double)

Error here

DECLARE @Report TABLE (
Cell int,
CellValue double)

And here

So ... how to 开发者_C百科work with virtual table :S and why error

Try using

DECLARE @Report TABLE ( 
Cell int, 
CellValue float)

Have a look at Data Types (Transact-SQL)

You can try float, real or decimal