Finally teach myself some basics on SSAS. It's the one piece of SQL Server I've never actually worked with, so it's about time for me to at least shake...

Most likely, you can add a column conversion to your query in your data source.

Depends on how you built the report.

Change a datatype in the presentation layer?

I'm used to that being done in the data layer or data access layer. Presentation layer is for changing what it looks like,...

Can you add a type conversion in the query, convert it to Date or DateTime, and use that?

Thanks! It's meant to generate a chuckle.

Do you have the query you want to run? Or are you asking for help with that?

Or do you just need help with scheduling and e-mailing the results?

It's not exactly possible, but it can kind of be done.

The way I do it is create a database called Common, then use that as a library for functions, data,...

patrickmcginnis59 (12/19/2012)

---

GSquared (12/19/2012)

---

Patric, is this another one of these things like where you claimed to have more experience communicating that I do because your c. 300 posts on this site...

You're welcome. Glad we could help.

In my experience, both of these are usually substitutes for skill in the subject.

That can be a good thing, if the company you work for can't hire expertise (not available,...

This will work:

IF OBJECT_ID(N'tempdb..#Visits') IS NOT NULL

DROP TABLE #Visits;

CREATE TABLE #Visits

([TargetID] [int] NOT NULL,

[TargetName] [nvarchar](255) NULL,

...

Patric, is this another one of these things like where you claimed to have more experience communicating that I do because your c. 300 posts on this site somehow count...

On the one with the string literals, try '20121130' and '20121001' instead of the US-formatted dates and see what happens.

The graphical plans aren't "internal". They're done in the presentation layer (usually Management Studio) from the XML.

If you want to copy that functionality to a different application, you'll have...

It isn't the engine that does that. It's Management Studio.