| Description |
uspRKDPRHedgeDailyPositionDetail
uspRKDPRHedgeDailyPositionDetailByMonth
uspRKDPRInvDailyPositionDetail
uspRKDPRPreCrushPositionDetail
uspRKDPRSubHedgePositionByCommodity
uspRKDPRSubInvPositionByCommodity
The above SPs are calling fnCTGetContractBalance. It is not required to call fnCTGetContractBalance.
You can call
EXEC uspCTGetContractBalance
@intContractTypeId = NULL
,@intEntityId = NULL
,@IntCommodityId = NULL
,@dtmStartDate = '01-01-1900'
,@dtmEndDate = @dtmToDate
,@intCompanyLocationId = NULL
,@IntFutureMarketId = NULL
,@IntFutureMonthId = NULL
,@strPositionIncludes = NULL
,@strCallingApp = 'DPR'
Here @strCallingApp = 'DPR' then the SP will not return any resultset. It will insert the records in tblCTContractBalance table.
You can use the tblCTContractBalance table with your filter to insert into your table varibale in the above stored procedures.
|