Twenty-two

Ship

Why are the two not expecting result?

Love

squirrel

Got an initial working resolution. Some guy by the name of Jeff 😀 has an article: Solving the Running Total and Ordinal Rank Problems (Rewritten)http://www.sqlservercentral.com/articles/T-SQL/68467/

Thanks Jeff!

I used the "Quirky...

Thank you g.britton, I got pulled off to another task and am just getting back to this, so I will look at the two posts and see what happens.

Sorry, I was trying different things. Should cast the create date as date

, dense_rank() OVER (ORDER BY UserId,RefNum,CAST(CreateDate AS DATE)) AS RankTick

-- ,...

Hello, How about something like:

WITH Dups AS (

SELECT

bus.[Business_pk]

,[BusinessName], [Address], [Phone]

,ROW_NUMBER() OVER (PARTITION BY [BusinessName], [Address], [Phone] ORDER BY bus.[Business_pk] DESC) AS MatchRank

FROM [dbo].[TestBusiness]...

Out

You might need to have two folder share locations for log files. That is if you plan on using the wizard.

Congratulations Grant

Did not think it would give the desired results. It would however be a step toward finding the problem.

What do you get when you use a left join form CurrExRate?

Thread