spUpdateDataFromBO

            CREATE PROCEDURE [dbo].[spUpdateDataFromBO]
            (
                @InstalledCountry int,
                @SuburbDataType int
            )
            AS
                DECLARE @ic int

                BEGIN TRAN

                SELECT top 1 @ic = [RECountryMask] FROM [dbo].[Clients]

                IF @ic <> power(2, @InstalledCountry)
                    UPDATE [dbo].[clients] SET [RECountryMask] = power(2, @InstalledCountry)

                UPDATE
                    [dbo].[ApplicationFields]
                SET
                    [DataType] = @SuburbDataType
                WHERE
                    [FieldID] IN (115,118)

                DECLARE @PrivateShowByDefault bit

                -- UK = 1
                IF @InstalledCountry IN (1)
                    SET @PrivateShowByDefault = 0
                ELSE
                    SET @PrivateShowByDefault = 1

                UPDATE
                    [dbo].[ApplicationFields]
                SET
                    [PrivateShowByDefault] = @PrivateShowByDefault
                WHERE
                    [PrivateShowByDefault] IS NULL

                COMMIT TRAN