Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Question

ERROR:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

SELECT@Scheduled=(SELECT T.SCHEDULEDTIME FROM #TEMP_SB_ZEROSPLIT T WHERE T.SCHEDULEDTIME=(SELECT MAX(ISNULL(T.SCHEDULEDTIME,0))FROM #TEMP_SB_ZEROSPLIT T WHERE T.SPLIT_BOOK_ID=@BOOK_ID));
SELECT @Signeddate=(SELECT T.SIGNING_DATE FROM #TEMP_SB_ZEROSPLIT T WHERE T.SIGNING_DATE = (SELECT MAX(T.SIGNING_DATE ) FROM #TEMP_SB_ZEROSPLIT T WHERE T.SPLIT_BOOK_ID=@BOOK_ID));