I don't understand. The string you provided has over 50 tabs in it. But you say it's tab separated and putting 15 columns into 1 and has 4 other columns.

What...

Here's a guess at what you want:

(
    SELECT 'Table1' TableName,ID,Col1,Col2,Col3,Col4
      FROM Table1 t1
     WHERE EXISTS(SELECT...

Pedantic here!: It is also grammatically incorrect; it should be "an object" not "a object"

When you are entering code in a post there is a little button you can press so it shows as code, this makes it easier for people to read your...

MAXRECURSION number

Specifies the maximum number of recursions allowed for this query. number is a nonnegative integer between 0 and 32,767. When 0 is specified, no limit is applied. If this option isn't specified,...

It's the insert and update that are locking the table.

You can ignore these locks by using the nolock hint:

select count(*) 
  from mytable with...

It's the insert and update that are locking the table.

You can ignore these locks by using the nolock hint:

select count(*) 
  from mytable with (nolock)

wait until you get an application that wants to create sql agent jobs and then delete them after.  not a hope in hell stopping that process running as...

Could you drop the original table and rename the backup table to have the same name?

If they are that bad then write them an application with pre-written queries. Otherwise just give them access to SSMS with appropriate permissions.

One good reason for an application to only use stored procedures to access data is that you don't have to give the application-user permissions on the tables to select/update/insert/delete. The...

What's the query and what indexes do you have on the table? and how on Earth do you expect people to make out a tiny screen dump of an execution...

Sorry... Missed Jonathan's post, which appears to be spot on.  Jonathan, how did you figure out it was a rail schedule and where to get the documentation on it? ...

I don't really feel like I should be defending myself here, but 'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P' is 57 characters long, the length of all those columns is...

getting the data into the database isn't an issue its breaking out the the differing record types ...

However I have manged to re-code my procedure it will now load...