You need to be careful when using IF UPDATE() because that will show even if the data has not changed.

Try this:

CREATE TABLE update_test

(

...

I'm not promising that this will scale, but it will give the results you require

DECLARE @table TABLE (date DATETIME)

INSERT INTO @table (

date

)

SELECT

'20090112'

UNION ALL

SELECT

...

Tom,

Wow, that is a big font, I wonder if it was done intentionally? It hurt my eyes to read it 😛

Here's a blog post by Buck Woody that he...

Yes, get the edition you are targeting. You could set the DB in 2005 compatibility mode, but I'd get 2005 Developer. If you have MSDN you can download...

In my original post you just need to change the outer DATEADD to be something like this:

DATEADD(Minute, Convert(Int, Right(DateString, 4), Date)

Jeff's code already takes care of it.

This is the code that is causing the error:

Case When Valstatus = 'All Data'

Then DateDiff(d, [ConsultantResolved], GetDate()) + DateDiff(d, [AnalystResolved], [ConsultantUnresolved])

...

Tom Brown (6/2/2009)

---

Jack Corbett (6/2/2009)

---

Steve is getting roasted by Adam Machanic for publishing the article because Adam thinks the concept is crap (My interpretation and summary of what has been...

Lynn Pettis (6/2/2009)

---

Would it be possible for you to provide more...

It will definitely be easier to provide a correct solution if you read the article Gail provided, but I do have one recommendation.

Try changing your group by to use:

case n.is_client_conversion

...

GilaMonster (6/2/2009)

---

TheSQLGuru (6/2/2009)

---

Interesting. You also get a seek if you simply hard code values for coalesce (and I presume isnull) such as this example. It avoids having to...

TheSQLGuru (6/2/2009)

---

Interesting. You also get a seek if you simply hard code values for coalesce (and I presume isnull) such as this example. It avoids having to hit...

Because so many people are unwilling to admit that someone else my know...

I have also used a method similar to Griffster, but instead of adding the AddEvent I just use sp_startjob to run the Report Subscription job. I do not have...

Roger has the right idea. Using a table control there is no way to dynamically add columns. You can hide columns though.

The matrix control does add...

Here is a a Connect item about this issue. It doesn't really provide an real answer, but does recommend that you lower the Max Server memory setting to make...