nilkanth.desai (5/7/2009)

---

Lyn,

I understand that if i manually enter the ip addresses and services the code handles this, as I said it assumes I know all the IP addresses AND services,...

Here is the code I threw together:

CREATE TABLE dbo.customer_address

(

Customer_key NVARCHAR(100),

Provider_complete_Address NVARCHAR(150)

)

--===== Insert the test data into the test table

INSERT INTO customer_address

(Customer_key,Provider_complete_Address)

SELECT N'AALEMANSOUR, SIAMAK: 858256221','18141 BEACH BLVD STE 130*...

And then you have OP's like this one who think your test table (temp or table variable) are part of the solution...

I hear the desert calling my name...

I got it! The table variable with the test data, that is what you are talking about. No, you use the code Flo provided, but change it to...

nilkanth.desai (5/7/2009)

---

Flo,

More or less, the code you sent assumes that I know the IP addresses and Services, however this is not the case, is there a way that I can...

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...