You could simplify the great example from Geoff (and much thanks for putting together consumable data).

select

FoodGroups.FoodGroupID,

FoodGroups.FoodGroupName,

FoodGroups.FoodGroupDesc,

Foods.FoodNameID,

Foods.FoodName,

Foods.FoodShortName

from

Foods inner join

FoodGroups on Foods.FoodGroupID = FoodGroups.FoodGroupID...

Eugene Elutin (5/24/2013)

---

...

I did mean that way. You are correct it is not always faster but it would be most of the time. It is more code and I think...

Eugene Elutin (5/24/2013)

---

Sean Lange (5/24/2013)

---

It is absolutely possible by using a left join. The question is why...

ISNULL is t-sql dialect and COALESCE is ANSI standard.

The return types are also slightly different.

http://msdn.microsoft.com/en-us/library/ms184325.aspx

http://msdn.microsoft.com/en-us/library/ms190349.aspx

--EDIT--

Eugene beat me to it again. 😛

It is absolutely possible by using a left join. The question is why does is matter if...

andy mack (5/23/2013)

---

Thanks for the reply.

It's not so much the size of the DB or even the $ cost. It's the amount of effort the client would have to go...

cljolly (5/23/2013)

---

I used to use Focus before migrating to Sql and miss some of the commands in Focus and not in SQL. . One statement that Focus had was called...

Lowell (5/23/2013)

---

I have a certain fondness for doing solutions in TSQL, or at least be centered around TSQL, regardless of whether it's the right tool for the job or...

As Eugene said, we need some information to be able to help. We can't see your screen and we are not familiar with your project. We need to have something...

You're welcome. Glad that worked for you.

kshatriya24 (5/23/2013)

---

I am new to SQL enviornment. I have question regarding using select command. Current SQL command

Select caseid, casetype, Casesubtype and casedescription field from table. The report comes out...

Can't really help you...

brian.geregach (5/23/2013)

---

All;

I am having an issue where my rows are calendar months and my columns are different vendors. I can get the information, but the months are sorted alphabetically...

What information are you looking for? It is very different if you are talking about details of the physical...

Abu Dina (5/23/2013)

---

Crude but quick way of doing this is to copy then run the outcome of a query like the below:

select 'update ' + table_name +

'set ' +...