I would start with looking up Gaps and Islands. There's Itzik Ben-Gan's code, which is a good starting point. Dig around there. Dwain Camps wrote some. how...

What columns you include in your date dimension should probably be determined by what kinds of summaries you intend to do with dates...

Or link to your SQL Server database and use linked tables etc... I wouldn't waste a lot of space on my resume on Access. The market for it is almost...

I got this to work...

I started with a dataset with a date column, Consent_Date.

Created a new table and entered this:

NewDateTable = CALENDAR(MINX('PatientSymptoms',[CONSENT_DATE]),MAXX('PatientSymptoms',[CONSENT_DATE]))

... which generated a table of all the...

At the bottom of this page, it says that there are both 32- and 64-bit versions of SSRS.

add a case sensitive collation to your query.

Here[/url]'s a really good example.

here's one I did ...

SELECT *

FROM dbo.Patient

WHERE LastName COLLATE Latin1_General_CS_AS LIKE 'Do%';

so a last name starting with 'DO' would...

Removed the "compare to last week" part...

looks like there's a piece missing:

FROM MyData T1

LEFT JOIN T2

ON DATEADD(yyyy,-1,T1.InvoiceDate) = T2.InvoiceDate

(I think).

I'm pulling week to date sales data (ex. if I were to run it tomorrow it would pull sales totals for Monday and Tuesday of this week). But, I want...

You'll get more help if you post consumable data... like this:

CREATE TABLE LotData (

Lot INT,

TranDate DATETIME,

Qty INT,

UOM CHAR(2),

RunBal INT );

GO

INSERT INTO LotData(Lot, TranDate, Qty, UOM, RunBal)

VALUES (114044, '5/27/2015 3:25 PM',...

Thanks Eirikur! Learned something new today!

Kinda wish you could choose which columns you wanted in the table, but not possible, I don't think. Super handy for when you...

I think that's it. You can't mix 32 and 64bit on the same machine.

What I need to do is a sort based upon the birthdate, lang, and pernum.

Basically the sort for birthdate should meet the following criteria:

a. If a student is under 6...

Jeff,

that's basically what I did. (it's like a mini star schema, and Calendar is just a dimension table). Turns out, I used your calendar table-valued function. =)...

No, I'm using the Calendar table as a Dimension so I can lump sales etc into "bins" -- summarize by Year/Month whatever.

I was using a dataset someone gave me that...

found an explanation for any other intrepid folks that might be trying to create a calendar using PowerQuery... (not sure why one would want to do that, since it's so...