I'm sure I can help find an adapter or two if needed.

Somewhat unrelated, I would also suggest moving away from ORDER BY 1 and move to using ORDER BY column_name.

Check sp_trace_create in BOL. A problem I see withyour is options is set to 0, when it needs to be 2 for rollover.

Florian Reischl (5/7/2009)

---

Hi

I got it. You have to specify an alias for the outer table. Since your table name is "holddups" and you refer it within your sub-query you cannot...

Jamie Julius (5/7/2009)

---

I didn't mention the datetime stuff in the original post, because I wanted to simplify the question. Please note that the crux of the question is about concurrency....

Query your data for this just this IP: 10.1.8.0. See if there are duplicate services. If so, you either need to add a distinct or determine if there...

No. No reason to. Tempdb is recreated everytime SQL Server is restarted.

Glad to see that.

And what have you tried? Have you looked in BOL regarding...

mikesigsworth (5/7/2009)

---

Okay still no luck.

My query now looks something like this:

DECLARE @sql nvarchar(MAX),

@OP nvarchar(9),

@Name nvarchar(128),

@Value...

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