Viewing 15 posts - 10,246 through 10,260 (of 14,953 total)
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.
March 27, 2009 at 10:01 am
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,...
March 27, 2009 at 9:59 am
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...
March 27, 2009 at 9:55 am
Why does it have to be a case statement?
Can you provide the table definitions and some sample data?
March 27, 2009 at 9:46 am
I would say that retaining the nulls is the correct handling in this case. That's what the feature is for.
March 27, 2009 at 9:45 am
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?...
March 27, 2009 at 9:43 am
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...
March 27, 2009 at 9:41 am
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...
March 27, 2009 at 9:33 am
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...
March 27, 2009 at 8:13 am
RBarryYoung (3/26/2009)
March 27, 2009 at 7:33 am
Nah. But thanks is good enough. 🙂
March 27, 2009 at 7:24 am
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...
March 27, 2009 at 7:22 am
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...
March 26, 2009 at 3:10 pm
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...
March 26, 2009 at 3:04 pm
Viewing 15 posts - 10,246 through 10,260 (of 14,953 total)