So we would do something like this with the dates as shown below:

Day 1 (Monday):

Select getdate() and the last 2 months

Day 2 (Tuesday):

Select getdate() and the last 2 months

And so...

I have not thought about that approach, but it seems like a good solution. Can you list the detailed steps to do this? Thank you

Chris,

I'm not sure how to go about the solution your speaking of. If you could enlighten me on this approach I would greatly appreciate it. Maybe list some...

I found that the issue was related to Replication and was holding all the logical log files for the prod db. I have removed Replication and was able to...

I added another transaction log file to another drive volume, but I'm still unable to shrink the transaction log from it's large sizes for 2 of my files. I...

I'm running a backup to another drive (30% complete). Every backup I've tried (e.g. full, diff, trans) keeps failing.

All who responded to this thread,

A developer here gave me some insight to the query i needed to create. The comparison needed to be between the min record and...

Thanks for the reply. I used a another nasty SQL script to get the data I needed parsed from the XML docs that were stored in the table into...

Lutz/John,

I've sent out a communication to the developer that requested this query to see if he can explain what needs to be shown in the result set. I'm awaiting...

@LutzM:

The reply was actually directed to both you and John but I forgot to include your name on the posting as I was hurried to try to attach...

Hi John,

I believe the output is fine from what I can tell as long as I can select all the elements from all the XML docs. Let me know...

Hi John,

The code you provided is close to what I want for the requirement, except this code selects a new record into a table. I want to extract the...

Hi John,

I have a table called AmendBarsetFlight. Essentially, I just want to retrieve 2 XML data type columns called ('XMLBeforeAction' and 'XMLAfterAction'). I'm trying to extract the documents...

John,

I've tried to run several examples I've found online, but I'm not really getting the results I'm looking for since the query examples all select specific elements and I want...

NJ-DBA,

The kb article you referenced is exactly the one I came across early this morning as well. So this actually re-enforces the direction I was going in with trying...