Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.7K
|
I am trying to write a query to update multiple tables. Here it is: DECLARE @old_team_id AS int; DECLARE @new_team_id AS int; UPDATE Players SET team_id = @ new_team_id WHERE team_id = old_team_id UPDATE managers SET team_id = @ new_team_id WHERE team_id = old_team_id UPDATE draft SET owner_id = @newteam_id … 
|
|
|
Ok im not sure what it is I need. But I have a sort of fantasy baseball website that I want to add something to. I want to see what players have been on the most championship teams. I just don't know how to query the players against the results …
|