SQL query in PB

[docky5]

HI,

My problem is that one of the DW gets data from an sql query result. I use if..else in it but somehow both part runs (the if and the else part as well...)
I run the script in Query Analyzer and by using BEGIN ..END on the ELSE part it worked and retrieved only once the result...BUT my problem is in PB 8.0.3 it doesn't work..PB doesn't recognize the BEGIN only the END.

How could I overlay it or any idea how could I skip it?

Thx

 

[mbalent]

Can you provide a short example?

Matt

"Nature forges everything on the anvil of time

 

[docky5]

Hi,
here is the SQL, both part of the IF produces a !?result set?!(don't know how) at the second run....BUT if I use BEGIN - END on the ELSE part select in Query Analyzer then it works properly! But PB doesn't recognize the BEGIN word so I can't use BEGIN - END...how could I replace that?:

If exists(select * from tempdb.dbo.sysobjects where name = '##temptable')
Select * from ##temptable order by counter
ELSE
Select AR1.Cust_Code,
AR1.Cust_Name,
IDENTITY(int,1,1) as counter
INTO ##temptable
FROM AR1
WHERE ( AR1.Del_Flag = 'N' ) order by Cust_Name
select * from ##temptable order by counter

 

[mbalent]

Put your sql into a stored proc which returns a result set and use that to create your datawindow.

Matt

"Nature forges everything on the anvil of time