You can calculate the dates you want directly:

;with TestData_cte as (

select date = convert(date,getdate())union all

select data = '20141201'union all

select data = '20141231'union all

select data = '20150101' )

select

DATE,

FirstMonOfPriorMonth =

dateadd(dd,(datediff(dd,'17530101',

dateadd(mm,-1+datediff(mm,0,a.Date),6)

)/7)*7,'17530101'),

DayBeforeFirstMonOfCurrMonth =

dateadd(dd,((datediff(dd,'17530101',

dateadd(mm,datediff(mm,0,a.Date),6)

)/7)*7)-1,'17530101')

from

TestData_cte ...

I do it this way:

1. Set it offline to clear the connections

2. Bring it back online.

3. Drop the database.

Dropping the database ensures that there can be no connections, since...

Companies use a fiscal year and fiscal periods that best suit their business.

Retail companies often use a fiscal year that nominally starts in February, but on a week boundary so...

If you can, use FLOAT instead of the REAL datatype. The REAL datatype has limited precision, and the conversion from the internal base 2 to base 10 results in...

My experience is that application tuning does not have to be expensive, and is usually far more cost effective and faster than upgrading hardware.

I have a methodology that I use...

Hard copy edition:

http://www.amazon.com/Oracle-Business-Intelligence-Developers-Guide/dp/0071798749

Kindle edition:

http://www.amazon.com/Oracle-Business-Intelligence-Developers-Guide-ebook/dp/B009E71X0G

10 Day Free Trial:

https://www.safaribooksonline.com/library/view/oracle-business-intelligence/9780071798747/

Software vendor "Support Engineers" usually have very little knowledge of SQL Server (just like their developers and system designers :(), but love to spout nonsense to deflect problems with their...

Does anyone know if it is still an issue with SQL Server 2014?

It looks like MS was putting up some kind of claim that it was by design. Meaning...

Could you try the statement below on a development or test server using a full sized table?

The storage size for numeric precision of 12 or 18 is exactly the same...

Have you done any IO performance testing on the two servers with SQLIO or any other IO performance testing utility?

I would start with that.

If the account you are running the SSIS package with is the same as the SkyDrive/OneDrive) account and you are running it on a machine that is connected to OneDrive,...

Just some ideas:

Limit the number of forum posts to one or two per day, especially new topics, for a while, say a couple of weeks, after they sign up.

Automatically flag...

Is this a homework question?

Using the date table function on the link below, here are the queries you can use.

Date Table Function F_TABLE_DATE

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

select

Sunday = [Date]

from

F_TABLE_DATE('08/01/2014','08/31/2014')

where

-- Select Sunday

ISO_DAY_OF_WEEK = 7

select

Monday = [Date]

from

F_TABLE_DATE('08/01/2014','08/31/2014')

where

--...

Michael Valentine Jones (7/25/2014)

---

ChrisSut (7/25/2014)

---

>>>Why do the different databases need to be in two different countries?

This is a legal requirement, we cannot keep health records of US citizens in Canada...