Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
works fine. But instead of the sub query shouldn't it be an inner join? I just can not seem to get my head around something so simple this morning... :-(
DELETE FROM Administration.dbo.CUST_CNTCT_TRKNG WHERE EXISTS(select * from Michaels.dbo.VI_PS_DOC_LIN where Administration.dbo.CUST_CNTCT_TRKNG.DOC_ID = Michaels.dbo.VI_PS_DOC_LIN.DOC_ID AND ((LIN_TYP = 'P'AND COALESCE(PO_RECV_STAT,'*')<>'F') OR (SUBCAT_COD <> 'LABOR' AND LIN_TYP = 'O' AND REF <> 'PICKED')))
|SQL Select Distinct on one column--but as it applies to each patient in the select statemtn||4||38|
|Upgrading Integration Services||3||28|
|Solution for warm standby SQL server||20||40|
|Is there a way using SQL Server 2008 to display a varchar(10) value as Month Name followed by year [08/03/2017 -> August 2017] if the value is stored in format MM/DD/YYYY ?||1||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!