The attached code below works but now I'd like to insert EmployeeID and RandomDateTime into a new table. I want Dept, Firstname and Lastname to show when it's run but I don't need to save that to the new table.
I tried the following but I get the error...
There is already an object named 'SOGItblRandom' in the database.
I want to be able to append the new results to the same table each time it's run. How do I do that?
...
,CURRENT_TIMESTAMP As RandomDateTime
INSERT INTO [TCP].[dbo].SOGItblRandom
FROM [TCP].[dbo].[EmployeeList]
...
SELECT TOP (SELECT cast(round(25 * COUNT(EmployeeID) * 1.0/ 100, 0) as integer) FROM [TCP].[dbo].[EmployeeList] WHERE Department = ('SR7012') AND [Suspend] <> 1 ) [EmployeeId] ,[Department] ,[FirstName] ,[LastName] ,CURRENT_TIMESTAMP As RandomDateTimeFROM [TCP].[dbo].[EmployeeList]WHERE Department = ('SR7012') AND [Suspend] <> 1ORDER BY NEWID()
SELECT TOP (SELECT cast(round(25 * COUNT(EmployeeID) * 1.0/ 100, 0) as integer) FROM [TCP].[dbo].[EmployeeList] WHERE Department = ('SR7012') AND [Suspend] <> 1 ) [EmployeeId] ,[Department] ,[FirstName] ,[LastName] ,CURRENT_TIMESTAMP As RandomDateTimeINTO [TCP].[dbo].SOGItblRandomFROM [TCP].[dbo].[EmployeeList]WHERE Department = ('SR7012') AND [Suspend] <> 1ORDER BY NEWID()
Open in new window