Another friend in SQL is the CAST function. Assume you need to join 2 tables on columns that have different data types, and the types are not compatible. Use the CAST function in your join statement:
SELECT EADP_AppDB.dbo.D_Resource.MemberId AS ResourceMemberID, dbo.vEADP_VistaReadyTransposed.ResourceID,
dbo.vEADP_VistaReadyTransposed.KPIName, dbo.vEADP_VistaReadyTransposed.KPI, dbo.vEADP_VistaReadyTransposed.KPIMemberID
FROM EADP_AppDB.dbo.D_Resource INNER JOIN
dbo.vEADP_VistaReadyTransposed ON EADP_AppDB.dbo.D_Resource.Label = CAST(dbo.vEADP_VistaReadyTransposed.ResourceID AS nvarchar)