If working with a large data set, the convert function in the where clause will slow things down as compared to having a datetime column. It may be beneficial to...

In your query you are casting as decimal(18,2). Are your numbers always going to be whole numbers?

The following example

select PATINDEX('%[^0-9]%', '1234234.20')

does not return zero.

Just though I should ask.. Is wzunzip installed on your system or the server you are trying to have run your process?

Yeah, he could be implying cascading parameters. It is just not clear (beyond a reasonable doubt) from the post itself.

In SSRS 2005 I notice stored procedures in the dataset...

+1

Glad its working out, thanks.

From MSDN,

http://msdn.microsoft.com/en-us/library/ms187864%28v=sql.105%29.aspx

Indexed views work best when the underlying data is infrequently updated. The maintenance of an indexed view can be greater than the cost of maintaining a table index....

Just to clarify, that inner join is causing the cross. Is this the intended behaviour? If so could you post how this solves your problem?

Thanks.

Maybe I am reading you wrong but I take it you are writing the...

Hi, are you using a stored procedure in your dataset definition or are you typing in the query directly?

I am not sure you can accurately partition your articles without that company identity column. Are the company names consistent across the tables that you can join to the company...

Hi. Have you tried the pivot function?

When you want to schedule the job, do you need to provide the package password in the agent configuration? If so would you need to restrict access to who can...

Are the latencies in data similar? In your old report you may have had access to up to the minute data whereas in the new cube current is defined as...

Craig makes a good point above. In a small organisation you don't have as many developers and you are likely to be familiar with all ETL processing. There is little...