You say "I have two tables", but from the rest of the post it seems you have one table with two columns.. I will write the query for this situation,...

Hi Vandy,

this is a very frequent question on these forums. I'm sure you'll be able to find several topics about this problem, like for example http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=303442

However, the best recommendation...

The best way to treat errors is to not allow them at all (which is what Sergiy posted), and the best way to write cursors is to not write them...

Well, I suppose you understand how standard condition

WHERE my_column LIKE '%new%'

works. It returns all rows where the string in my_column contains "new". The query you are asking about does precisely...

I'm not sure why one would use precisely this form... IMHO it is more complicated than necessary, and the complication does not bring any advantages :

SELECT s.* FROM Students s...

You can't do that this way - a variable can not hold several comma-delimited values. There are two ways to solve such requirement - either use dynamic SQL (not really...

Using the query posted in the thread you are referring to, you can do this:

SELECT C.*, E_prim.contactName as [Primary], E_any.contactName as [Any],

    COALESCE (E_prim.contactName,E_any.contactName) as [THE Contact]

FROM @tblCompanies C

LEFT JOIN...

Sergiy,

I think you overlooked this:

"I need to select the latest Visit (all columns) for each Patient listed in tblPatients. I want one record for each Patient."

That seems to be pretty...

Also see this post http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=302916 for a similar problem - even more complicated, because the requirement is not to number all rows from 1 to n, but to start numbering...

And one more way to do that - taking advantage of IDENTITY column (I'm using part of Ram's code, so that you can compare the differences):

/*prepare tables*/

DECLARE @tbl1 TABLE (ActualValue ...

By the way, I'm not sure I understand everything.. in the table IM_Grid, color is CHAR(9) and size is CHAR(5). In the first two tables, you have color_index and size_index,...

OK, after re-reading your post I decided to post this.. I'm not sure whether it helps, but let's hope so.

You didn't mention number of rows in table IM_Grid, but since...

Just a question, did you try to compare execution plans for different queries (hardcoded, join)? It is always good to start with that if you have problems with performance. Is...

Hello,

just to make clear what you need - post header says "Insert row count", but actually you seem to be asking for a way to SELECT (not insert) row number (not...

I would definitely use the JOIN solution... just check indexes on both tables and make sure execution plan is using them.