Both Date and Time are stored as INT datatypes in my Dimensions, hence I needed to convert them to INT values.

I need to return AuditDate, Date of AuditDate and Time of Audit Date. I will then be linking these to my date_time Dimension.

Yes I have.

Hi Thom, that seems to give me the same error message

I just realized that, how do execute this allowing Country Parameter to be optional ? first I will remove

from my query, which will populate...

Thank you so much

I think the issue is How I built the solution, let me explain that first before I get to the Scheduler;

There were Scripts that were run manually, so I'm...

Actually the exercise is to automate the Reports, so I'm just trying to come up with a smarter way to automate scripts. and since many scripts have things that are...

Thank you

Working days being Monday to Friday

Can I get different columns like 'Today', 'Yesterday', 'A day before Yesterday', '3 days prior Today' and '4 days prior Today'?

Hi

I want to return two character from a column. But now the column itself returns 0 -9, then double digits. before I concatenated "0", then the problem I had was...

It has to return only one day's results.

however on that note of your question, how will can it aggregate daily, because I think the code as it is when...

I posted on SQL Server 2008, Now I'm moving it to SQL Server 2012.

Grasshopper did you get that job? lol