Thank you, Will try using the function instead of SP but to clarify the

has its own custom logic to arrive the result.

we need to get the date from the sp and just set the date to all the records in TABLE 1 matching records

The SP contains more than 500 lines of code and specific logic like manipulation of data from more than 3 tables etc...

so we cannot move the logic completely to case...

Below is sample what I am looking for

create table TABLE1

(

IDVAL INT,

TEST DATETIME,

CHANNEL INT

)

create table TABLE2

(

IDVAL INT,

CHANNEL INT

)

INSERT INTO TABLE1 VALUES('1',GETDATE(),2)

INSERT INTO TABLE1 VALUES('2',GETDATE(),2)

INSERT INTO TABLE1 VALUES('3',GETDATE(),2)

INSERT INTO TABLE2 VALUES('1',2)

INSERT...

Thanks for the reply, my current problem looks some thing like below

I need to update all the records in a table based on specific contion like below psudecode

declare