mick burden (7/17/2014)

---

Thanks, dte will always change as it's a date and time field and is updated every 30 mins, the ipaddress field could remain the same over several days...

Quick thought on this problem, if the IP address is the unique key with a temporal attribute of Recorded Date (dte), there is no way of telling if an IP...

Jack Corbett (7/16/2014)

---

Eirikur Eiriksson (7/16/2014)

---

No implied either, my respect on handling the situation! So far, JC is the only one that has managed to rub me the wrong...

JA quick code here, not a full solution, just to get you going;-)

😎

USE tempdb;

GO

;WITH EMP_TRAN AS

(SELECT EmpID, TransDate FROM (VALUES

('00001','1/1/2014')

,('00001','1/2/2014')

...

This sample is kind of a walk through, add column, update with encrypted, mask the clear text etc..

😎

USE tempdb;

GO

CREATE TABLE dbo.Name_and_SSN

(Full_Name VARCHAR(50),

CLEAR_SSN VARCHAR(12));

INSERT INTO dbo.Name_and_SSN (Full_Name,CLEAR_SSN)

VALUES

('Egor Mcfuddle' ...

Miles Neale (7/16/2014)

---

OCTom (7/16/2014)

---

crussell-931424 (7/16/2014)

---

I can't count the number of times management has presented me with an assignment which is the solution to some problem they have. Once implemented and...

First thought would be a proper four part notation: [mylinkServerName].[Mydatabase].[my schema].[mytable]

😎

Welsh Corgi (7/16/2014)

---

I started out by asking a basic question about encryption.

I am Grateful for the help and I got my answer. Then I asked about the next steps.

If I...

Lynn Pettis (7/16/2014)

---

Eirikur Eiriksson (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

TomThomson (7/16/2014)

---

Jack Corbett (7/16/2014)

---

Steve Jones - SSC Editor (7/16/2014)

---

GilaMonster (7/16/2014)

---

Jeff Moden (7/15/2014)

---

To be honest, I'm glad this person is taking such caution...

Lynn Pettis (7/16/2014)

---

TomThomson (7/16/2014)

---

Jack Corbett (7/16/2014)

---

Steve Jones - SSC Editor (7/16/2014)

---

GilaMonster (7/16/2014)

---

Jeff Moden (7/15/2014)

---

To be honest, I'm glad this person is taking such caution and has such FUD...

Did you try the code from this post?

😎

TomThomson (7/16/2014)

---

Welsh Corgi (7/16/2014)

---

Tom, thank you very much for your help.

If you were to execute the code that I posted you will find that it does not not store a...

There are some errors in your code, mainly table an column references (non existing table and/or column)

Here is an example using code I pointed to earlier

😎

USE tempdb;

GO

CREATE TABLE dbo.Name_and_SSN

(Full_Name VARCHAR(50),

encodedSSN...

On the line of George Orwell, "one-size-fits-all as not all sizes are equal"

😎

Sean Pearce (7/16/2014)

---

I did some investigation and found the problem, XPStar.dll contains a bug.

File Version 2014.120.2000.8

Product Version 12.0.2000.8

Size 409 KB

As a workaround, and the method I used to prove my...