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 droptable.com
http://www.droptable.com/Uwe/Forum...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 droptable.com" <u3288@.uwe> wrote in message news:5de2a069eedbd@.uwe...[vbcol
=seagreen]
>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 droptable.com
> http://www.droptable.com/Uwe/Forum...server/200603/1[/vbcol]|||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 droptable.com" <u3288@.uwe> wrote in message
> news:5de2a069eedbd@.uwe...
>|||> 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
> We do not need VALUES here.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:uBwb0ZbUGHA.1564@.TK2MSFTNGP11.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...
> 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...
>|||> 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.gb
l...
> Tibor
> 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...
>

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 droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
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 droptable.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 droptable.com
> http://www.droptable.com/Uwe/Forums...erver/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 droptable.com" <u3288@.uwe> wrote in message
> news:5de2a069eedbd@.uwe...
>
|||> 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
> 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...
>
|||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...
> 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...
>
|||> 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
> 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...
>