UP | generate dynamically url
UP | generate dynamically url

#119522439

to test on "serveur2008" run script :
UPDATE i
SET [TIns_ApplicationPath] =  '@@hostname@@'+
SUBSTRING(REPLACE([TIns_ApplicationPath],'http://',''),
CHARINDEX('/',REPLACE([TIns_ApplicationPath],'http://','')),
LEN(REPLACE([TIns_ApplicationPath],'http://','')))
FROM  [SECURITE].[dbo].[TInstance] i
WHERE [TIns_ApplicationPath] NOT like '%google%' and
[TIns_ApplicationPath] like '%http%'  and  (TIns_FK_TSitID = 5)

NaturalSolutions/NsPortal,NaturalSolutions/NsPortal,NaturalSolutions/NsPortal