USP_INSTALLEDPRODUCTS_VALIDHASH2

create procedure [dbo].[USP_INSTALLEDPRODUCTS_VALIDHASH2]
@VALIDHASH bit output
with execute as owner
as

declare @INSTALLATIONNAME nvarchar(100);

declare @SERIALNUMBER nvarchar(50);

declare @INSTALLEDPRODUCTS nvarchar(30);

declare @INSTALLEDPRODUCTLIST nvarchar(max);


select 
@INSTALLATIONNAME= INSTALLATIONNAME, 
@SERIALNUMBER=SERIALNUMBER ,
@INSTALLEDPRODUCTS= INSTALLEDPRODUCTS 
from dbo.INSTALLATIONINFO with (nolock) where [ID] = 1;

if LEN(@INSTALLATIONNAME)>0 and LEN(@SERIALNUMBER) > 0
    BEGIN

        select @INSTALLEDPRODUCTLIST=COALESCE(dbo.UFN_INSTALLEDPRODUCTS_GETPRODUCTLISTFORHASH(),'');
        select @VALIDHASH=dbo.UFN_INSTALLEDPRODUCTS_ISINSTALLEDPRODUCTSHASHVALID(@INSTALLATIONNAME, @SERIALNUMBER, @INSTALLEDPRODUCTS, @INSTALLEDPRODUCTLIST);

        return 0;    
    END
else
    BEGIN
        set @VALIDHASH=0;
        return 0;
    END