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