That's right.

E.g if you have have 10 employees and 4 of them are foreign, percentage
of foreign employees = (4/10)*100 = 40%

-----Original Message-----
From: YIF
[mailto:mssqldba-ezmlmshield-x17254972.[Email address protected]
Sent: 01 February 2006 05:20
To: LazyDBA Discussion
Subject: Query Help





Hello All
I have a table called contracts, which has the number of employees for
each contract, I need to get the percentage of the foreign employees the
contracts table as follow Emp_Total numeric Foreign_Employees numeric
Local_employees numeric

Is it by dividing the Foreign_Employees from Emp_Total

I appreciate any help
Regards




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html


This email and any files transmitted within it are private and confidential.
If you are not the intended recipient, this email and any attachments within it have been transmitted to you in error.
You are prohibited from using, copying, distributing or otherwise using the information contained within this email.
Nothing in this email message amounts to a contractual or legal commitment on the part of Optilan unless confirmed by a communication signed on behalf of the company.
Any email cannot be guaranteed to be secure, error free or free from viruses. Although every possible care is taken by Optilan, Optilan does not accept any liability whatsoever for any loss or damage which may be caused as a result of the transmission of this message by email.


MS Sql Server LazyDBA home page