Easy enough:

DECLARE @InputDate DATE = GETDATE();

SELECT DATEADD(month, DATEDIFF(MONTH, 0, @InputDate), 0) AS FirstDayOfMonth,

DATEADD(week, DATEDIFF(week, 0, DATEADD(month, DATEDIFF(MONTH, 0, @InputDate), 0)), 0)...

A thousand-row adjacency hierarchy should be pretty fast to resolve using an rCTE. You'll get a lot of I/O (which you've already seen), but performance should be pretty fast....

It's a good write-up of a progression on that kind of thing. But it doesn't necessarily take years to go that route. If you understand how thinking works,...

Microsoft's FAQ on the subject has details on the training (as well as other details): http://www.microsoft.com/learning/en/us/certification/master.aspx#tab5

I've always put it on the same server as the SQL installation. Never had a problem with that.

I was in sales and marketing, then ended up as a DBA because I built some tools to track my customers and their orders.

Add a "text qualifier" in the export definition. The usual is double-quotes. Or use tabs instead of commas as the delimiter, if you can. .csv files work...

Have you tried the TableDiff utility? http://msdn.microsoft.com/en-us/library/ms162843.aspx

You're welcome.

It looks like this might work:

SELECT acl.Person_ID AS 'CODE',

ISNULL(pnr.FullName, ps.FullName) AS 'FullName',

CASE acl.persontype

...

Mine won't return rows in the Docs table if they don't have corresponding values in at least one of the sub-tables. That might explain part of the rowcount difference....

Sorry for the delay in replying. Been recovering from surgery.

Try this:

Expand the number of documents beyond 5 up to some reasonable number, like 10,000 or 1-million. Add random...

Glad we could help.

dwain.c (8/28/2012)

---

LEFT JOINs, CROSS JOINs, FULL OUTER JOINs? What's up with that?

Why not something a bit simpler like this?

;WITH CTE AS (

SELECT n=1, DocNum, Ref,...

Yeah. It's one of those things that people read the headline, but not the details, then try to do it, and don't realize they're creating a worse problem than...