VBR --> OpsCenter Analytics Parity - SQL Query With Temporary Tables Do Not Work

[L_J_B]

Hi All,

We have serveral key reports in VBR that use temporary tables. They execute as expected (give results) in VBR and when run against OpsCenter using a direct ODBC link to the Database, but they give no output in the OpsCenter SQL report GUI.

Not true, they actually give a table with "Operation Status" as the heading and one row containing "Operation Is Success".

An example query would be:

CREATE TABLE #LJB_BASE_TABLE(
"first" varchar(20),
"second" varchar(20)
)
INSERT INTO #LJB_BASE_TABLE ("first","second")
VALUES ('FIRST RESULT','SECOND RESULT')

select "first" from #LJB_BASE_TABLE
drop table #LJB_BASE_TABLE

Has anyone experienced this problem? If so, what was your solution?

Thanks

L.J.B

[L_J_B]

Hi,

Does no one else use temporary tables in this way?

L.J.B

[L_J_B]

http://www.symantec.com/business/support/index?page=content&id=HOWTO43067