Not sure whether this is the best place for this, but:
What's the best way to copy data between sharepoint lists? I have a list which I want to copy a random percentage of records from every month to another list.
I've written an SQL script to do this within the database (I'm struggling to calculate tp_Size though) but have read that this isn't best practice?
How should I go about doing this? I need to copy 2 fields for around 10 - 20 rows each month, so not a massive amount of data.
Thanks,
What's the best way to copy data between sharepoint lists? I have a list which I want to copy a random percentage of records from every month to another list.
I've written an SQL script to do this within the database (I'm struggling to calculate tp_Size though) but have read that this isn't best practice?
How should I go about doing this? I need to copy 2 fields for around 10 - 20 rows each month, so not a massive amount of data.
Thanks,