Thanks Drew, your script failed as it also picks up records like:

DyKE; GaY; K!{%^r; K'r; K([[}-r; K>;[|?[r; K[)r; K[-[#,[r; K[:R; K[;$[r; K[R; K[r; K^r; K{#r; K{&[R; K{&[r; K{:}>r; K{;r; K{>r;...

Thanks

ScottPletcher (7/31/2015)

---

halifaxdal (7/31/2015)

---

Can you explain '%[a-z]:%\%.%'? My first time to use it, thanks. Basically the sample data is sample only, the real data could be randomly and I have no...

Can you explain '%[a-z]:%\%.%'? My first time to use it, thanks. Basically the sample data is sample only, the real data could be randomly and I have no idea what...

ScottPletcher (7/31/2015)

---

Maybe this will give you some ideas/alternatives:

SELECT

breach_content,

RIGHT(breach_content, CASE WHEN SUBSTRING(breach_content, LEN(breach_content) - 3, 1) = '.' THEN 3 ELSE 4...

what I come out is something like the following script and I am really not satisfied with it, let alone it processes 3 letter extension only and I need to...

Thanks Drew, Eirikur, Scott

I have decided to take your suggestion and create another bridge to avoid using the painful concatenated values in a column.

drew.allen (7/15/2015)

---

The standard way to handle a many-to-many relationship in an OLTP database is a bridge table, because that is the most efficient. Create a table for group memberships that...

drew.allen (7/15/2015)

---

Also, a 1-1 relationship means that not only can the person only have one group, but the group can only have one person. Groups, by definition, allow for...

The only thing left here now is the ORDER BY:

The following code throws me an error:

Column "Reporting_DailyDlpDetail.POLICY_NAME" is invalid in the ORDER BY clause because it is not contained in...

cphite (7/7/2015)

---

I would create a lookup table: lookup_Policies (Policy, SubPolicy)

The data in that table would be like:

Policy1, Policy_Name 11

Policy1, Policy_Name 12

Policy1, Policy_Name 13

Policy2, Policy_Name 21

Policy2, Policy_Name 22

...etc

Then I would do...

ScottPletcher (7/7/2015)

---

WHERE (INSERT_DETECT_TS between '20150602' and '20150603')

You cannot safely use between. You need to use the >= and < (not <=, as in between) that I used earlier:

WHERE (INSERT_DETECT_TS...

The new issue pops up on this task:

For a particular policy, the rolled up sub policies are different in the case of High and the rest.

i.e. If the policy =...

I've worked it out:

Sum(CASE WHEN ACTUAL_SEVERITY = 1 and STATUS = 'New' THEN 1 ELSE 0 END) AS [New High],

and off course put Status and ACTUAL_SEVERITY in the Group By

Thanks...

Alvin Ramard (7/7/2015)

---

Your first query was getting the count of distinct Incident_id, while your second query was getting distinct combinations of Incident_id and policy_name. Surely you can see those two...