Must be correct then!

Comment removed, may...

DROP TABLE #Graph_Range

CREATE TABLE #Graph_Range (Start_Range DECIMAL (5,2), End_Range DECIMAL (5,2))

INSERT INTO #Graph_Range (Start_Range, End_Range)

SELECT 0.10, 0.20 UNION ALL

SELECT 0.20, 0.30 UNION ALL

SELECT 0.30, 0.40

DROP TABLE...

This simple sample should get you started. Have a play, explain if it doesn't meet your requirements.

CREATE FUNCTION [dbo].[MyFirstITVF]

(

@StartNum INT

)

RETURNS TABLE WITH SCHEMABINDING AS

RETURN

SELECT d.MyInt, x.MyString

FROM...

ERIC CRUDELI (6/6/2013)

---

Hello,

I just found the problem just before to get your email.

The problen is in clause WHERE with P.[pat_nom] IS NOT NULL. If I remove it the reponse time...

ERIC CRUDELI (6/6/2013)

---

Hello,

I tried this :

DECLARE @p__linq__0 varchar(25),

@p__linq__1 varchar(9),

@p__linq__2 varchar(25),

@p__linq__3 varchar(9)

SET @p__linq__0=N'ARD%'

SET @p__linq__1='CHU-LYON'

SET @p__linq__2=N'REI%'

SET @p__linq__3='CHU-LYON'

SELECT

P.pat_nom,

P.pat_site_code,

P.pat_nom_naissance,

P.pat_id,

L.[lnai_id] AS [lnai_id1],

L.[lnai_cp] AS [lnai_cp],

L.[lnai_ville] AS [lnai_ville],

L.[lnai_pays_id] AS [lnai_pays_id]

FROM [noyau].[PATIENT] P

LEFT...

There's still a huge memory grant :ermm:

Try this very simplified version:

SELECT

pat_nom, pat_site_code, pat_nom_naissance, pat_id

FROM [noyau].[PATIENT]

WHERE ([pat_nom] LIKE @p__linq__0 ESCAPE '~')

AND ([pat_site_code] = @p__linq__1)

--AND ([Extent1].[pat_site_code] =...

Also, you should match the datatype of your variables to your column datatypes:

DECLARE

@p__linq__0 nvarchar(?), -- pat_nom

@p__linq__1 varchar(?), -- pat_site_code

@p__linq__2 nvarchar(?), -- pat_nom_naissance

@p__linq__3 varchar(?) -- pat_site_code...

He's gone home, there's just us geeks eating fish sandwiches and slugging Bordeaux.

The existing index isn't well matched to this query - you're getting an index scan...

No, not a picture of it - that's like ordering a taxi to the airport and someone turning up with a picture of a taxi....

Can you post the...

Ushuaia

You can make a significant improvement to the readability of the query by eliminating the unnecessary subselect, removing unnecessary column aliases and using sensible table aliases:

SELECT

p.[pat_id],

p.[pat_situation],

p.[pat_ancien_id],

p.[pat_portail_id],...

Stefan Krzywicki (6/5/2013)

---

rodjkidd (6/5/2013)

---

Stefan Krzywicki (6/5/2013)

---

rodjkidd (6/5/2013)

---

Wow looked as though I missed some thread activity last night while seeing Elvis Costello in concert...

On the plus side at current job, they...

Outstanding work for one so young 😀