Hi!
For this purpose, I usually create temporary table with only one record - one field here match to one variable like you mentioned. Query to it is pretty quick.
Anyway, for inserting large number of records, I would also follow BCP solution, that is the quickest approach for data transfer (after copying the entire SQL database file as is, of course).
>HI
>
>I uses DECLARE @var on Batch command.
>
>I can DECLARE @Table ( Batch Variable Table ).
>I can CREATE #Table ( Connection Temporary Table ).
>I can CREATE ##Table ( Global Temporary Table ).
>
>I need DECLARE @var DATATYPE STATIC ( Connection Static Variable ).
>
>Exists this possibility?
>
>Fabio
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.