Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Restoring .bak and .trn files created by an unknown version of Microsoft SQL Server||7||44|
|SQL 2008 - Disappearing Temp Table in Stored Procedure||24||61|
|Backing up Large SQL Server VM Best practice [using Veeam Backup]||8||71|
|SQLCMD question to have fields created as fixed length||2||36|
Join the community of 500,000 technology professionals and ask your questions.