dwain.c (5/21/2012)

---

You're starting to sound like Jeff!

That's a compliment. More people should...

Well, I have run several tests of both over a heap table with 1,000,000 rows of data and both run around 2.5 seconds with no clear advantage to either one....

Here's why Dwain:

CREATE FUNCTION dbo.itvfn_FormatTimeHHMMSS(

@TimeInSeconds INT

)

RETURNS TABLE WITH SCHEMABINDING

AS RETURN

(SELECT

CAST(@TimeInSeconds / 3600 AS VARCHAR) + ':' +

RIGHT('0' +...

Lynn Pettis (5/21/2012)

---

Also, you now need to explain, usig the sample data, how each row in #Match statisfies the match requirements as I don't see it based n the provided...

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 all

select '5',...

Also, you now need to explain, usig the sample data, how each row in #Match statisfies the match requirements as I don't see it based n the provided data.

Siten0308 (5/21/2012)

---

here go, this works:

insert Match

select '1', '1', 'firstname'

select '1', '6', 'firstname'

select '4', '2', 'address'

select '5', '1', 'firstname'

sorry for the confusion I put a # sign before matching...

Again, make sure the code you post works as expected. Problem with the code for populating #Match.

Also, the results have no correlation to the sample data that is inserted...

Best way, restore it to test, dev or sandbox server. Anything else could just give you a false sense of security.

Siten0308 (5/21/2012)

---

Again thank you, the output I would like is if bob customer id 1 from customer table matches the first name bob from person table with id 27, then...

By the way, the code you posted above has a few issues. You really need to test your code before posting it. Here is what I have after...

What is your expected output based on the sample data?

Once you post the DDL (CREATE TABLE statement) for your tables, sample data (INSERT INTO statements, about 6 to 10 rows of data) for the tables, and the expected...

Save you execution plan as a .sqlplan file and attach that to your post insterad of inserting the XML version in your post. Sorry, but reading the XML is...

I was looking at this and got a bit confused. It appears that the word description of the problem doesn't quite match to the OPs code in the initial...