Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
with p as ( select TR.[Generic Code], TR.NDC, TR.[Drug Name], Sum(cast(TR.[Qty] as int)) as Qty from vw_Test3 TR Group By TR.[Generic Code], TR.NDC,TR.[Drug Name] ) select x.[Generic Code], x.NDC, x.[Drug Name], y.Qty from ( select p.*, row_number() over (partition by [Generic Code] order by Qty desc) rn from p ) x left join ( select [Generic Code], sum(cast(Qty as int)) Qty from p group by [Generic Code] ) y on x.[Generic Code]=y.[Generic Code] where rn=1;
|execute a MS SQL script as a schedule SQL job||72||97|
|How to place a condition in a filter criteria in t-sql?||12||31|
|using t-sql EXISTS||8||23|
|Auditing in Azure SQL Database||3||28|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!