SQL script to generate QVD?

[ganeshreddy]

Hi All,

How to generate a qvd to get fields with following SQL Script, please give me QlikView table structure script for this.

;WITH LOB_CTE(LOB_CODE,LOB_DESCRIPTION,PARENT,TOPPARENT,DEPTH) AS

(

  SELECT A.LOB_CODE,

  A.LOB_DESCRIPTION,

  A.PARENT,

  A.LOB_CODE AS TOPPARENT,

  0 AS DEPTH

FROM Dim_LOB A WHERE Parent='20BSU0000'

UNION ALL

SELECT C.LOB_CODE,

  C.LOB_DESCRIPTION,

  C.PARENT,

  LOB_CTE.TOPPARENT,

  LOB_CTE.DEPTH+1 AS DEPTH

  FROM Dim_LOB C

INNER JOIN LOB_CTE

  ON LOB_CTE.LOB_CODE = C.Parent 

  )

Cheers,

Ganesh.

[krishna_2644]

Make sure you end the statement with a semi colon ';' .

[#3]

Hi Krishna Chaitanya,

                             can you pls give me complete script for multiple qvd generators:

I have to create many:

for loop script  with sql db table names  like:

sql select * from "SF_Con".dbo."EMP_COMP";

sql select * from "PD_DATA".dbo."ORG_NM";

sql select * from "AFS_VAL".dbo."DBNM_SF";

into qvd's with single  store command

Thanks In Adavnce

[#4]

Can anybody pls help me  with this