Return Return     Main page Main page      Update Update     PDF PDF     Choice of period :  Day Day  Week Week  All All  Customized Customized


           (m/d/yy)     



Request Mean time (ms)Max time (ms) Standard deviationMean cpu time (ms) % of system error
sql  Select
If(sap.Data='RAW CARD LOCATION',

(Select If(ad1.AssetValue=sap1.Data,'Yes', 'No') from AssetMaster am
Inner Join AssetDetails ad on ad.AssetID=am.AssetID
Inner Join AssetDetails ad1 on ad1.AssetID=am.AssetID
Inner join sd_servicereq_additionalparams sap2 on sap2.data=ad.AssetValue
Where am.ItemTypeId=20008 and ad.ItemDetailsID=142 and ad1.ItemDetailsID=147 And sap2.FieldID=157 And sap2.ProblemID='772800'),

(Select If(ad1.AssetValue=sap1.Data,'Yes', 'No') from AssetMaster am
Inner Join AssetDetails ad on ad.AssetID=am.AssetID
Inner Join AssetDetails ad1 on ad1.AssetID=am.AssetID
Inner join sd_servicereq_additionalparams sap2 on sap2.data=ad.AssetValue
Where am.ItemTypeId=20009 and ad.ItemDetailsID=163 and ad1.ItemDetailsID=169 And sap2.FieldID=67 And sap2.ProblemID='772800')
) As 'attribute7'
From Sd_ServicereqMaster sm
Inner Join sd_servicereq_additionalparams sap on sap.ProblemID=sm.ProblemID
Inner Join sd_servicereq_additionalparams sap1 on sap1.ProblemID=sm.ProblemID
Where sm.ProblemID='772800' And sap.FieldID=132 And sap1.FieldID=108		 38 38 0   0.00
Find usages Find usages
Powered by JavaMelody