Insert statement help needed

I have set up a trace, and have the following statement to insert the trace
results into a table named DurationTrace.
If my server were named MyServer and table DurationTrace were to have its
last column named ServerName, is there any way to include the name of the
server [MyServer] as part of the following insert statement? Or would I have
to perform the following insert, followed by an update statement?
INSERT DurationTrace
SELECT *
FROM ::fn_trace_gettable(@.path_file_ext, default)
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1Following good preactoces and always name the columns in the SELECT list as well as the INSERT
statement makes this a breeze:
INSERT INTO DurationTrace(col1, col2, ..., MachineName)
VALUES SELECT col1, col2, ... 'MyMachine'
FROM ::fn_trace_gettable(@.path_file_ext, default)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message news:5de2a069eedbd@.uwe...
>I have set up a trace, and have the following statement to insert the trace
> results into a table named DurationTrace.
> If my server were named MyServer and table DurationTrace were to have its
> last column named ServerName, is there any way to include the name of the
> server [MyServer] as part of the following insert statement? Or would I have
> to perform the following insert, followed by an update statement?
> INSERT DurationTrace
> SELECT *
> FROM ::fn_trace_gettable(@.path_file_ext, default)
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||Tibor
> INSERT INTO DurationTrace(col1, col2, ..., MachineName)
> VALUES SELECT col1, col2, ... 'MyMachine'
> FROM ::fn_trace_gettable(@.path_file_ext, default)
We do not need VALUES here.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uBwb0ZbUGHA.1564@.TK2MSFTNGP11.phx.gbl...
> Following good preactoces and always name the columns in the SELECT list
> as well as the INSERT statement makes this a breeze:
> INSERT INTO DurationTrace(col1, col2, ..., MachineName)
> VALUES SELECT col1, col2, ... 'MyMachine'
> FROM ::fn_trace_gettable(@.path_file_ext, default)
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
> news:5de2a069eedbd@.uwe...
>>I have set up a trace, and have the following statement to insert the
>>trace
>> results into a table named DurationTrace.
>> If my server were named MyServer and table DurationTrace were to have its
>> last column named ServerName, is there any way to include the name of the
>> server [MyServer] as part of the following insert statement? Or would I
>> have
>> to perform the following insert, followed by an update statement?
>> INSERT DurationTrace
>> SELECT *
>> FROM ::fn_trace_gettable(@.path_file_ext, default)
>> --
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1
>|||> We do not need VALUES here.
Correct. That for catching that. Uri.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:Oqd2L$jUGHA.1304@.tk2msftngp13.phx.gbl...
> Tibor
>> INSERT INTO DurationTrace(col1, col2, ..., MachineName)
>> VALUES SELECT col1, col2, ... 'MyMachine'
>> FROM ::fn_trace_gettable(@.path_file_ext, default)
> We do not need VALUES here.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:uBwb0ZbUGHA.1564@.TK2MSFTNGP11.phx.gbl...
>> Following good preactoces and always name the columns in the SELECT list as well as the INSERT
>> statement makes this a breeze:
>> INSERT INTO DurationTrace(col1, col2, ..., MachineName)
>> VALUES SELECT col1, col2, ... 'MyMachine'
>> FROM ::fn_trace_gettable(@.path_file_ext, default)
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message news:5de2a069eedbd@.uwe...
>>I have set up a trace, and have the following statement to insert the trace
>> results into a table named DurationTrace.
>> If my server were named MyServer and table DurationTrace were to have its
>> last column named ServerName, is there any way to include the name of the
>> server [MyServer] as part of the following insert statement? Or would I have
>> to perform the following insert, followed by an update statement?
>> INSERT DurationTrace
>> SELECT *
>> FROM ::fn_trace_gettable(@.path_file_ext, default)
>> --
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1
>|||Tibor
> Correct. That for catching that. Uri.
Did you mean thanks for catching that. Uri.?:-))))))))
It is morning here and such things happend to me too a lot
Have a nice day
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
news:ONZGsykUGHA.4340@.TK2MSFTNGP10.phx.gbl...
>> We do not need VALUES here.
> Correct. That for catching that. Uri.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:Oqd2L$jUGHA.1304@.tk2msftngp13.phx.gbl...
>> Tibor
>> INSERT INTO DurationTrace(col1, col2, ..., MachineName)
>> VALUES SELECT col1, col2, ... 'MyMachine'
>> FROM ::fn_trace_gettable(@.path_file_ext, default)
>> We do not need VALUES here.
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:uBwb0ZbUGHA.1564@.TK2MSFTNGP11.phx.gbl...
>> Following good preactoces and always name the columns in the SELECT list
>> as well as the INSERT statement makes this a breeze:
>> INSERT INTO DurationTrace(col1, col2, ..., MachineName)
>> VALUES SELECT col1, col2, ... 'MyMachine'
>> FROM ::fn_trace_gettable(@.path_file_ext, default)
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
>> news:5de2a069eedbd@.uwe...
>>I have set up a trace, and have the following statement to insert the
>>trace
>> results into a table named DurationTrace.
>> If my server were named MyServer and table DurationTrace were to have
>> its
>> last column named ServerName, is there any way to include the name of
>> the
>> server [MyServer] as part of the following insert statement? Or would I
>> have
>> to perform the following insert, followed by an update statement?
>> INSERT DurationTrace
>> SELECT *
>> FROM ::fn_trace_gettable(@.path_file_ext, default)
>> --
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1
>>
>|||> Did you mean thanks for catching that. Uri.?:-))))))))
Yep. It was morning here too when I wrote that. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:%23PKlY3kUGHA.5884@.TK2MSFTNGP14.phx.gbl...
> Tibor
>> Correct. That for catching that. Uri.
> Did you mean thanks for catching that. Uri.?:-))))))))
> It is morning here and such things happend to me too a lot
> Have a nice day
>
> <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ONZGsykUGHA.4340@.TK2MSFTNGP10.phx.gbl...
>> We do not need VALUES here.
>> Correct. That for catching that. Uri.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message news:Oqd2L$jUGHA.1304@.tk2msftngp13.phx.gbl...
>> Tibor
>> INSERT INTO DurationTrace(col1, col2, ..., MachineName)
>> VALUES SELECT col1, col2, ... 'MyMachine'
>> FROM ::fn_trace_gettable(@.path_file_ext, default)
>> We do not need VALUES here.
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
>> news:uBwb0ZbUGHA.1564@.TK2MSFTNGP11.phx.gbl...
>> Following good preactoces and always name the columns in the SELECT list as well as the INSERT
>> statement makes this a breeze:
>> INSERT INTO DurationTrace(col1, col2, ..., MachineName)
>> VALUES SELECT col1, col2, ... 'MyMachine'
>> FROM ::fn_trace_gettable(@.path_file_ext, default)
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message news:5de2a069eedbd@.uwe...
>>I have set up a trace, and have the following statement to insert the trace
>> results into a table named DurationTrace.
>> If my server were named MyServer and table DurationTrace were to have its
>> last column named ServerName, is there any way to include the name of the
>> server [MyServer] as part of the following insert statement? Or would I have
>> to perform the following insert, followed by an update statement?
>> INSERT DurationTrace
>> SELECT *
>> FROM ::fn_trace_gettable(@.path_file_ext, default)
>> --
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1
>>
>>
>