curiouswebster
asked on
T-SQL: Need Group By to use "fuzzy logic"??
I have a query which groups the exceptions table by Message Name.
At the moment, I am grouping by the Title and find over a million records with the sale title: "SF Upsert". That's short for SalesForce.
What I need to do is drill down a layer and group by messages but can not be successful due to specific info added to the message.
For example:
00QL0000008PJC8MAO DAX10000162 john.runn@mydomain.com Main Phone and Mobile can only accept numbers.
00QL0000008PJC8MAO DAX10000162 beth.smith@mydomain.com Main Phone and Mobile can only accept numbers.
Do I need to manually extract errors, like 'Main Phone and Mobile can only accept numbers' and do a specific query for this?
What options do I have? The table is huge, so any query takes a long time to execute. I suspect any type of "fuzzy logic" would not be feasible to run.
At the moment, I am grouping by the Title and find over a million records with the sale title: "SF Upsert". That's short for SalesForce.
What I need to do is drill down a layer and group by messages but can not be successful due to specific info added to the message.
For example:
00QL0000008PJC8MAO DAX10000162 john.runn@mydomain.com Main Phone and Mobile can only accept numbers.
00QL0000008PJC8MAO DAX10000162 beth.smith@mydomain.com Main Phone and Mobile can only accept numbers.
Do I need to manually extract errors, like 'Main Phone and Mobile can only accept numbers' and do a specific query for this?
What options do I have? The table is huge, so any query takes a long time to execute. I suspect any type of "fuzzy logic" would not be feasible to run.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER