There is a requirement to randomly generate 25,000 first and last name combinations and use them to change the names in an existing SQL Server database table. This will allow me to move a production database table into a QA database table while replacing the real names with fictitious names.
This is the description of the database table:
CREATE TABLE [dbo].[utPerson](
[personId] [int] IDENTITY(1,1) NOT NULL,
[nmFirst] [varchar](32) NULL,
[nmLast] [varchar](32) NULL,
[dob] [datetime] NULL,
[age] [tinyint] NULL,
[race] [int] NULL,
[sex] [int] NULL,
[insertDttm] [smalldatetime] NULL,
[insertorId] [int] NULL,
CONSTRAINT [PK_utPerson] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[utPerson] ADD DEFAULT (getdate()) FOR [insertDttm]
ALTER TABLE [dbo].[utPerson] ADD DEFAULT ((0)) FOR [insertorId]
You will need to provide a query that will update the 20,000+ rows in the table utPerson with randomly generated first and last names. The only columns your query should change are nmFirst and nmLast.
What are your questions?
Bu iş için 12 freelancer ortalamada $62 teklif veriyor
I will update table with using exsisting table data. I will generate names and lastnames from existing data
I've got the skills needed to complete your project ASAP. PM for details and sample
I Know this Concept...very easy concept..I can easily finish within one days..can i help u
I've done some works like these, to protect the privacity of clients properly, including random data to related tables when needed.
I will happily provide a text file with SQL commands to update the table, or with access to the QA database to the update myself. To update the table I
i am interested in your project, may i help you for this ?