With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Select Left(afsSource,2) as busType, SubString(afsSource,4,4) as DealID, Sum(afsAMount) as afsAmount from proc_cfa.dbo.P_AvailableForSale where afsTransAction = @OrdTranID group by Left(afsSource,2), SubString(afsSource,4,4) Select DealID ,CASE WHEN COUNT(PmtFrequency) > 1 THEN 'Split' ELSE MIN(PmtFrequency) END cp ,MAX(loanDate) LoanDate from proc_lt.dbo.P_PaymentStreams Group by DealID order by DealID
|Linking a DMV to a database id/sql text in SQL server 2008||8||46|
|Does SharePoint 2016 using SQL 2016 function correctly with Workflow Manager?||2||17|
|SQL Field Length for Email Address||3||16|
|MS SQL Pivot table help||4||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!