SQL 2008 Management Studio
What I am trying to do is as follows:
1. search a table (multiple results will come back)
2. copy that tables row/record and create a new row/record in the same table -- basically cloning the information (but change a couple of columns within table with a static value).
How is type of query written in SQL please?
SELECT MasterAccount_ID, DisplayNameApp1