What Is My Handicap Index (HCI)?
Select player, course and tee here. For other parameters (e.g., date range) use Global Filters.
Do You Have GHIN Scores Not Stored Here? Then The HC Computed Here Will Differ.
Get Your GHIN HC
|
Select cast('11.1' as Decimal(4,4)) as dblDiff, playerName as 'Player', CourseName , CourseType, TeesPlayed as 'Tees', HCThatDay as 'HC','tbd' as 'Used', MatchID as 'MatchID*','tbd' as 'Rating', 'tbd' as 'Slope', 'tbd' as 'Diff', (H1Gross + H2Gross + H3Gross + H4Gross + H5Gross + H6Gross + H7Gross + H8Gross + H9Gross + H10Gross + H11Gross + H12Gross + H13Gross + H14Gross + H15Gross + H16Gross + H17Gross + H18Gross ) as 'ESC', Whole18Gross,cast('0' as Decimal(2)) as 'Points Earned', Whole18Points, H1Gross as H1G, H2Gross as H2G, H3Gross as H3G, H4Gross as H4G, H5Gross as H5G, H6Gross as H6G, H7Gross as H7G, H8Gross as H8G, H9Gross as H9G, H10Gross as H10G, H11Gross as H11G, H12Gross as H12G, H13Gross as H13G, H14Gross as H14G, H15Gross as H15G, H16Gross as H16G, H17Gross as H17G, H18Gross as H18G From `statsack_tpmc`.`Scores` Order by playdate DESC, ESC ASC limit 40 |