I'm using SQL Server 2012 Express and I'm trying to run a command to create a new table from another
I'd like to do something like this
SELECT [RowID], [Account], [Broker], [AlgorithmName], [AlgorithmId], [Time], [XMLValue], 'Status' AS [ReportType] AS [varchar](100) NOT NULL INTO [dbo].[temp_AlgorithmLog] FROM [dbo].[AlgorithmLog_OLD]
The alias column is the part that doesn't work.
'Status' AS [ReportType] AS [varchar](100) NOT NULL
I would like to use a
SELECT INTO rather then
CREATE TABLE and
INSERT INTO SELECT
Any suggestions on how to do this if it can be done this way?
Thanks in advance