Yeap clear as mud. Just once it would be nice if you actually followed the advice you offer to others by actually reading the article you...

Notice how Anthony posted sample data? It is readily consumable so nobody has to generate based off what you typed. From your description it seems like you could use something...

First thing I would suggest is to replace your split function with the one in the article I reference in my signature. Then to get your data you will want...

Methew (6/12/2012)

dwain.c (6/12/2012)

Well, it's not like Inserted.ID is...

Lynn has a great blog post with lots of common datetime routines. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

See if that helps.

I am willing to help but since this sounds like homework the best I will...

Your requirements are incredibly unclear. Nobody can understand what you are trying to do here. Let's take your ddl and sample data and try again.

DECLARE @param1 VARCHAR(25) = 'Banana',

@param2 VARCHAR(25)...

About all you can do is use your select statement you posted and tweak it a little to help build your sql.

I think you meant to post this as a reply to Gail? http://www.sqlservercentral.com/Forums/Topic1313580-1291-1.aspx

Well I didn't actually look at an execution plan so maybe I am not...

Great job posting ddl. The sample data is too sparse for the second table to be able to provide much help. Also I am pretty uncertain what you want for...

This sounds a lot like homework. What have you tried so far?

I did and found it rather odd what it was doing. 😛

OK so we ignore the order by and assume a random order. The way you coded it is making what should be a set based update into an RBAR update....

There is 1 and only 1 way to ensure the order of data...

Yeah that didn't really help explain what you want but maybe something like this?

select t1.ID from #Temp1 t1

join #Temp2 t2 on t2.ID = t1.ID and t2.GDesc = @param2

join #Temp4 t4...