jeff.born (8/12/2015)

---

WayneS (8/12/2015)

---

Ordering question: since MatchScore was added, it's going to get the lowest MatchScore. Do you want the highest, or lowest?

For instance:

510471637412394716374977274246TIPTONGOLIAS

51047163747806257379866227750Tipton Golias

510471637412394716374931652750TIPTONGOLIAS

510471637414106357292966227850TIPTON LGOLIAS

Should we get one with 50,...

Does this work for you?

WITH SampleData AS

(

SELECT *

FROM (VALUES

('Nest8', '5682', 'Case', '901834', '237848117', 'Black,...

Ordering question: since MatchScore was added, it's going to get the lowest MatchScore. Do you want the highest, or lowest?

For instance:

510471637412394716374977274246TIPTONGOLIAS

51047163747806257379866227750Tipton Golias

510471637412394716374931652750TIPTONGOLIAS

510471637414106357292966227850TIPTON LGOLIAS

Should we get one with 50, or the...

Hmm, so it looks like the last row_number needs to be partitioned at the contact_pk level then. How does this work?

WITH cte AS

(

-- first, pull in both columns into one,...

Sweet. Thanks for doing that.

Eirikur Eiriksson (8/12/2015)

---

For giggles here is yet another slightly modified version. The difference doesn't look much but it is an improvement over the first one of roughly 20% and 5-10%...

How does this work for you?

WITH cte AS

(

-- first, pull in both columns into one, along with the other data needed for later processing.

SELECT cs.Business_fk, cs.Contact_fk, c.Source, c.Contact_pk, cs.ContactScore_pk

FROM...

Any other Threadizens going to the Louisville SQL Saturday next week?

We've known how to stop SQL Injection for over a decade now. I'd be curious to know others thoughts as to why they think that SQL Injection is still so...

Hi Jeff,

What are the rules for deciding which record to keep?

If you say "keep the first one", remember that SQL works in sets... you need to define an order at...

Lynn Pettis (8/11/2015)

---

Give this a try.

select distinct

mt.field1,

ca.field3

from

dbo.MyTable mt

cross apply (select stuff((select ',' + mt1.field2

...

Here's my contribution.

DECLARE @test-2 TABLE --CREATE TABLE #test

(

createdon datetime,

kms_quoteorder varchar(15)

)

INSERT INTO @test-2 VALUES ('2015-06-10 14:03:04.000',NULL)

INSERT INTO @test-2 VALUES ('2015-07-22 15:13:39.000','15-37666')

INSERT INTO @test-2 VALUES ('2015-07-22 16:13:39.000','15-37779/Rev7')

INSERT INTO @test-2 VALUES ('2015-07-22 19:54:56.000','15-37779/Rev8')

INSERT...

Luis Cazares (8/11/2015)

---

As you might have noticed, BEGIN and END won't define the begin and end of a stored procedure.

A stored procedure must be the only statement in the batch,...

Duly smacked

Alvin Ramard (8/11/2015)

---

Eirikur Eiriksson (8/11/2015)

---

mar.ko (8/11/2015)

---

WHILE @@FETCH_STATUS = 0

BEGIN

FETCH NEXT FROM C_tables INTO

@ColName

,@ColOrdPosit

,@TabSchema

,@TabName

,@ColDataType

,@ColDefaultVal

;

PRINT @ColName + ' ' +STR(@ColOrdPosit) + ' ' +@TabSchema + ' ' +@TabName + '...