Hi,

Not that I've heard of.. You could insert the connections in to a Config database and then use them as project level data sources in BIDS so that any SSIS...

Hi,

You can try the below code which will show you the data in each row and will count the non-null values for you.

--Check for the existance of the test table...

Hi Lise_Synnove,

Sounds like you've got a lot of reading to do. I'd start with the Kimball methodology to get more of an idea of how to attack. Have a look...

Can't you convert to the date to a string and then use expression builder to pull out the appropriate sections of the string into the format you require?

This 'should' return...

This is quick and dirty, but since the number of months in a year isn't going to change any time soon you can do this:

;With Invoice AS

(

SELECT '20130101' [InvoiceDate], 100...

Any chance you could provide us with some sample data so we can test the query that you've written?

Can't you pass the parameter to the sub report?

http://msdn.microsoft.com/en-us/library/ms160348(v=sql.100).aspx

Can you firstly provide us with the set up of your queries, some test data like the below and anything you're already done?

SELECT 1 [DataId], 1 [AccountId], '2012-01-01' [DataDate], 100...

What are you trying to achieve Suresh?

Even if you provided all of the data in .csv files or in a massive Excel spreadsheet the person will still be able to...

Hi All,

Just thought I'd drop a note back to say that I found some software on codeplex that can do this for you. It's called QueryUnit, which builds a dll...

Did you ever find an answer to this? Often times if you copy and paste the commands there can be an issue so it's best to type these out manually....

I've just found that this works in Reporting Services as well where Fields!Season_Month returns the month name only:

=Month("1 " & Fields!Season_Month.Value & " 2012")

I'm trying to do pretty much the exact same thing.

You could create calculated members for each of the [date/time],[Measure] combinations and return them all, but I'm trying to avoid...

You can right click on the design surface off of the report body and go to Report Properties where you can change the setting from inches to centimetres. I'm yet...

Hi,

Also, to get round having null values you could use COALESCE:

SELECT *

FROM Table

WHERE ISNULL(Modifier1, COALESCE(@Mod1, @Mod2, @MOD3)) IN (@Mod1, @Mod2, @MOD3)

OR ISNULL(Modifier2, COALESCE(@Mod1, @Mod2,