E.g, dbo.ProcessStatus
How to use this function in query?
SELECTProcessID,[dbo].[udf_CalcBCLifeCycle_PastdueRating](BIAScheduledCalculation,BIACaptureCalculation,BIASignoffCalculation) AS PastDueFROM BCLIfeCycleWHERE BCLifecycle.Isdeleted = 0
Output
Thursday, December 9, 2010
Sample SQL Scalar Function and it Use
The below function is created to calculate the count of a column whose status is 'Past Due'.
E.g, dbo.ProcessStatus
How to use this function in query?
SELECTProcessID,[dbo].[udf_CalcBCLifeCycle_PastdueRating](BIAScheduledCalculation,BIACaptureCalculation,BIASignoffCalculation) AS PastDueFROM BCLIfeCycleWHERE BCLifecycle.Isdeleted = 0
Output
E.g, dbo.ProcessStatus
How to use this function in query?
SELECTProcessID,[dbo].[udf_CalcBCLifeCycle_PastdueRating](BIAScheduledCalculation,BIACaptureCalculation,BIASignoffCalculation) AS PastDueFROM BCLIfeCycleWHERE BCLifecycle.Isdeleted = 0
Output
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment