Stored procedure queries

[#1]

Is this the porper syntax

maxYrDate:

Directory

...\marketing_sales_data;

load

max(Y1) as maxYr from sales.qvd (qvd)

;

let

maxSalesYr = peek('maxYr')

;

maxMoDate:

Directory

...\marketing_sales_data;

load

max(M1) as maxMo from sales.qvd (qvd) where Y1=$(maxSalesYr)

;

let

maxSalesMo = peek('maxMo')

;

maxDayDate:

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

[#2]

stored procedure:

SelectIncrementalSales

@maxSalesYr

as int

,

@maxSalesMo

as int

,

@maxSalesD

as int