It sounds like a CASE statment would work.  But it would help if you could give us some sample data, your current output, and what you hope to achieve... 

R and W seem to have the same calculation, but you are naming your output differently.  If that is important, than this looks fine.  Is this slow? 

Have you tried putting the data into a #TempTable and selecting DISTICT from there? 

(Are there any aggregates in your select statement?) 

Here is a bulldozer approach.  Hopefully, someone will come up with something more efficient...  (I added some data for a check, but I do not know how many [Size] entries...

I think you are on the right to prove this is bad.  Due diligence is often neglected when someone without Technical expertise or experience makes decisions. 

Capture this stuff and...

NULLs are not generally a very good choice as a Default.  You may want to consider accepting the 1900 date as NULL does not equal NULL and NULL has numerous...

Here is an example of a Trigger I recently got help with here. 

You have some choices to make.  You can insert all of the information into one table by...

I had neighbors from there.  They gave me a calendar of sites from that city.  Very beautiful! 

I grew up in the midwest US (one of those I / O...

I know you are in Canada - that is why I asked you...  I think sushila is in the US on the east coast somewhere.  Remi seems to be the...

I have been using constraints within the JOIN [ ON( TablA.[ID] = TableB.[ID] AND TableB.[Description] = 'A') ] working under the assumption that the optimzer will handle this better. 

Am...

N.S.  (Just saw him in DC - great show!  my son is into magic).  Oh wait - you are thinking about the book - duh! 

It also forced me to...

OMG!  You updated your profile!  I had no idea...  sorry I missed that!  It is nice to look at a beautiful face, (being happily married and in a different state...

I'm in the does not matter camp as well.  But my personal style is the same as yours...  

Let me see if I understand this correctly.  You have multiple '%sale%' tables that can contain the column, (I still always want to say field) tax_info. 

You want to only...

Kevin,

Please explain to me how you get your data into SQL Server.  Is it in a one column table?  Did you use Enterprise Manager to load it? 

Once I...