To select random records, you can execute:
SELECT TOP 10 *
WHERE ProductName = 'bike'
ORDER BY NEWID()
Now, what I want to do is incorporate the above syntax in an update statement. For example, I want to randomly select 10 rows from a table that meet one condition and then update a column with a value in each of those ten rows. Plus, I want to send to a text file to my C drive with the 10 random rows that were updated. Is this possible?