I can't understand what you wrote.

I like triggers. They make firearms much more user friendly than keyboards and mice would. 🙂

In my book, triggers have one good use, which is enforcing code at a...

Bruce W Cassidy (1/29/2009)

---

[font="Verdana"]I'm too scared to even ask! Let me guess though... some sort of über-discussion that...

Sounds like you're on the right track on that one.

In that case, there's something up with the index and/or the execution plan. Have you tried running the query with a recompile?

Bruce W Cassidy (1/29/2009)

---

Alvin Ramard (1/29/2009)

---

I'm not sure a newbie to this site should be reading this thread, at least not the last 2 days worth. He's gonna be...

Ouch! Yeah, that piece of code might work, but it hurts to look at!

;with Numbers (Number) as

(select row_number() over (order by object_id)

from sys.all_objects)

select dateadd(month, number, @StartDate)

from Numbers

where number <=...

The key part of Jeff's question was "without resorting to a forum". Some of the questions the guy asked, like users connecting to the secondary server in a log-shipping...

The best way to do that is to build a calendar table.

The second best way is to use a numbers table.

After that, it's a numbers CTE.

After that, recursion.

Are you in...

Or it could be that the CTE is doing heavy lifting because the load is a big one.

There's nothing wrong with a piece of a query having more than its...

Why not use IsNull for that?

sum(isnull(soi.ItemValue, 0))

Well, they're very useful for certain things, and not very good at certain other things.

They are good at resolving recursive hierarchy data.

They are good at taking the place of derived...

I've been a DBA for 8 years (will be 9 years in March), and my best cert is ... I don't have any. So, I really don't see them...

Lynn! Your favorite is back!

http://www.sqlservercentral.com/Forums/Topic646268-19-1.aspx?Update=1

In the DTS package, there is an option to turn on logging. Use that.