July 24, 2009 at 8:17 am
I dont think i understood your requirement fully.
I guess u want to insert some records in a table which is already having records from the past year. In this case you can add a column to the table "YEAR" denoting which year a particular player played. This way you can always query the table to find the players for current year.
Also i didnt understand,
They make their SQL database open to me to access
Do u mean to say each player have their own sql database which u connect remotely or what?
July 24, 2009 at 8:35 am
For 50 rows, I'd use SSIS and copy the table each week and then do the upsert.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply