Great now I only need to merge the rows and execute it
Thk Mike
Alain
>There's nothing built into the engine to do what you want but you can still automate the drop and create of the function. SP_HELPTEXT will return the source of the function. Use it to get the source, then drop and recreate the function.
>
>-Mike
>
>>Hi,
>>
>> I have over 50 UDFs in a big cascade, I use them in a custom data transfere(see exemple below), but the probleme is that every time a structure change happen (new columns) we need to recreate these UDF (no code modification).
>>
>>Is there a way to force a schema refresh of all UDF in SQL Server 2000 SP3a?
>>
>>
>>exemple :
>>
>>CREATE FUNCTION [Dbo].[Ana_UdfV_SyncGetQuotation] (@psDirGuID uniqueidentifier)
>>RETURNS TABLE
>>AS
>>RETURN (select A.* from Quotation A
>> inner join Ana_UdfV_SyncGetCompany (@psDirGuID) B
>> on A.ClientGuID = B.GuID)
>>
>>
>>CREATE FUNCTION [Dbo].[Ana_UdfV_SyncGetScenario] (@psDirGuID uniqueidentifier)
>>RETURNS TABLE
>>AS
>>RETURN (select A.* from Scenario A
>> inner join Ana_UdfV_SyncGetQuotation (@psDirGuID) B
>> on A.TrmanGuID = B.GuID)
>>
>>
>>
>>Alain
>>Analystik Inc.