10-28-2011, 01:44 PM
(This post was last modified: 10-28-2011, 01:48 PM by ravi.gajul.)
Looks like there is no syntax error as a Similar query in same format works fine for me
anyways try this
Regards,
Ravi
anyways try this
Code:
sqlquery="SELECT CMPGN_DIM_ID FROM STENCPS01.UDWHIT.CPS_ADVRTSNG_CMPGN_FACT where ADVRTSR_BRAND_DIM_ID in ("&array1(i)&")"
Set rs= gDBConnection.execute (sqlquery)
Regards,
Ravi