Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.
select PC.ID, MAX(ISNULL(Dr.GenericCode,0)) GenericCode, PC.[Generic Name], PC.[NDC] from PlacedOrderDetails PC Left Join Drug Dr on convert(varchar, Left(PC.NDC ,9),101) = convert(varchar, Left(case when Dr.DrugNDCType = 49 then Dr.DrugNDCNbr else stuff(Dr.DrugNDCNbr,case when Dr.DrugNDCType in (50, 56) then 1 when Dr.DrugNDCType in (51, 57) then 6 when Dr.DrugNDCType = 52 then 10 end, 0, '0') end ,9),101) Group by PC.ID, PC.[Generic Name], PC.[NDC] Order by PC.ID ASC
Join the community of 500,000 technology professionals and ask your questions.