thank you! That worked perfectly. I was trying to use another qualifier for "not equals".

I would like to add something like this:

select col1,col2,sum(col1+col2) as col3, col3/2

ARE YOU TRYING TO DIVIDE COL3 BY COL2?

IF SO, TRY THIS:

SELECT COL1, COL2, SUM(COL1 + COL2) AS COL3,...

:w00t: OOPS, sorry guys, that posted before i could format that table data better.

vendorName PayrollCountvendorNameExpenseCount

FISHER,KERRE ...

Thank you, and I will have my teammates read this particular blog, although we all have started to use your forums to look for help! I really appreciate you...

thank you so much, i wanted to make sure i am understanding this okay, and you have explained it well enough that i can write up something in Plain English...

Excellent video, i will not be so apprehensive to try to use profiler now that I have some background knowledge, however I'll have to find the suggested article, is it...

I have found searching MSDN.microsoft.com very handy once you get used to searching the site. But this little tutorial was handy for me.

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

When submitting a cover letter for job positions, this is your very first impression to your potential employer, do you really want a statement like that as your first impression?...

Hey guys,

I have a fairly large table in production with almost a million records, and I have duplicate records in that table with about 18,000 duplicate records. ...

Good point, i know the size of the transaction log has caused space issues on other servers, Thank you!

Actually, this will be my first time performing a database backup for this database, and I don't know what the backup plan is for this database but I hope to...