Thank you very much! I will try this right away. If it works, I totally owe you a beer :exclamationmark:

Here is a month by month approach, but I need to have the best way to "loop" through a given set of six prior months to a month range that...

FYI - here is the better query (grouping handles properly) for a single month:

DECLARE @StartDate DateTime;

DECLARE @EndDate DateTime;

Set @Startdate = '10/01/2013';

Set @EndDate = '10/31/2013';

SELECT distinct CUSTNMBR,MONTH(DocDate) AS Mth,YEAR(DocDate) AS Yr,

COUNT(ROWID)...

BTW - ignore my first query, I made some grouping mistakes and the numbers were way off :).

However, this time I am simply giving the DDL statement and the long...

Sounds great!

I'll take a few moments today and get that together.

Yes, it would appear the URL limitations of SharePoint Integration are the cause of the above error.

I was hoping to jump around it since I can use the paths to...

I have been getting the following error when moving From SharePoint Integrated mode Back To Native mode with both machines on 2008 R2;

Can anyone tell me why?

I am trying to...

Did you ever resolve your issues? Will it work on 2008 R2? both my environs are 2008 R2 and I need to migrate from Integrated mode back to...

Thank you:

jhood 36885 (6/7/2013)

---

I know this is an old post, but I thought I would add what I found. I went to archive.org, and pasted in http://www.sqldbatips.com/showarticle.asp?ID=62 into...

I have the same problem, because we are moving our SharePoint to the cloud and Integrated Mode will not work in the MS Cloud.

Now I need to migrate hundreds of...

Thank you for this script, it was one of the final pieces to my having to run a sub on the 3rd business day of every month.

For anyone...

Please ignore this topic; I typed before thinking too deeply after an couple of frustrating hours of searching. Need to delete it, but don't know how or am not...

Update and answer:

Update:

I was missing several .Value items and chose to use dateinterval.{day,month,year} instead of "m" or "d";

as well, instead of just returning an integer to plug into a data...

Update: I am getting the following error now

Warning1[rsRuntimeErrorInExpression] The Value expression for the field ‘LYTD_EndDate’ contains an error: Argument 'DateValue' cannot be converted to type 'Date'.