Expand|Select|Wrap|Line Numbers
- SELECT
- ContractId = @ContractId, BusinessUnitId = B1.BusinessUnitId, B1.ServiceId, B1.CampaignId,
- TotalCount = F1.TotalCount,
- EligibleCount = F1.EligibleCount,
- UnitPrice = F1.UnitRate,
- TotalPrice = Convert(decimal(20,10),0.00),
- BusinessUnitExpenseId = NULL,
- IsFixed = CONVERT(bit,'False'),
- FixedAmtDealType = CONVERT(varchar(3),''),
- ShowFixedAmtDealType = @ShowFixedAmountWithDealType
- INTO
- #TempAccountDetails
- FROM
- BusinessUnitAccountingSummaryData AS B1
- CROSS APPLY dbo.func_GetServiceContractFigures(@StartDate, @EndDate, @Service, @BUId, B1.CampaignId) AS F1
- WHERE
- B1.ServiceId = @Service
- AND B1.BusinessUnitId = @BUId
- AND B1.Date BETWEEN @ContractStartDate AND @ContractEndDate
- GROUP BY B1.ServiceId, B1.CampaignId, B1.BusinessUnitId