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

Hi Karthik

I used cursor to solve u r problem.
Cursor use to manipulate data on row by row basis.

I think following will help you

declare @Scheduled datetime
declare @Signeddate datetime
DECLARE Schedule_Signing_Cursor CURSOR FOR
-------------------------------------- This code will fetch values one by one ---------------------------
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)
union
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)
----------------------------------------------------------------------------------------------------------
OPEN VOID_ACCT_cursor
FETCH NEXT FROM Schedule_Signing_Cursor
INTO  @Scheduled,@Signeddate
WHILE @@FETCH_STATUS = 0
BEGIN

----------------- Picked value from above code will put one by one in following code for manipulation ------------------
If @Scheduled IS NOT NULL OR @Scheduled<=@Expiration
  BEGIN
  SET @TextMarketing='ACTIVE';
  SET @Expiration=(DATEADD(DAY,-1,(DATEADD(YEAR,1,@Signeddate))))
  END
  else
  BEGIN
  SET @TextMarketing='INACTIVE';
  SET @Expiration=NULL;
  END
  UPDATE  #TEMP_SB_ZEROSPLIT SET