Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
select CASE WHEN @groupBy = 1 THEN 'Salesperson: ' WHEN @groupBy = 2 THEN 'Third Party Salesperson: ' END + ISNULL(gb.Name1 + ' (' + gb.Code + ')', '(none)') as GroupByName, SubmittedByName, CurrentMonth from @loanInfoTotals t left join Entity gb on (@groupBy = 0 and 1 = 2) or (@groupBy = 1 and gb.PartyId = t.SalespersonId) or (@groupBy = 2 and gb.PartyId = t.ThirdPartySalespersonId)
|check the deletion of SQL job on who delete/disable it||12||29|
|Updating a table from a temp table||4||29|
|What logic to build in order to get a weekly reminder||9||41|
|Need a SQL Server 2014 plug-in to scan the DB schema||4||16|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!