On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
Execute upMySprocHistory '11/1/2016', '11/1/2016', '100987','','',''
ALTER PROCEDURE [dbo].[upMySprocHistory] ( @FieldDateFrom Varchar(50) = '', @FieldDateTo Varchar(50) = '', @FieldCustNo numeric(6,0) = '', @FieldGroupCode Varchar(50) = '', @FieldQtyMin Varchar(50) = '', @FieldQtyMax Varchar(50) = '' ) AS SELECT * FROM viewHistoricalData v WHERE ((@FieldDateFrom = '') Or (v.DateCreated)>= @FieldDateFrom) AND ((@FieldDateTo = '') Or (v.DateCreated)<= @FieldDateTo) AND ((@FieldCustNo = '') Or Convert(numeric(6,0),(v.CustNo))= @FieldCustNo) AND ((@FieldGroupCode = '') Or (v.GroupCode)= @FieldGroupCode) AND ((@FieldQtyMin = '') Or (v.Quantity)>= @FieldQtyMin) AND ((@FieldQtyMax = '') Or (v.Quantity)<= @FieldQtyMax)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.