Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
select Ccustno, JobNumber, convert(varchar(10),DueDate,101) as DueDate, MailClass, CASE  when 1 then (Select Convert(varchar(20),MAX([StopTime]),120) as [StopTime] from [JobStepsStartStopTimes] where [Processid] = 0) when 0 then '' END as [PUT ON COMPUTER] from dbo.sales_jobentry where  = 0 and convert(varchar(10),DueDate,101) = convert(varchar(10),getdate() + 1,101) order by Ccustno asc
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!