... start with a function that just converts a string of words delimited by spaces to a table:
CREATE FUNCTION dbo.[ufn_StringToTable]
(
@StringInput VARCHAR(MAX)
)
RETURNS @OutputTable TABL ...
... IS NOT NULL
DROP VIEW [Common].[uvw_MyView];
GO
-- drop a function if it exists
IF OBJECT_ID ( '[Common].[ufn_MyFunction]', 'FN' ) IS NOT NULL
DROP FUNCTION [Common].[ufn_MyFunction];
GO
- ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.