AKKKKK!!! Too slow, and Lynn's solution is better.

How about:

create table #tablea (

ta_id int not null,

bname varchar(20) not null)

create table #tableb (

customer varchar(20) not null,

c_date date not null,

ta_id int not null)

insert #tablea ( ta_id, bname) values (1,'Nasdaq')

insert...

This is the same thing Lynn is asking for on the other thread. Please don't double post.

Replies should go here:http://www.sqlservercentral.com/Forums/Topic1313354-391-1.aspx

For homework help, the standard on the forum has usually been that you should give it a try first and then ask for help where you get stuck.

But a couple...

BCP is the command line bulk insertion utility. It can be called like any other OS command line executable in SSIS or a batch file. If you can pull the...

I'd look at either BCP or Bulk Insert for this. It would be a lot faster also. Where is the data coming from?

The sql I sent you should do that. Did you try it?

Also, it looks like you're using a SQL Server 2000 client to connect to a 2008R2 server. That should probably be upgraded to the SQL Server 2008 Native Client....

Give this a try:

SELECT S.value('(@applicationId)[1]', 'int') AS ApplicationID,

S.value('(@startTime)[1]', 'time') AS StartTime,

S.value('(@startDate)[1]', 'date') AS StartDate,

S.value('(@direction)[1]', 'varchar(max)') AS Direction,

S.value('(@token)[1]', 'varchar(max)') AS Token,

S.value('(@bridged)[1]', 'varchar(max)') AS Bridged,

S.value('(@callerId)[1]', 'bigint') AS CallerId,

S.value('(@sessionId)[1]', 'varchar(max)') AS SessionId,

S.value('(outboundDialString/@dialString)[1]',...

When run from SQL Server, the batch file executes under the credentials of the service account under which the SQL Server runs, not your id. Make sure that the...

First thing you might look for is if the delimiter you've picked is showing up in the data itself and not just between columns. That's the most common cause...

There are lots of things that can change the order in which data is retrieved. The only way to guarantee a certain retrieval order is with an 'order by'...

Normally, you'd do this kind of formatting in the front end, not in tsql. But this might help

declare @x decimal(12,2)

declare @z varchar(50)

declare @y int

set @x = 61.13

set @z...

My understanding was that, if the server is connecting to an internet web server ( as opposed to something internal) you can't use the CAL licensing model. You have...

And just to clarify...

It's always better if, when asking questions, you post DDL for all the objects concerned, some sample data in a form that will be easily inserted into...