Whose standards? Everyone has their own idea of how code should be formatted. In some ways, I agree, it would be nice if the code for the Microsoft...

Here is the procedure, untested, as you did not provide the other items requested (ddl for the tables, sample data).

alter PROCEDURE [dbo].[SP_Searchengine]

@VALUES varchar(8000)

AS

BEGIN

select

s.AdSpaceId

,i.AdInfoId...

Your welcome.

Now, keep this in mind. With the release of SQL Server 2012, Database Mirroring as implemented in SQL Server 2005/2008 has been depreciated. I would highly recommend...

Possible that the first run of the prc required a execution plan to be created and subsequent runs used the cached plan. If this is a test environment, go...

mikeb5555 (3/16/2012)

---

I also thought that the duration was displayed in milliseconds not microseconds in Profiler.

Either way, i'm more concerned with finding out why the SPROC runs for 0...

Backups are worthless,

Restores are priceless.

SQLKnowItAll (3/16/2012)

---

er.sivaganesh (3/16/2012)

---

Thanks,

Jared

SQL Know-It-All for u job s for me and i inform u solved this problem by...

In Profiler, it looks like duration is displayed in milliseconds, but in the trace file it is stored as microseconds.

Unfortunately, I have a feeling, while looking duration in a trace file, that it is in millisecods.

BOL may be wrong. Should do some checking on this.

er.sivaganesh (3/16/2012)

---

thanks for every one who joined in this discussion i just solved this problem by creating cusor in my store...

Duration is in Microseconds. Does that help with your math?

Animal!

Lasagna

Bacon

GSquared (3/16/2012)

---

Lynn Pettis (3/16/2012)

---

GSquared (3/16/2012)

---

Lynn Pettis (3/16/2012)

---

I think I'll go join the Guard Hippo at my Tent in the Desert. I really must be getting grumpy in my old...