LEFT OUTER JOIN provcom c on a.PROVNO1 = c.providerno and a.FYE = c.dteFiscalYearEnd

Have a look at this article:

http://www.sqlservercentral.com/columnists/jsack/sevenshowplanredflags.asp

Have a look at this article:

http://www.sqlservercentral.com/columnists/jsack/sevenshowplanredflags.asp

Answer is right here: http://msdn2.microsoft.com/en-us/library/ms173829.aspx

(check the chart)

Absolutely (as long as you have MAPI correctly configured).  Have a look at xp_sendmail:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_6hbg.asp

Do the select into a temp table and then select / group on that.

sure

INNER JOIN inserted i ON

t.Col1 = i.col1

and

t.col2 = i.col2

and

t.col3 = i.col3

There's also the CHECKSUM function that you might want to look into.

Try this: 

select

Col1, Col2, Col3

from

Tab1

where

Col2

=

" I will only know the value for col2."

I don't understand this.  Are you saying that there are other possible combinations of values for Col1 and Col2?  If so, define...

select Col1, Col2, Col3

from Tab1

where

Col2 =  'Q'

or

Col1 = 'B'

select Col1, Col2, Col3

from Tab1

where

Col2 IS NULL

Have a look here:

http://www.sql-server-performance.com/ma_finding_duplicate_indexes.asp

Why in the world not?

Wrapping things up in a begin..end statement is a perfectly acceptable, workable and logical solution.

Assuming YYYYMM column is a string, try this:

where

cast(YYYYMM+'01' as datetime) >=