Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
USE [BGISReports] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_rptCompleted] @FromDate DATETIME, @ToDate DATETIME AS BEGIN SELECT DISTINCT [02_MPAN] AS [MPAN], [01_Jobcode] AS [Job Reference], [19_JobType] AS [JobType], UPDATE rptAllData SET [19_JobType] = 'Completed' FROM rptAllData END
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
25 Experts available now in Live!