Jeff Moden (10/25/2014)

---

Eirikur Eiriksson (10/25/2014)

---

Keep in mind, there's no such thing as a bad code (if it works), your efforts are as worthy as mine any given day, keep up...

Either to an explicit type cast to numeric or float using cast or convert or multiply the column value with 1.0,...

Sorry about the error, quick copy/paste without checking...

SQL Server performs an Integer division on whole...

Good job, the scripts do explain what is happening

😎

The table dbo.MMA_KPIVAR_DAT can have many instances of the same VARIABLE_ID, CLIENT_ID and SITE_ID. The table dbo.MMA_KPIVAR_MST can have many instances of...

No worries, there are several ways of doing this, have a quick look here for Generate Scripts (SQL Server Management Studio).

😎

Quick question, can you post the DDL (create script) for those three tables?

😎

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