Thanks, does select * from mysql_apply...apply_2 return the data sucessfully?

Is it (the second version with @StartDate and @EndDate commented out in the case statement) not populating the table at all, or just not with the values you expect?

(And, as...

Hi,

Are those values for the entire table, not just the matching rows? My feeling is SQL will grab all the data before trying the join.

Thanks

At a guess, you're encountering out-of-range values from MySQL (probably lovely old '0000-00-00 00:00:00') - if you can convert these to null it should work, I think. Last time I...

Hi,

What are you trying to do with @StartDate and @EndDate?

You can't have CASE statements in that format

It's either

CASE value

WHEN match THEN

or

CASE

WHEN (clause) THEN

You can't mix them up.

Cheers

Gaz

SSRS will pass the values through like this: 'ParamValue1, ParamValue2, ParamValue3'

You need something inside the proc to convert it to something like 'ParamValue1', 'ParamValue2', 'ParamValue3'

The splitter here will do that:...

Jeff Moden (2/11/2013)

---

As a sidebar, I'm thinking there's something seriously wrong with the database. You're talking about a very small database using almost a quarter of a Terabyte! When...

I'm not so sure there's corruption anywhere - in the original query, there's 15 subselects chained together, most against the same table, and some in a different database. Think it...

craig.bates (2/7/2013)

---

As far as the parameters go, I'm used to having to pass parameters to my SP's for other purposes. True when I run the SP I leave all...

Good point...

craig.bates (2/7/2013)

---

When it successfully runs I get this (which I don't really understand, why would a return value = the stored procedure, or is that just where the value is...

Not sure if it's the problem, but that query has a load of individual reads against tables that could be combined, if you do this:

Select @Date = GETDATE()

SELECT

@Shop_Order =...

You can do it in SQL in the dataset, or an expression in the report itself, both using substring and charindex/indexof:

SQL:

SUBSTRING(group_name, CHARINDEX('_', group_name), CHARINDEX('-', group_name) - CHARINDEX('_', group_name))

Expression:

=Substring(Fields!group_name.Value, Fields!group_name.IndexOf('_'), ...

rooierus (2/1/2013)

---

Great stuff guys,

Thanks a bundle ! What I did notice though is that sp_spaceused often shows some index usage when queries using the index ID (0,1) don't.

Would that...

Raghavendra Mudugal (2/1/2013)

---

Same here but after checking this http://en.wikipedia.org/wiki/Clobbering, it kind of eased the...