SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[StepTwo_DBupdates]
(
@RQID int=null,
@RDID int=null,
@TAT int = null)
AS
UPDATE    REPORTSELECTION
SET        tat = @TAT,
	   Resource = COALESCE(NULLIF(Resource,NULL),(Select RI.resource from ReportInfo RI WHERE (reqid = @RQID) AND (rdesc = @RDID) )

quote:

---

Originally posted by visakh16

you've not specified any relationship between the tables REPORTSELECTION and ReportInfo. how are they related?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[StepTwo_DBupdates]
(
@RQID int=null,
@RDID int=null,
@TAT int = null)
AS
UPDATE    rs
SET        rs.tat = @TAT,
	   rs.Resource = COALESCE(RI.Resource,rs.Resource)
FROM REPORTSELECTION rs
INNER JOIN ReportInfo RI 
ON RI.namedrdesc = rs.namedrdesc
WHERE (reqid = @RQID) 
AND (rdesc = @RDID) 

quote:

---

Originally posted by jim_jim

For some reasons this is not working.We dont need to have a join between these two tables in this case.We just want to insert/update the resource feild value in REPORTSELECTION table with a value in resource feild in ReportInfo Table.

I tried with the above and getting undesired results

---