USE [AutomationSandboxDB]
GO

/****** Object:  UserDefinedFunction [dbo].[StringFormat_3]    Script Date: 3/5/2020 7:49:18 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Michael J. Horvath
-- Create date: 03/04/2020
-- Description:	This function will format a string similar to the string.Format() function in C#.
--              The only difference is that its placeholders for fields are positionally identified and
--              use the syntax {?} for each field to be replaced with parameters.  The parameters are
--              also in a string delimited by commas eg. 'parameter1,parameter2,parameter3'.
--
--              The format specifier string also allows carriage return line feed with \n, tab with \t and
--              should you want to include in the result string the delimiter value without replacing it with
--              a parameter from the parameter list string escape it with \{?}.
--
--              Updated 03/05/2020 to use optional parameters for the parameter list to make a more natural appearing
--              list of parameters.  Now this is what a call to the function looks like: SELECT dbo.StringFormat('One: {?}\nTwo: {?}',@One,@Two)
-- =============================================
CREATE FUNCTION [dbo].[StringFormat_3]
(
	-- Add the parameters for the function here
	@FormatSpecifierString varchar(max),
	@Parameter0 sql_variant = NULL,
	@Parameter1 sql_variant = NULL,
	@Parameter2 sql_variant = NULL
)
RETURNS varchar(max)
AS
BEGIN
	-- Return the result of the function
	RETURN dbo.StringFormat(@FormatSpecifierString,@Parameter0,@Parameter1,@Parameter2,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT);
END












GO