Viewing 15 posts - 21,106 through 21,120 (of 26,490 total)
nilkanth.desai (5/7/2009)
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,...
May 7, 2009 at 11:20 am
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*...
May 7, 2009 at 11:15 am
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...
May 7, 2009 at 10:54 am
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...
May 7, 2009 at 10:51 am
nilkanth.desai (5/7/2009)
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...
May 7, 2009 at 10:49 am
This is closer to what you need:
DECLARE
@sql nvarchar(MAX),
@OP nvarchar(2),
@Name nvarchar(20),
@Value nvarchar(20);
SET @OP = N'=';
SET...
May 7, 2009 at 10:39 am
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...
May 7, 2009 at 10:33 am
rayash16 (5/7/2009)
actually the function might work,i used some myself .
the problem is the result set has to use a group by because i need...
May 7, 2009 at 10:16 am
Gianluca Sartori (5/7/2009)
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...
May 7, 2009 at 10:08 am
Glen Cooley (5/7/2009)
Intermediate. If it was SQL 2005 I would of used a CTE but I cant do that with SQL 2000.
You can use a derived table. You put...
May 7, 2009 at 10:06 am
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] (
...
May 7, 2009 at 10:04 am
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...
May 7, 2009 at 9:52 am
Would not be surprised if the poor performance is due to returning the actual execution plan.
May 7, 2009 at 9:44 am
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...
May 7, 2009 at 9:35 am
Viewing 15 posts - 21,106 through 21,120 (of 26,490 total)