Extracting data using Live Report

Hi,

I have created one live report. In this report, I created one temporary table variable and inserting the data into this temp table and then fetching data from it as shown below.

Statement 1 -------- DECLARE @Customer TABLE (Value1 int not null, Value2 int Not Nulll)
Statement 2 -------- INSERT INTO @Customer (Value1, Value2) select DataID,CONVERT(int,Name) as 'Name' from Customers where Value1 > 10
Statement 3 -------- Select * from @Customer

This query is getting executed in SQL server management studio But givinf error for Live report. When I am trying to select the data using last statement, it is not showing any result rows.

I dont want to select the data directly from main tables. Also I dont want to use Sub-Query statements.
Is there any other way to do this?

Thanks and Regards,
Raghav Tatte

Find more posts tagged with

Comments

kandadai

Hi Raghav,

if you are using commit to commit insrted data?

Thanks

Raghav_Tatte

Hi Madhu,

I am not comming data at any point. I just declared a table variable. This variable is used only temporarily. Then I am seleting data from the table variable. But this select statement is not working,

Thanks and Regards,

Raghav Tatte

Greg_Griffiths

For such a simple select you could just do that without the table, or perhaps make use of the WITH clause instead. Another option if it is a complex query is to use a Stored Procedure and put the SQL in there and just call it in the LiveReport.