So what you are saying is that BaseStage must be 1 in at least one record of BOTH groups, correct?

Your question is really vague. Would you please explain in greater detail what you mean by updating the table?

Since all you want is the TemplateName where BaseStage is 1 in at least 1 record in a group, the following works:

CREATE TABLE #tblTemplates

...

I have to disagree with that. You make the neighborhood what you want. You either take the time to get to...

pawana.paul (9/7/2012)

---

Hello Everyone,

I have an issue when pulling the data from multiple tables.

Table A has column Date_Created

Table B has column Date_Created

The format is somethine "2012-09-06 13:04:01.067". There is a time...

What is to re-read? The conversion by...

TravisDBA (9/7/2012)

---

majorbloodnock (9/7/2012)

---

TravisDBA (9/7/2012)

---

It has been my experience at events like this that if security personnel do not directly see it happen, or on closed circuit camera, then they do...

Andrew-495157 (9/7/2012)

---

I had thought that SQL coerced the @OrderID int value to a varchar to do the comparison

You are suggesting that SQL does the coercion the other way - coerces...

Nope, more like this:

with basedata (

name,

addy,

ph,

grade

) as (

select

name,

...

Now look at the original code:

WHERE Job_Bag.Description_Reference = @OrderID -- SQL was trying to conver August...

sku370870 (9/7/2012)

---

Apologies, I was modifying my first post when I thought - that will just confuse the issue. Can we start again please?

CREATE TABLE #tblBlocks

...

Again, based solely on the initial post with a little more data added:

CREATE TABLE #tblBlocks

(

...

sku370870 (9/7/2012)

---

Thanks for your reply ... it's giving me the opposite of what I want because I phrased my question back to front.

What I need is:

Join to the temporary table...

I'd also like to see the DDL (CREATE TABLE statement) for the table PR_CF_HST.

robert.baird 2778 (9/7/2012)

---

ok.... i got it... the object referenced at the end is the basedata. so looking at the result set, i see all of the values.... but that leaves...