, Nicholas C [nicholas-c-sm...@uiowa.edu]
Sent: Wednesday, May 22, 2019 10:51 AM
To: Pedersen, Jay G; Dan Connolly
Cc: gpc-dev@listserv.kumc.edu; Ryu, Gi-Yung
Subject: RE: [External] Re: MS-SQL hashing function?, re: Death index file
Hello, Jay:
Did you ever get a function to work for MSSQL that
nt: Friday, March 01, 2019 9:35 AM
To: Dan Connolly
Cc: gpc-dev@listserv.kumc.edu
Subject: [External] Re: MS-SQL hashing function?, re: Death index file
RE: <>
Fair enough. I will do some testing and report back to the GPC.
The following looked worth a first area of investigation:
ev@listserv.kumc.edu
Subject: MS-SQL hashing function?, re: Death index file
Non-UNMC email
Hi,
I am wondering if anyone knows if it is possible
to create a MS-SQL analog of the following
Oracle function ... which provides hasing
of SSN and DOB:
I am hoping Dan Connolly might be able to pr
ebraska Medical Center
985900 Nebraska Medical Center
Omaha NE 68198-5900
402-559-9487 (office)
402-739-3496 (mobile)
From: Dan Connolly
Sent: Friday, March 1, 2019 9:26 AM
To: Pedersen, Jay G
Cc: gpc-dev@listserv.kumc.edu
Subject: Re: MS-SQL hashing function?, re:
A web search for "sqlserver hmac sha1" showed a few approaches. I'm not
familiar enough with sqlserver to know which ones are likely to work well.
On Mar 1, 2019 6:47 AM, "Pedersen, Jay G" wrote:
Hi,
I am wondering if anyone knows if it is possible
to create a MS-SQL analog of the following
Or
Hi,
I am wondering if anyone knows if it is possible
to create a MS-SQL analog of the following
Oracle function ... which provides hasing
of SSN and DOB:
I am hoping Dan Connolly might be able to provide direction.
The fallback is to create a python script to
interface to MS-SQL and create hashed