I have got a child table as below
JobNo BookingStatusDescription WebSupplierStatusID WebSupplierStatusDescription RevisionNo SupplierID
4363267 Amended 2 Assigned 2 4969
4363267 Confirmed 3 Rejected 1 5202
4363267 Amended 4 Accepted 4 4969
4363267 Amended 5 Error 3 4969
WIth in my T-SQL I want to figure out that if the supplier ID has been changed then raise some sort of Flag of 0 or 1. I don't want to use inline UDF as the data contains hundred of thousands of rows.
How do i achieve this. Please note i am using SQL Server 2014