Viewing 15 posts - 1 through 15 (of 21 total)
Well done. I appreciate it.
September 21, 2007 at 2:25 pm
Thanks Richard, I'll give this a whirl.
September 7, 2007 at 9:23 am
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...
September 7, 2007 at 8:11 am
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...
September 6, 2007 at 10:57 am
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 )
August 9, 2007 at 12:38 pm
Yep, that'll work.
Thanks for you help Adrienne, I appreciate it.
August 8, 2007 at 3:13 pm
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...
August 8, 2007 at 12:49 pm
Thanks Jeff, that's exactly what I needed.
July 13, 2007 at 9:07 pm
OK, I got it. Thanks Kim.
July 13, 2007 at 5:30 pm
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
Which is correct! ...
July 13, 2007 at 4:30 pm
You are correct in your assumptions. I will give it a go.
July 12, 2007 at 1:16 pm
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...
July 2, 2007 at 5:08 pm
Thanks for your response.
July 2, 2007 at 4:35 pm
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...
July 2, 2007 at 4:33 pm
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....
July 2, 2007 at 8:34 am