Comments by Seema.Net (Top 2 by date)

Seema.Net 8-Sep-14 6:40am View

Yes, Issue was from IIS Setting.

Seema.Net 23-Dec-13 1:59am View

if u want to show fa.FuncationalArea put this with Group By
select COUNT(*),fa.FuncationalArea from tbl_Job_OrgOpeningDetail org
inner join tbl_job_Functional_Area fa on org.Role_type=fa.Funcational_id
where org.Role_type in (21,15) Group by org.Role_type,fa.FuncationalArea

OR

select COUNT(*),COUNT(fa.FuncationalArea) from tbl_Job_OrgOpeningDetail org
inner join tbl_job_Functional_Area fa on org.Role_type=fa.Funcational_id
where org.Role_type in (21,15) Group by org.Role_type

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid