bpmosullivan (5/24/2011)

---

Hi John,

Here is what i've tried so far. I've been googling all day but not getting anywhere

SELECT CAST(SUM(TB1.TimeDuration + TB2.TimeDuration) AS int) AS Total

FROM ...

What's the datatype of the parameter in the stored procedure?

What's the datatype of create_date?

What link is missing / broken?

Keep in mind that not all articles have been posted yet. so maybe that's why you can't access those.

What was wrong with Lutz's solution?

You can name a textbox in the grouping sections and use that as a dividor.

I'd check to make sure that the @To is not set to 2011-05-01 and actually set to 2011-05-31.

I personnally preffer to use < 2011-06-01. I can't tell you why,...

http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

I can't see your image (on your desktop). ...

Please post sample data and required output formatted in the matrix.

Ok then, use a tablix, set the dataset for the tablix and then do count(*) in 1 column. That should work.

If not try sum(1).

You can put that 2nd count in a textbox, name the textbox something meaningful and then use the textbox value as such :

ReportItems!txtSumValeurOuvertCUPA.Value

Ya but I was under the impression that ssms was generating that file, so I assumed it could word on sql 2k... but...

GilaMonster (5/23/2011)

---

sqldba_icon (5/23/2011)

---

So if i run this select first time, it will take 45 mins and then i run in few mins it will take only few secs reason is...

never seeen that b4...

Please attach the actaul plan... there's way more data we need to see besides the operators and %.

P.S. I see you are using SSMS, is the server sql 2000 or...