Viewing 15 posts - 31 through 45 (of 58 total)
Jason,
That works great. I've been fooling around with the thresholds to try and get the best match before I present it to the business. I also made a couple of...
September 1, 2015 at 2:40 pm
Jason A. Long (8/31/2015)
craig.bobchin (8/31/2015)
I'll check the...
August 31, 2015 at 10:00 pm
Jason A. Long (8/31/2015)
-- Add the two new columns to dimMember...
--ALTER TABLE dbo.dimMember ADD GroupID INT;
--ALTER TABLE dbo.dimMember ADD MatchQuality INT;
IF OBJECT_ID('tempdb..#MatchScores') IS NOT NULL...
August 31, 2015 at 7:51 pm
Jason A. Long (8/31/2015)
Please format your test data in the form an insert statement. I can't do anything with in the form it's in now.
Sorry, Here it is:
INSERT INTO [dbo].[dimMember]
...
August 31, 2015 at 3:23 pm
Jason A. Long (8/28/2015)
craig.bobchin (8/28/2015)
I modified your code for our table/fields and it doesn't quite work. I set the threshold to >=4 and of the 30k records in the table...
August 31, 2015 at 12:18 pm
Jayanth & Jason, I am out of town this weekend, and will give your suggestions a try when I get back to the office on Monday. Thanks
August 29, 2015 at 7:18 pm
Jason A. Long (8/27/2015)
The idea is...
August 28, 2015 at 4:39 pm
Jayanth_Kurup (8/27/2015)
August 28, 2015 at 11:01 am
Jayanth_Kurup (8/27/2015)
August 27, 2015 at 11:50 pm
Jeff Moden (8/27/2015)
craig.bobchin (8/27/2015)
ScottPletcher (8/27/2015)
August 27, 2015 at 9:36 pm
ScottPletcher (8/27/2015)
August 27, 2015 at 3:05 pm
Jeff Moden (8/26/2015)
August 27, 2015 at 11:52 am
Thanks. That looks very similar to what I'm looking for. I'll give it a try.
Another though I had was doing a fuzzy lookup in SSIS when I load the table....
August 27, 2015 at 11:51 am
Jeff Moden (8/26/2015)
August 26, 2015 at 5:51 pm
Jeff Moden (12/3/2014)
Jeff Moden (12/3/2014)
craig.bobchin (12/3/2014)
declare @MaxRowdateTime datetime
select @MaxRowdateTime = max(DATEADD(day, DATEDIFF(day,'19000101',row_date), CAST(CONVERT( TIME, STUFF( RIGHT( '0000' + CONVERT( VARCHAR(5), starttime), 4), 3, 0, ':')) AS DATETIME2(7)))) from ...
December 4, 2014 at 11:28 am
Viewing 15 posts - 31 through 45 (of 58 total)