Call function with wrong order parameters
Today, i made a mistake, when i call a function, pass the wrong order of the parameters,
such as
ShowReport(GroupID, ClassID,ProcessID);
but when i use, just call as
ShowReport(GroupID, ProcessID,ClassID);
so i use the parameters can get right result in ssms(sql server manage studio), but wrong in program.
sould take care detail info
select pc.GroupCount, pp.ProcessID,pi.ProcessName,Hits, CostTime
from [PerLogDB].[dbo].T_PerformanceInfo as pp, [PerLogDB].[dbo].T_CaseInfo as pc, [PerLogDB].[dbo].T_ProcessInfo as pi
where
pc.GroupID = 100 and pp.ClassID=2000
and pp.CaseID=pc.CaseID and pp.ProcessID=pi.ProcessID and pp.ProcessID=310000
and pp.TimeStamp ='3/4/2012';