So, you don't use resultset from sp_GetAllEmployees anywhere. Right?

So, if sp_CountEmployees will call sp_GetAllEmployees how it's gonna use returned resultset?

I still cannot figure out - what suppose to call sp_GetAllEmployees and use its results?

P.S. Don't use "sp_" prefix in names for SP. It's VERY bad practice.

Where you suppose to place this counting script?

Do you need Excel speadsheet or .csv file will be enough?

Did you try to call DB from Excel using External Query?

Do you need numbers or strings?

If values 12 and 12.0 are different for you and must be stored and returned differently?

Probably you cannot significantly improve performance of this query.

The whole database requires refinement.

Clause like this:

LIKE '%LOA.%' OR sym LIKE '%HIPAA%' OR ...

shows that you have data mixed with other...

There are no datetimes with blank time. It's just the way EM presents datetimes with zero time parts.

I cannot recommend to update or not to update anything because I don't...

Can you explain why you need dynamic SQL here?

DATEADD(n, -1, [DateTime])

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=332102

What's wrong with money datatype?

There is no such datatype as float(8,2).

RTFM.

In scientific applications you care not about number of digits after decimal point but about precision, about trusted digits in a value.

Did you ever had problems with adjustment of money...