CREATE FUNCTION CN.Sample (@format nvarchar(100),  @oldText nvarchar(max))
RETURNS @Results TABLE (newtext nvarchar(max))
AS
BEGIN
   DECLARE @WebServiceURL nvarchar(256);
   DECLARE @pUrl nvarchar(256);
   DECLARE @pFP nvarchar(256) = NULL;
   DECLARE @enableMC bit = 'true';
   DECLARE @allowShort bit = 'false';
   DECLARE @identity nvarchar(100);
   DECLARE @allowRNG bit = 'false';
   DECLARE @UserName nvarchar(100) = '';
   DECLARE @Password nvarchar(100) = '';
   DECLARE @FileCache nvarchar(256) = '';
   DECLARE @Status varchar(10);

   SELECT  @WebServiceURL = WebServiceURL,
           @pUrl = PURL,
           @identity = IdentityName ,
           @UserName = UserName,
           @Password = [Password],
           @FileCache = FileCache
   FROM [CN].[VCC]
   WHERE FormatName = @format;

   INSERT INTO @Results(newtext)
   SELECT data
   FROM dbo.CLRSample (@WebServiceURL,@UserName,@Password,@format,@oldText);
   RETURN;

END

GO

select d.*
from dbo.EE
cross apply CN.Sample ('asdf',  EE.text) d

CREATE FUNCTION [dbo].[CLRSample](@serviceURL [nvarchar](256),@userName nvarchar(100), @Password nvarchar(100),@format [nvarchar](100),@oldText nvarchar(max))
RETURNS TABLE (data nvarchar(500) )
AS
EXTERNAL NAME [Sample.SqlClr].[SQLCLR.SampleFunctions].[Sample];
GO