You are welcome and thanks for letting us know. Hopefully now you see the importance...

Like this?

insert #Match

select c.id as CustomerId, p.id as PersonID, 'FirstName' as MatchType

from #Customers c

join #Person p on c.firstname = p.firstname

union

select c.id as CustomerId, p.id as PersonID, 'LastName' as...

So you want the cartesian that I explained about 40 posts ago? Give me about 2 minutes and I can knock this out.

Siten0308 (5/21/2012)

---

ok now for the explanation

using the second row insert of match as an example:

Insert #Match

select '1', '6', 'firstname' union all

first number 1, comes from table Customer, second number...

Lynn Pettis (5/21/2012)

---

Siten0308 (5/21/2012)

---

sorry again, offically this works, i tested it twice and will work:

insert Match2

select '1', '1','firstname' union all

select '1', '6', 'firstname' union all

select '4', '2', 'address' union...

hehe you are pretty close. Thanks for recapping all the scripts and such that will certainly help. If you just create inserts for your match table based on the sample...

No what we keep asking for is for you to tell us what those values are. Not pseudocode, not an explanation of how to do it. Notice how the sample...

toddasd (5/21/2012)

---

If it is already a space why change it to a space? Wouldn't this get everything:

Select ISNULL(Item, ' ') from ITEMS

Or are you trying to find values that...

Better, we now have 2 out of 3 things we need. We have ddl and sample data. What is the desired output from this sample data. You said something about...

Siten0308 (5/21/2012)

---

Sorry everyone for that, now i understand and will make sure I did that in the future. Ya I pointed out about C# because i know it will help...

Pretty hard to tell without anything solid to look at but I think you could make your query a bit simpler like this:

select case when ITEM is null then '...

Hard to say without ddl but if the ID is included in the join condition that should work and not get cartesians.

Is there something that DENYs select on that object. DENY will always trump GRANT.

dkschill (5/21/2012)

---

SQL and C# are a complete paradigm shift. You have to think in terms of sets. For your issue there isn't a great way to do it...

Siten0308 (5/21/2012)

---

oops sorry yes for the match table its below on how it is, very simple

Match table

Customerid ...