You shouldn't have concurrency problems with #Temp tables as they're exclussive by session.

http://msdn.microsoft.com/en-us/library/ms177399%28v=sql.105%29.aspx

The question is interesting but I do wonder why would someone would disable a clustered index?

You don't need to add an extra column, you can do it all by code

--If you have STARTDATE as varchar

SELECT substring(ANUM,4,10) + '_' + substring(BNUM,2,10) + '_' + REPLACE( SUBSTRING(...

With the DDL and sample data was easy to get a solution (even if you manage to have 30 hours days :-D).

It's not the only way, but it can do...

It's not that hard what you're trying to do and you can get help really fast. But to help you, we need more information about your tables and if possible,...

This is just a guess based on what you posted.

else

BEGIN

SELECT @ID1 = NULL,

@ID2...

Some divide and conquer strategy might help, meaning to use temp tables or staging tables instead of massive union alls.

Without more details is hard to give an advise. Maybe you...

Could you post DDL for both tables? Some comments on what the columns are could be useful.

Additionaly, you could use the system views to find any Primary keys or Foreign...

I'm not sure what you're trying to do, I might need some expected results based on the data you provided. To get better help, you should post DDL and consumable...

I just keep laughing with your post, but only because it's completely right and won't fit in here. 😀

We have multiple users using same login (at least is not sa...

How about using a CASE statement to filter the years needed?

DECLARE @Something table

(

Years int,

SomeValue int

)

insert @Something(Years, SomeValue)

Values

(2000, 2)

,(2001, 4)

,(2002, 5)

,(2003, 3)

,(2004, 2)

SELECT SUM( SomeValue) SumOfAll, SUM( CASE WHEN...

I'm glad I could help. 😉

Thanks Matthew,

We're currently working with bcp with xp_cmdshell, but might try bulk_insert yo avoid possible DBAs complaints when applying code into production. There are several things to learn, but fortunately...

It's easy, but you need to define which value of db.myTable.FieldValue do you want when multiple values are available.

Any ideas here? At least some votes. 😛