Thanks for the responses. The execution plans were and are in the original post... Do you not see them? Once my way in to work, but I see them on...

Hello Vedran,

First off, thank you for the detailed response.

In regards to your response to #2. The execution plan is properly using an index; however my assumption is that it's not...

Mike.Dougherty (10/30/2012)

---

Were you ever able to get a test environment up and running with multiple versions? I have a SQL Server 2008 R2 2-node cluster built and running with...

While not overly thrilled with the idea, what I ended up doing was simply creating stored procedures with open datasource calls and dynamically calling the server based on a parameter...

Thanks,

So the question in regards to creating the scripts. Via SSMS, it allows you to create a script in XML for the sync process. What I'm trying to determine is...

Now what's even more odd is that I got through about 12 files (with the duplicate issue); however now I hit a file where it says the Sheet doesn't exist...

Disregard, I found it ... was passing a date range on data that did not exist ... thanks all!

The thing I'm not understanding is what purpose the TOP serves ... obviously because I am now running into this error: A TOP N value may not be negative.

I'm still...

Hi Wayne and thanks.

I like the idea; however that won't get me what I need. In by that, if the recovery model is not simple, I need to insert two...

Eugene, I'm hoping you can save me yet again.

Have another similar problem that I'm struggling with.

This is my current query:

INSERT INTO #Backups

([CalendarDate], [ServerName], [DBName], [RecoveryModel], [IsTlogShipped])

SELECT TOP

(DATEDIFF(DAY,CONVERT(VARCHAR,@FirstBackupDate,102),GETDATE()) + 1)...

Eugene Elutin (6/12/2012)

---

You don't need the cursor! If you have the calendar table, just select records you need filtering by date.

Or you can use some run-time tally table...

Thanks, I do have a calendar table; however the problem remains, inserting a new record based on a source data set with every possible date between a specified range.

Thanks for the ideas all. I actually ended up going a different route utilizing a temp table and performing updates/deletes based on the logic I needed and it met my...

Thanks mister. A route I had debated; however not really looking to take that avenue at this time. I'm still working on being able to do within my query without...

See below.

Note how the week of 02.27 to 03.05 is week 10, but it spans both month 2 and 3 ... which is correct from a calendar perspective; however I...