Käynnissä

1494 MSSQL Data Scramble Script

I need a small SQL script that will take four fields from a table and randomly swap them with different records. Example: Take Field 1, go through each record and randomly swap the Field 1 data with another Field 1 record in the table, go to Field 2 and do the same, Field 3 and then Field 4. It must do this for each record to get as randoma a result as possible. I'll probably run the script a few times on the table data. None of the fields will be key fields. The reason is to take an existing DB to use in a test environment. I have attached a script to allow you to create the table. This is a pretty straightforward script and I would expect it done in no more than 1 day.

Taidot: kaikki käy, SQL

Näytä lisää: mssql scramble script, sql script scramble data, mssql data scramble script, data scramble script sql, sql script , anything go, small data table, sql create script, script sql table, scramble, data key, table create script, create table script sql, result script, mssql example, script swap, environment mssql script, sql create records, use existing script, script field, sql create test records, record script, script mssql, key data, sql mssql

About the Employer:
( 89 reviews ) Winnipeg, Canada

Projektin tunnus: #1752363

Myönnetty käyttäjälle:

claudiurogoveanu

Let's do it Thanks Claudiu

45 $ USD 0 päivässä
(60 arvostelua)
5.2