Everything you need to know about backup and disaster recovery with AWS, for FREE!
Select @SQL = @SQL + '' + @dropdownlist + ' = ''' + @control + ''' and CMOPID in (' + @CMOPIDs + ') Order by CMOPID, ProductCode'
SELECT DISTINCT fm.[Cmopid] ,fm.[OnHandStock] ,fm.[ProductCode] ,fm.[DispensingPackSize] ,vp.HostDescription ,fm.[ProductEnabled] FROM [vhacmncdb].[CDB].[dbo].[FormularyMaster] fm with (nolock) join [vhacmncdb].[CDB].[info].[va_productlist] vp with (NOLOCK) on fm.productcode = vp.productcode where fm.productcode like '%'+@control+'%' and CMOPID in (@CMOPIDs)
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.