No functions...

-- sample data

declare @test1 table(

id int,

telephone varchar(4000)

)

insert into @test1

select 1,'004-26487,004-84576,9845678682' union all

select 2,'99942078682,002-2687,002-84576,99945678682' UNION ALL

SELECT 3,'002-2687' UNION ALL

SELECT 4,'' UNION ALL

SELECT 5, NULL

-- solution

SELECT

id,

NumberList =...

polkadot (8/2/2012)

---

Well here's how I solved it.

First, I assigned rank to the saledate so that cumulative totals were not against randomly ordered dates, then I inserted results into...

Here's a good reference[/url] covering the first...

Michael Valentine Jones (8/2/2012)

---

In place of this:

or the earningsdate <> the timekey from dt3

or the CycleMonth <> the timekey from dt2

or AEarned1 <> staging column 1

or...

Abu Dina (8/2/2012)

---

The more I think about this the more I come to realise that the address fields must be standardised before any merge work is done. I've spent hours...

You need to tune the original query to reduce the false positives. The easiest way to do this is to tweak the match ratios in the WHERE clause until you...

Heh you beat me to it, Gus.

Gail has a great blog covering this behaviour here[/url].

The sample data doesn't contain any holes. Maybe there aren't any. Here's a sample set with a hole and two [Type]'s:

SET NOCOUNT ON

DROP TABLE #CustomerConditions

CREATE TABLE #CustomerConditions(

[Id] [int] IDENTITY(1,1)...

gsd1 (8/2/2012)

---

Thanks for the reply Chris.

For "07/13/2012 1:06:12 AM" --> Web service is returning "2012-07-13T01:06:12.000-04:00" .

I defined my table column as datetime and the program is loading it...

Display of a SQL Server...

chriskellerx10 (8/2/2012)

---

I had a procedure that runs every day that normally takes 20 minutes or so...without a primary key. I added a PK to one of my tables (the PK...

Another cracking good article Dwain!

shahsn11 (8/2/2012)

---

So does that mean that Surrogate Key is only the concept. And in lay man terms(i.e. mine) can we say that PK=Surrogate Key.

If the above is true that what...

Evil Kraig F (8/1/2012)

---

LOL! ...