The closest I can come up with is something like this.

select *

from security_assignment sa

join matter m on m.r_type = sa.r_type

join [group] g on g.group_id = sa.group_id

join category c on...

It is crystal clear except for the portions where you have a series of dots and the...

!!!!!!!!!!!! hehe !!!!!!!!!!!!

Jack Corbett (3/7/2014)

---

So for those of you who knew I was unemployed. I have an offer on the table. The only problem is that it involves...

JohnFTamburo (3/7/2014)

---

skaggs.andrew (3/7/2014)

---

Hi,

I need help parsing out a field, but I am not sure how to extract just the specific part that I need.

Examples:

ELA-DUPLECHEIN, KELLIE-13-14-2(A-B)

READING -LANDRY, MICHELE B-13-14-2(A)

What...

Here is where this type of architecture really starts to break down. What happens if you have a row where the Collections would overpay the Due? Which one do you...

You need to understand that I have no idea what this data represents. You need to provide the business rules here not just some vague explanation about exact matches.

Why should...

SQLRNNR (3/6/2014)

I don't like the constant placement of a ; right before a CTE. It's wrong. A CTE does not require a ; in order to execute. ...

yuvipoy (3/6/2014)

---

In general it will be a bit faster because a guid is 16 bytes where a bigint is only 8 bytes. It is not likely to make a huge...

The Dixie Flatline (3/6/2014)

---

Lynn also refuses to put commas at the beginning of a list of values. 🙂

Given how SQL treats white space, a semicolon is more properly described...

OK we do have some working ddl and sample data. There is one VERY critical component still missing. What are you trying to do? Meaning, given your sample data what...

Moe_Szyslak (3/6/2014)

---

Hello all,

I have a single string "XYZ00001|Test_b|XYZ00002|Test_a|XYZ00003|Test_c" that will continue to grow over time.

Is there a way I can extract the values from the string into two separate...

This is more personal...

Jake Shelton (3/6/2014)

---

Hi all,

I'm going around in circles trying to visualise what's happening in this code,

declare @ReturnValue int, @ProcessFlag int

exec @ReturnValue=spGetProcessFlag @ProcessFlag output

select @ReturnValue as ReturnValue, @ProcessFlag as ProcessFlag

I...

+1

To paraphrase Lynn Pettis,...