blacktambourine · November 21, 2017 01:55
diff --git a/SC_GetSharedFieldValue.sql b/SC_GetSharedFieldValue.sql
 CREATE FUNCTION [dbo].[SC_GetSharedFieldValue] 
 (
 @ItemID [uniqueidentifier],
 @FieldID  [uniqueidentifier]
 )
 RETURNS nvarchar(max)
 AS
 BEGIN
 DECLARE @Result  nvarchar(max)
 SELECT @Result = value 
  FROM [dbo].[sharedFields]
  where ItemId=@ItemID
  and fieldid=@FieldID
 RETURN @Result
 END
 GO
	CREATE FUNCTION [dbo].[SC_GetSharedFieldValue]
	(
	@ItemID [uniqueidentifier],
	@FieldID [uniqueidentifier]
	)
	RETURNS nvarchar(max)
	AS
	BEGIN
	DECLARE @Result nvarchar(max)
	SELECT @Result = value
	FROM [dbo].[sharedFields]
	where ItemId=@ItemID
	and fieldid=@FieldID
	RETURN @Result
	END
	GO