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…

Taking a break

I will be taking a break from all things IT related for a little while. I do plan on returning to my blogs, so be prepared for some interesting new content in the near future (maybe I’ll finish some of the 170+ draft blog posts which I’ve accrued over the last couple of years!). As…

Microsoft partner of the year icon

Unable to find LiteTouch.wsf

  Not long ago I was using MDT 2013 to develop a few images.  Deploying from the server, whether booting from PXE, CD/DVD, or a USB drive worked fine.  However, when I created a stand-alone ISO and extracted it to a bootable USB Hard Drive, the image deployment failed with the following error: Script not…