ALTER VIEW [dbo].[vwClient_CompanyPerson] WITH SCHEMABINDING AS SELECT A.CompanyID*1000+B.PersonID AS CompanyPersonID, A.CompanyID, B.PersonID FROM dbo.tblCompany AS A INNER JOIN dbo.tblPerson AS B ON B.CompanyID=A.CompanyID
ALTER VIEW [dbo].[vwClient_CompanyPerson] WITH SCHEMABINDING AS SELECT A.CompanyID*1000+B.PersonID AS CompanyPersonID, A.CompanyID, B.PersonID FROM dbo.tblCompany AS A INNER JOIN dbo.tblPerson AS B ON B.CompanyID=A.CompanyID
select * from vwClient_CompanyPerson where CompanyPersonID is not null
ALTER VIEW [dbo].[vwClient_CompanyPerson] WITH SCHEMABINDING AS SELECT isnull(A.CompanyID*1000,0)+isnull(B.PersonID,0) AS CompanyPersonID, A.CompanyID, B.PersonID FROM dbo.tblCompany AS A INNER JOIN dbo.tblPerson AS B ON B.CompanyID=A.CompanyID