Virtual table ...

Question

CREATE TABLE #Report(
Cell int,
CellValue double)

Error here

DECLARE @Report TABLE (
Cell int,
CellValue double)

And here

So ... how to work with virtual table :S and why error

Answer 1

Try using

DECLARE @Report TABLE ( 
Cell int, 
CellValue float)

Have a look at Data Types (Transact-SQL)

You can try float, real or decimal