Stored Proc Help!!!!!

Tue, 22 Jan 2013 05:44:12 GMT

Hi.

I have the below script to execute a stored proc but I keep on getting a syntax error. Can anyone give me the right format to start off with ( my first time doing this) Plz.

Thanx in advance.

Hein.ITR

WU_Vw:

Load

DayName,

EntryDate,

Category,

hl/hl,

[Target hl/hl],

Sort,

TypeRef,

DSort,

SiteRef,

SiteDescription,

SiteProductCategoryRef,

ProductType,

TotalWaterSupply,

Volumes

;

Sql

Declare

@DayName text,

@EntryDate datetime,

@Category text,

@hl/hl nvarchar(1000),

@[Target hl/hl] int,

@Sort int,

@TypeRef int,

@DSort int,

@SiteRef int,

@SiteDescription text,

@SiteProductCategoryRef int,

@ProductType text,

@TotalWaterSupply int,

@Volumes int

Exec <#RESULT> , '2012-04-01' , '2012-07-01' ,'Day','All',

@DayName Output,

@EntryDate Output,

@Category Output,

@[hl/hl] Output,

@[Target hl/hl] Output,

@Sort Output,

@TypeRef Output,

@DSort Output,

@SiteRef Output,

@SiteDescription Output,

@SiteProductCategoryRef Output,

@ProductType Output,

@TotalWaterSupply Output,

@Volumes Output

Select

@DayName,

@EntryDate Output,

@Category Output,

@[hl/hl],

@[Target hl/hl],

@Sort,

@TypeRef,

@DSort,

@SiteRef,

@SiteDescription,

@SiteProductCategoryRef,

@ProductType,

@TotalWaterSupply,

@Volumes

;

Re: Stored Proc Help!!!!!

Tue, 22 Jan 2013 13:16:28 GMT

I am not sure if I can answer myself,but I am going to do that if someone else wants to use this as a sample script:

SP_WU_Vw:
Load
DayName as NOD,
EntryDate,
Category,
[hl/hl] as hl_hl,
[Target hl/hl] as Target_hl_hl,
Sort,
TypeRef,
DSort,
SiteRef,
SiteDescription,
SiteProductCategoryRef,
ProductType,
TotalWaterSupply,
Volumes
;

Sql
Declare
@NOD varchar(20),
@EntryDate date,
@Category varchar(100),
@hl_hl int,
@Target_hl_hl int,
@Sort int,
@TypeRef int,
@DSort int,
@SiteRef int,
@SiteDescription varchar(100),
@SiteProductCategoryRef int,
@ProductType varchar(100),
@TotalWaterSupply int,
@Volumes int

Exec [dbo].[cc_WU_Overall] '2012-04-01' , '2012-07-01' ,'Day','All';

Store SP_WU_Vw into SP_WU_Vw.qvd (qvd);

Drop Table SP_WU_Vw;

topic Stored Proc Help!!!!! in QlikView

Stored Proc Help!!!!!

Re: Stored Proc Help!!!!!