Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.
SELECT r.NPT_PRICEx, r.NDC, r.NPT_DATEC FROM dbo.RNP2 r INNER JOIN (SELECT MAX(npt_datec) AS maxbbdc, NDC FROM rnp2 GROUP BY NDC) a ON r.NDC = a.NDC AND r.NPT_DATEC = a.maxbbdc WHERE (r.NPT_TYPE = '01') SELECT TOP 100 PERCENT r.ndc, r.ln, r.bbdc FROM dbo.RNDC14 r INNER JOIN (SELECT ln, MAX(bbdc) maxbbdc FROM RNDC14 GROUP BY ln) a ON r.ln = a.ln AND r.bbdc = a.maxbbdc WHERE (r.cl = 'f') AND (r.gni = '1') ORDER BY r.ln
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQl Query to find x consecutive Nbrs in a Table||30||104|
|How to create XML in below format from SQL Query in SQL Server?||3||53|
|removing unwanted rows from an sql server ranked table||13||39|
Join the community of 500,000 technology professionals and ask your questions.