I was gonna reply with this, but that wouldn't be right .

##start

Arguments score :

Rémi : 1

Sushila : 0

Thanx netscape : How to...

You want to correct the design and split that column?

Select Left(FieldName, charindex('.', FieldName, 1) - 1) as Project, Right (FieldName, LEN(FieldName) - charindex('.', FieldName, 1)) as Departement

Very nice solution though...

I'm sorry.  I didn't mean to hurt your feelings.  I don't care that you are a TS or not.  But I think you really to stop fearing the look of...

Still beats the crap out of

create #temp1

create #temp2

insert exec1

insert exec2

select join

drop #temp1

drop #temp2

You didn't answer this one.

This issue is called parameter sniffing and could very well be what's causing you grief.

Let's just call that extremely last resort .

What are the sample results for the exponential moving results?

Do you get different speed/plans if you execute the stored proc and the same query with hardcoded values from QA?

As shown by my modest number of postings .

You still haven't learned to express yourself about your problem. This is puzzling for a...

What was the problem (first step in being able to ask when it happens again )???

HTH.

Also left join ...

WHERE r.Line = @Line and d.EventID = 'PO' And d.EventPF = 1

= inner join (because null = 'po' is never true)

Have you considered changing the join type...

Impossible, rewrite another proc that'll return the right columns and use it instead.

Unless you want to join that data to another table. Then you have to make a table...

Shhht, it's a secret .