Do you mind sharing what one of those queries look like?

Nothing beats looking at actual code 😉

(you may change names to protect the innocent ofc)

/Kenneth

It may help to sort out...

Well, you may be on the right track.

What you have is three entities.

Region, City and Area.

You need an id for each.

RegionId, CityId, AreaId.

One region can have one to many Cities.

One...

Just for fun, another way to skin the cat.

This specific example relies on a numbers table named 'nums' with a column named 'n' that has numbers at least up to...

Yep, what Jeff shows is basically what's left when you take out the isolation level and transaction handling code. You can also remove the (rowlock) hint, it's also dead-weight here.

/Kenneth

Hmm well, I see some definitive issues here...

It's on one hand no problem to identify what is a Region, City or Area, just count the number of hyphens.. But...

How would...

This may look a little funky, but it does the job 🙂

declare @x table ( words varchar(50) not null )

insert @x

select 'This is the first line' union all

select...

Are you sure that it's deadlocks, and not blocking locks..?

Anyway, you may try to remove the serialazable transaction level, and also the begin tran/commit tran things, since they're not strictly...

Well, the total experience of a query isn't just the SQL alone.

The same query may behave differently (read: using different plans) due to differences in hardware, data, indexes, state of...

Unfortunately, I'm not much help either when it comes to OLE programming.

(It's simply not turned on on my servers) 😉

For this type of task, I use:

exec @err = master..xp_cmdshell 'move...

So this 'list' with hyphens and stuff, this is your sourcedata?

Can there be more than one region in this list?

Is your purpose to take this 'list' and store it in...

What does the plans look like?

Especially look for differences when it 'drags' and when it does not.

If I read your question right, what you're looking for is an INSERT trigger on table2, and in that trigger you place an insert statement into table1 if conditions apply.

Makes...

Ah, I didn't mean look in BOL for how to copy files using sp_OAxx procs explicitly, I ment for how to use the actual sp_OAxx procs in general. They are...

Join against the user table twice.

Once on the blocked id and once on the userid that has done the block.

That way you can get at both usernames, one from each...