A part from picking it...

sqldriver (10/25/2014)

---

Eirikur Eiriksson (10/25/2014)

---

You are on the right track there, a simple solution would be to "UPPER" the values before hashing. SHA1 is quite a lot cheaper computationally than MD5...

Lynn Pettis (10/24/2014)

---

Submitted and have received my approved TRF for redeploying back to the States at the end of February. Looks like I should seriously look at making plans...

sqldriver (10/25/2014)

---

I was trying a similar approach, but couldn't get the results right. :blush:

Upper/lowercase is throwing things off, I think.

100 Musk Ox for you, sir.

SET STATISTICS IO ON

SET STATISTICS...

Quick thought, and bear with me if I sound slow :-p

1) how can you compare a date of birth to min or max age, doesn't sound right?

2) What is the...

Have a look at this post for a more complete answer

😎

To get the desired output requires some data massaging, here is an example

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA([Add], [New], [Pro], [Len], [Source]) AS

(

SELECT 'Acorn', Null, ...

Quick solution using aggregation to remove the null values

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(Advert,Network,Program) AS

( SELECT 'Acorn',NULL,NULL UNION ALL

SELECT NULL,'AC',NULL UNION ALL

SELECT NULL,NULL,'Adult'

)

SELECT

MAX(SD.Advert...

An alternative solution which doesn't require any joining. It scales well for large sets but has a weakness of returning false positives although fairly unlikely with this type of data....

Quick thought, sys.partitions is probably the best option as it does not require dynamic sql or depreciated backward compatibility objects.

😎

Ville-Pekka Vahteala (10/24/2014)

---

Koen Verbeeck (10/24/2014)

---

Nope, only 3 and that's apparently already...

Cadavre (10/24/2014)

---

Eirikur Eiriksson (10/23/2014)

---

Quick solution, should get you passed this hurdle

😎

; --terminator, not begininator 😛

WITH LAST_TABLE AS

(

SELECT TOP(1)

T.object_id

...

Koen Verbeeck (10/24/2014)

---

spaghettidba (10/23/2014)

---

Jack Corbett (10/23/2014)

---

spaghettidba (10/22/2014)

---

Stefan Krzywicki (10/22/2014)

---

Of course, regionalisms mean it could be called most anything.

For example: In most of the USA, a blended milk and...

There are quite few ways,...

Quick solution, should get you passed this hurdle

😎

;WITH LAST_TABLE AS

(

SELECT TOP(1)

T.object_id

,T.is_ms_shipped

...