Stored procedure queries

Sun, 15 Nov 2009 21:58:18 GMT

Is this the porper syntax

maxYrDate:

Directory

...\marketing_sales_data;

load

max(D1) as maxDay from sales.qvd (qvd) where Y1=$(maxSalesYr) and M1=$(maxSalesMo)

;

let

maxSalesD = peek('maxDay')

;

sales:

SQL

Execute dbo.SelectIncrementalSales $(maxSalesYr), $(maxSalesMo), $(maxSalesD);

Directory

... \marketing_sales_data;

//Concatenate Load * from sales.qvd (ansi, txt, delimiter is ',', embedded labels);

Concatenate Load * from sales.qvd (qvd);

Directory

... \marketing_sales_data;

store

sales into sales.qvd;

for incremental data load because the stored procedure doesn't seem to run. In the debug, the program just seems to skip over it.

thanks

kevin

Sun, 15 Nov 2009 21:59:23 GMT

stored procedure:

SelectIncrementalSales

@maxSalesYr

as int

@maxSalesMo

as int

@maxSalesD

as int

topic Stored procedure queries in QlikView