Prize Wheel Winners (last 6 months):

SET NOCOUNT ON;SELECT Games_ID, Games_dtStart INTO #PWGames FROM Games WHERE Games_dtEnd > DATEADD(m, -6, GETDATE()) AND Games_dtEnd < GETDATE() AND Games_MonthlyGameID = 0 AND Games_Name LIKE '%Prize Wheel Cash%';SELECT Entry.Entry_MemberID, AboutMe_NickName, Member_FirstName, Member_LastName, Member_LoginName, Prizes_Name, Prizes_DollarAmount, CONVERT(datetime, CONVERT(varchar, Games_dtStart, 101)) AS Entry_dtWon, Games_ID INTO #PWWinners FROM Entry INNER JOIN Member ON Entry_MemberID = Member_ID INNER JOIN Prizes ON Entry_GamesID = Prizes_GamesID INNER JOIN #PWGames ON Entry_GamesID = Games_ID LEFT JOIN AboutMe ON Member_ID = AboutMe_MemberID WHERE Entry.Entry_PrizeWonID = Prizes_ID AND Entry.Entry_bForfeit = 0;SELECT #PWWinners.Entry_MemberID, AboutMe_NickName, Member_FirstName, Member_LastName, Member_LoginName, #PWWinners.Prizes_Name, #PWWinners.Prizes_DollarAmount, #PWWinners.Entry_dtWon, SUM(Prizes.Prizes_DollarAmount) AS Points FROM Prizes INNER JOIN Entry AS Spins ON Spins.Entry_PrizeWonID = Prizes_ID INNER JOIN #PWWinners ON #PWWinners.Entry_MemberID = Spins.Entry_MemberID WHERE Spins.Entry_GamesID = #PWWinners.Games_ID GROUP BY #PWWinners.Entry_MemberID, AboutMe_NickName, Member_FirstName, Member_LastName, Member_LoginName, #PWWinners.Prizes_Name, #PWWinners.Prizes_DollarAmount, #PWWinners.Entry_dtWon

[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement 'SELECT INTO' is not supported in this version of SQL Server.