SQLServerCentral » Latest topics
Query that returns winnings for a year and zero if no winnings for year
[code language="sql"]
create table #Achievements (Ach_ID INT, Description varchar (30), Bonus_Points int)
create table #PlayersAchievments (Player_ID INT, Ach_ID INT, Winning_Date DATE)
INSERT INTO
create table #Achievements (Ach_ID INT, Description varchar (30), Bonus_Points int)
create table #PlayersAchievments (Player_ID INT, Ach_ID INT, Winning_Date DATE)
INSERT INTO
No comments:
Post a Comment