Catapult, a Quisitive company, is a Microsoft-focused solutions and services firm that specializes in imagining, building and sustaining digital transformation and cloud-based solutions that people love to use. Catapult has consistently been recognized as a leading Microsoft Partner with 10 Advanced Specializations and 17 Microsoft competencies. Recent accolades include 2020 MSUS Partner Award Winner Azure – DevOps, Top Microsoft 365 Security Partner for FY20, and being named a finalist of the Data Analytics 2020 Microsoft Partner of the Year Award. Catapult has offices nationwide.

Webinar: Discover the Power of the Cloud for Government Organizations

Join Microsoft’s Kent Cunningham and Catapult Systems’ Jason Grimm on June 4th at 2PM Eastern for an overview of Microsoft’s newest Cloud for Government offerings along with a demonstration of FUSE, Catapult Systems’ new Intranet as a Service offering. Kent will discuss the new security enhancements and latest features of Microsoft’s Government Cloud solutions. He will also…

SQL – Joining a Table with a Table Value Function Using Column Values as Parameters

In this example, I am attempting to join a SQL Table with a Table-valued Function that accepts column values from the SQL Table as parameters. DECLARE @AllValues INT = –1, @ReportDate DATETIME = ‘4/1/2015’ SELECT    [s].[ServiceId]   , [s].[ServiceName]  , [ro].[AvailableRollover]  , [ro].[RolloverUsed]  , [ro].[RolloverAdded]  , [ro].[RolloverExpired]  , [ro].[RolloverBalance]FROM  [dbo].[Service][s]  , [dbo].[fnRetrieveManagedServicesRolloverTotals](@AllValues, [s].[ServiceId], @ReportDate)[ro] When…