This is closer to what you need:

DECLARE

@sql nvarchar(MAX),

@OP nvarchar(2),

@Name nvarchar(20),

@Value nvarchar(20);

SET @OP = N'=';

SET...

Your problem is with how you are trying to build your dynamic query. You can't use variables passed in like you are trying, as you are trying to put...

rayash16 (5/7/2009)

---

Thanks guys for such a quick response,

actually the function might work,i used some myself .

the problem is the result set has to use a group by because i need...

Gianluca Sartori (5/7/2009)

---

I think you should use some kind of slit function.

I use this one, but I'm sure there's a better one out there.

CREATE FUNCTION [dbo].[fSplit]

(

@List VARCHAR(6000),

@SplitOn VARCHAR(5)

)

RETURNS...

You can use a derived table. You put...

It may need some twiking, but does this help?

USE [SandBox]

GO

/****** Object: UserDefinedFunction [dbo].[DelimitedSplit2] Script Date: 05/07/2009 10:03:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE function [dbo].[DelimitedSplit2] (

...

Why are you so concerned about getting rid of the table spool?

The following (I prebuilt and loaded the temp table with your sample data) ran in 11 ms:

Set NoCount...

You can query the t-log??

Would not be surprised if the poor performance is due to returning the actual execution plan.

Has anyone else noticed that EVERY TIME a new version of SQL Server is released there are many questions asking if you can restore a database from the newer version...

Yep, ran 3 seconds for me too, when I was asking for the Actual Execution Plan. If I turned that off, the query returned in less than a second.

Using Jack's query, try adding the following index and let us know what happens.

create index IX_tbllogs on #tbl_logs (

[fk_tbl_visits_id] asc,

[date] asc

)

include (

...

Rereading the posts, you were asking the wrong question, well actually you weren't asking the complete question. Please look at the following code as it more closely matches what...

jamiejulius (5/7/2009)

---

Thanks. I'm familiar with Books Online. It seems to me that the proposed SQL would be considered an implicit transaction. It would be run under the default isolation mode...

jamiejulius (5/7/2009)

---

Thanks. I'm familiar with Books Online. It seems to me that the proposed SQL would be considered an implicit transaction. It would be run under the default isolation mode...