lundi 9 février 2015

Stored Procedure Paremeter issues


I have issue with @serviceIdInserts while executing Below sp. exec('declare @points Point_ID_TBLTYPE, @ServiceIdList Service_ID_TBLTYPE ' + @serviceIdInserts +



'EXEC US_M_REP

@COM_ID=''' + @COM_ID + ''',

@CUST_ID=''' + @CUST_ID + ''',

@UOM_ID=''' + @UOM_ID + ''',

@ST_DATE=''' + @ST_DATE + ''',

@END_DATE=''' + @END_DATE + ''',

@INCLUDE_SUB_METERS=''' + @INCLUDE_SUB_METERS + ''',

@TIME_GRANULARITY_MINUTES=''' + @TIME_GRANULARITY_MINUTES + ''',

@POINT_ID_LIST=@points,

@service_ID_LIST=@serviceIdList')




Aucun commentaire:

Enregistrer un commentaire