Something like this maybe?

update a

set JusticeID = j.JusticeID

from Justice j

join Attendee a ON a.JusticeLName = b.JusticeLName

Please note that I changed your aliases. It is not a good habit to...

It is entirely unclear what you expect for output. What should the output look like (actual values) for the sample data you posted?

BUT...do you understand it? That by far is more important than the fact that it works. 😉

OK so you can drop the tally table portion of my previous post and simplify it to this.

select Name, cv.CVID,

MAX(case when dr.DeclarationQuestionID = 9 then cast(answer as varchar) end)...

Miller (4/14/2014)

---

OK, I ran the splitter tests.

I had to modify the BetterSplit a little: Switched to varchar(8000) instead of nvarchar(max) for list parameter. This needed to get good comparison between...

OK I think I got it. You are going to need a tally table for this because you have missing data that you want to report.

BTW, you should stop using...

Little Nick (4/14/2014)

---

I knew my table design is silly.

To built column name and data, see below:-

1- Answer-Staff (9) is a DeclarationQuestionID=9 and Column is Answer

2- Response-Staff (9) is a...

That does NOT help me understand what you want. I can't see your screen, I have no idea what datatypes are in your table, I have no idea what values...

swoozie (4/14/2014)

---

Well in this shop, data is stored and these are the topics I have to report off of. All SQL, no front in application to sit on top.

Simple...

You did a nice job posting ddl and sample data. However, once you got to the output it went awry very quickly. You have things like "Answer-Staff" , "Response-Staff". What...

I...

HildaJ (4/14/2014)

---

It's all the transaction history that we have in our accounting system. After the selection, depending on the results return, there's another set of events that are happening...

jbalbo (4/14/2014)

---

I think I need something like this

But I really have my where clause screwed up !!!

sELECT distinct dbo.RECORDED_SERVICE.OID, MAX(dbo.RECORDED_SERVICE.STARTTIME) AS Expr1, dbo.SERVICE_ITEM.SERVICE_ITEM_DESCRIPTION, dbo.CostCenter.AbbrName,

...

I would...

Lynn Pettis (4/14/2014)

---

Sean Lange (4/14/2014)

---

Lynn Pettis (4/14/2014)

---

Sean Lange (4/14/2014)

---

Lynn Pettis (4/9/2014)

---

Sean Lange (4/9/2014)

---

Yes indeed. One suggestion I would...