I have the following in a stored procedure
(Trying to capture value in a variable so can read it from a vb.net app)
DECLARE @TableTierCreditsMonth1 as Decimal(18,2)
DECLARE @TableTierCreditsMonth2 as Decimal(18,2)
DECLARE @TableTierCreditsMonth3 as Decimal(18,2)
;WITH TempTableTierCreditsMonth1 (Playerid,TableTheoMonth1, TablewinMonth1, TableTierCreditsMonth1)
AS
(SELECT PlayerID
,sum(Table_TheoWin) AS TableTheoMonth1
,sum(Table_Win) AS TablewinMonth1
,case when sum(Table_TheoWin) >= sum(Table_Win) * @TableTierMultiplier then sum(Table_TheoWin) else sum(Table_Win) * @TableTierMultiplier end TableTierCreditsMonth1
FROM CopyPlayerManagement..PlayerDay
WHERE AccountingDate BETWEEN @BeginDateMonth1
AND @endDateMonth1
AND Table_Games > 0
and playerid = @PlayerID
GROUP BY PlayerID)
set @TableTierCreditsMonth1 = (Select TableTierCreditsMonth1 from TempTableTierCreditsMonth1)
I get an error saying Incorrect syntax near the keyword 'SET'
Not sure why
this will work better:
Open in new window