try WITH(READPAST)

http://www.techrepublic.com/article/using-nolock-and-readpast-table-hints-in-sql-server/

also means:

- Biologically-Inspired Machine Learning

- basketball is my life

- Bentham Institute of Management & Languages

- Burn In My Light

- Battle Information Management Laboratory

- Bureau international de Métrologie légale

...and others

Is it possible that the error message means what it says?

"There was insufficient disk space or quota."

When I asked him, the OP said, "I've done filtering. Then, I dumped the data into temp table named process_ApplyJob_1. " I understood "filtering" to mean validation. OF...

higgim (8/18/2014)

Whilst this is fine and dandy when an insert occurs which fails the checks an...

...or add the equivalent check constraints and let SQL Server do it for you...

This is not working since you are using column names in the Pivot ON:

PIVOT (max(TeamId) FOR PersonId IN ([CoachFN], [CoachLN], [CoachEmail])) pvt

should be:

PIVOT (max(TeamId) FOR PersonId IN (PER00388878, PER00500029,PER00530907, ...))...

INSERT INTO t (LocationId, ExternalId) VALUES (@L, @E);

where not exists (

...

Since the OP provided no reason why not to use ROW_NUMBER() or temp tables (in spite of being asked again and again), I can't see why we should continue to...

Here is a complete dynamic SQL solution to the problem:

declare @CustCode int = 1;

declare @sql nvarchar(4000);

with cols(col) as (

select name

from sys.columns

where object_id = OBJECT_ID(N'[dbo].[myTable]')

and name <>...

I told you how in my last post. Follow that.

Look at the columns in the view sys.columns

You can do it without dynamic sql using SSMS. For any table, click on the Columns heading and drag to the query window. You'll get all the columns...

select * from @table1 t1

join @table2 t2

on t1.col2 = t2.col2 and t1.col3 = t2.col3 and t1.col4 =t2.col4

You might want to give some credit to IBM, who invented VM as a concept and an operating system (or hypervisor, if you like) more than 40 years ago.

IBM announced...