Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
USE [PCAR_Data] GO /****** Object: UserDefinedFunction [dbo].[ufn_lastPaperStatementBefore] Script Date: 10/03/2016 09:37:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[ufn_lastPaperStatementBefore] ( @AccountID BIGINT, @dateParam DATE ) RETURNS DATE BEGIN DECLARE @firstStatement DATE SET @firstStatement = ( select coalesce(max(cast(statement.exportdate as date)),'1950-01-01') from statement with (NOLOCK) where accountid = @AccountID and cast(statement.exportdate as date) < @dateParam and statementtype = 's' and voided is null ) RETURN (@firstStatement) END
|SSRS - Date Report Options||2||29|
|Stored Proc - Rewrite||42||60|
|SQL Server Configuration Manager WMI Error||11||20|
|What capabilities or configuration are required to run the following code to get the IP from the database server?||5||52|