well, people on the US side of the pond might not know it...

Then honestly I'd leave it off. I don't think it's worth the space.

If, for some odd reason, you can have actuals records with no budget, and the reverse, then you would need a full outer join between the two tables, not an...

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...