sgmunson (8/10/2015)

---

I took one look at the stored procedure and it definitely needed work. Take a look at the way it's been re-written by comparing it to the...

Sean Lange (8/10/2015)

---

mrtran0404 (8/10/2015)

---

Sean Lange (8/10/2015)

---

ChrisM@Work (8/10/2015)

---

John Mitchell-245523 (8/10/2015)

---

You're selecting every row from the table, so it's not going to be all that quick. Get rid of your whole...

Sean Lange (8/10/2015)

---

ChrisM@Work (8/10/2015)

---

John Mitchell-245523 (8/10/2015)

---

You're selecting every row from the table, so it's not going to be all that quick. Get rid of your whole WHERE clause -...

ChrisM@Work (8/10/2015)

---

The query you have posted is...

no i select folow value of variable when i call storeprocedure and then it exec this command to return result to me 😎

Dear sir,

thank for you answer, yes i used SET STATISICS IO but time select no change.

this is my sqlplan affter run select:

<?xml version="1.0" encoding="utf-16"?>

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.1600.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

...

anny idea for this propblem? please help me!

Thanks for you time!