Jerin Kurian - Professional Profile

Action

Author

Authority

Debator

Editor

Enquirer

Organiser

Participant

If Owner

Member Types

Have no restrictions on voting frequency

silver

Bypass spam checks when posting content

silver

gold

SubEditor, Mentor, Protector, Editor

Store personal files in your account area

platinum

SubEditor, Editor

Have live hyperlinks in your profile

bronze

silver

SubEditor, Protector, Editor

Have the ability to include a biography in your profile

bronze

silver

SubEditor, Protector, Editor

Edit a Question in Q&A

silver

Yes

SubEditor, Protector, Editor

Edit an Answer in Q&A

silver

Yes

SubEditor, Protector, Editor

Delete a Question in Q&A

Yes

SubEditor, Protector, Editor

Delete an Answer in Q&A

Yes

SubEditor, Protector, Editor

Report an Article

silver

SubEditor, Mentor, Protector, Editor

Approve/Disapprove a pending Article

gold

SubEditor, Mentor, Protector, Editor

Edit other members' articles

SubEditor, Protector, Editor

Create an article without requiring moderation

platinum

SubEditor, Mentor, Protector, Editor

Approve/Disapprove a pending Question

Protector

Approve/Disapprove a pending Answer

Protector

Report a forum message

silver

bronze

Protector, Editor

Approve/Disapprove a pending Forum Message

Protector

Have the ability to send direct emails to members in the forums

Protector

Create a new tag

silver

Modify a tag

silver

I just create stored procedure and I use temporary tables in that stored procedure and select the required fields from the temporary table.

Here I attach my stored procedure..

CREATE procedure GetOperatorIndividualPerformanceSummary
(
@FromDate as datetime,
@ToDate as datetime,
@MaterialId as integer
)

as

--Drop table #TempExcavation
select sum(Ed.Trips21) as Trips21,sum(Ed.Trips23 ) as Trips23,Ex.ExDate
INTO #TempExcavation
from ExcavationDetails Ed inner join ExcavationMaster Ex on Ed.ExMasterId=Ex.ExcavationMid
where Ed.MaterialId=@MaterialId and Ex.ExDate between @FromDate and @ToDate
group by Ex.ExDate
--select * from #TempExcavation

--Drop table #TempHauling
select sum(Hd.Trips) as Trips,Hm.HaulingDate
INTO #TempHauling
from HaulingDetails Hd inner join HaulingMaster Hm on Hd.HaulingMasterId=Hm.HaulingMasterId
where Hm.MaterialId=@MaterialId and Hm.HaulingDate between @FromDate and @ToDate group by Hm.HaulingDate
--select * from #TempHauling

select Te.Trips21,Te.Trips23,Th.Trips from #TempExcavation Te right outer join
#TempHauling Th on Te.ExDate=Th.HaulingDate
GO