Makes sense.

Wouldn't surprise me if you're on the right track on that one. It may be trying to update SQL Server and either failing, or not restarting it.

If you're inserting one row at a time in each, take a look at "Scope_Identity" in Books Online. See if you can use that for what you need.

If not,...

Does this help?

declare @XML XML;

select @XML = ' ';

select x.y.value('local-name(.)', 'VARCHAR(50)'),

x.y.value('.', 'VARCHAR(50)')

from @XML.nodes('//*') x(y);

That's sample XML, but it pulls name-value pairs from it, and that sounds like what you...

Why does it have to be a case statement?

Can you provide the table definitions and some sample data?

I would say that retaining the nulls is the correct handling in this case. That's what the feature is for.

Can you be more specific as to what the problem is? Is it just the issue of getting the ID from one table to insert into the second table?...

Nolock doesn't really do anything to updates at all. Won't do what you need.

Deadlocks aren't caused by people/systems accessing the same data at the same time. They're caused...

Given those circumstances, I'd probably not bother normalizing.

I'm not sure what VB has to do with that, but regardless of that, the extra work doesn't look like it would have...

I'm certain I annoy more people than they annoy me, but it's pretty minimal either way.

The things I've been annoyed by have been more serious than the purpose of this...

RBarryYoung (3/26/2009)

---

Thanks for the confirmation, Gus. And yeah, I figured that it was no cheap approach because it requries a lot of hardware, but since it is so spread...

Nah. But thanks is good enough. 🙂

You should be able to reduce that to one step, instead of two.

For example:

SELECT *,

(select min(t2_ts)

from tbl2

where act2 = a.act1

and t2_ts between a.t1_ts and dateadd(second, 120, a.t1_ts)) as T2_ts

FROM tbl1...

Barry's suggestion of cube + current is what I've used for similar things. Real-time reports, with almost the speed of a data warehouse, and as close to real-time as...

All three are technically UDFs. Inline Table-Value (ITV), Multiselect Table Value (MTV) and Scalar (S) are all just types of UDFs.

Getting beyond the semantics, ITVs are limited to a...