Thanks Alex,

Well done. I appreciate it.

Thanks Richard, I'll give this a whirl.

Thanks for your help.

I was able to get it to stop by turning off the Reporting Services service. However, this doesn't explain why. Eventually, I am going to...

Ok, thanks. I was able to extract some of the missing transactions via the LDF using the APEX demo tool. (The Red Gate tool worked only with SS2k...

Hi Lynn, thanks for your reply.

I was able to get it running using the following:

update dbo.TargetTable set

targetfield = dateadd(yyyy, 1, targetfield )

where

...

Yep, that'll work.

Thanks for you help Adrienne, I appreciate it.

Hi Adrienne, thanks for your reply. Yes, you are real close. One thing I need though is the case when either criteria be partial. For example, modifying...

Thanks Jeff, that's exactly what I needed.

OK, I got it. Thanks Kim.

Hi Kim, thanks for your help.

I was able to use your select to query my table it returned the following results:

pkid otherid totalcount

6132

3132

5432

3432

3442

5442

Which is correct! ...

You are correct in your assumptions. I will give it a go.

Thanks!

Ok, I understand this isn't possible according to BOL. Bummer!

I moved it to a stored procedure and now it works. I'll need to be careful in terms of security...

Whoa, bummer.

Thanks for your response.

Bob

http://www.bluemulesoftware.com

From w/in the function I'd like to pass in a string of sql and prepend and append some text and then execute it. This executed statement is used to...

Hi Jeff, I'm aware of many tree schema/strategies. ASP.NET 2.0 and SQL Server 2005 have some very interesting approaches to implementing trees and we have research these in detail....