This is going to be a very long expression.

First check on which day the Starttime falls using the DAY function. If it is a monday, decrement it with 3 using...

How do you calculate the 1440?

First you need to create a credential.

This will typically map to a domain account.

Next you create a proxy account and you link this to the credential you just created.

You also...

You can put a default on a parameter. You just need to make the dataset that calculates motherday dependend on the...

amadeu_j (7/4/2013)

---

I managed to build the SQL, it was through a SP

Only now I have a problem, I can not update the date

I will explain

I have a parameter with years....

michaeleusebio721 (7/3/2013)

---

Hi Koen!

Thanks for your response!

I did try your suggestion and it worked! I used a concatination of the 2 keys and some other character to make sure every key...

Allright, glad that you found the issue and thanks for posting back.

Christopher Ware (7/4/2013)

---

It would be nice if there were other mechanisms to get you the answers we need more timely, but this tool is used as is with little instruction....

Make sure SSRS is not using cached data.

Go to the folder where the report is stored and delete any .DATA files.

Simply add the month column in the GROUP BY clause.

By the way, using HAVING on a column on which you group - thus not an aggregate - is the same...

Simply add an IDENTITY column to your table (if you haven't one already).

Give each row the same value for OrderDate: 2013-07-04. Then simply distract the identity value from the OrderDate...

You probably need a date table for this, which for example stores all the dates between 2000 and 2050.

An example on how to generate such a table can be found...

You can write a SQL query that calculates this value and use this query to populate a default value for the parameter.

You need to create an expression on the Excel connection manager.

You can find an example in this article:

SSIS: How to add a timestamp to a Excel File output path.[/url]

akamorse (7/3/2013)

---

Thanks for reading 😀

Im trying to create a view, and im having trouble doing one function. I have a table with the following

ID ...