I need to create a report that tallies up the headcount of attorneys. Attorneys can have three different types of headcount(pay, work and count). They want
to be able to run the report for whichever headcount type they choose.
The simplest example of the select statement is as follows
select title
, sum(work)
from employeemonthfte
where period between @BeginPeriod and @EndPeriod
I need to be able to replace sum(work) with whatever headcount they choose (pay, work or count). I'm not sure how to go about doing this. Any help would be appreciated.
to be able to run the report for whichever headcount type they choose.
The simplest example of the select statement is as follows
select title
, sum(work)
from employeemonthfte
where period between @BeginPeriod and @EndPeriod
I need to be able to replace sum(work) with whatever headcount they choose (pay, work or count). I'm not sure how to go about doing this. Any help would be appreciated.