Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
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
|How to identify differences between 2 backup files?||7||31|
|Do aggregate functions work differently when assigned to a variable?||15||33|
|How can i get data when i use where clause with group by?||3||21|
|Add '#' to end of file||2||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!