I have a table called Employeestbl
I would like to perform an update to a field of this table to all records that a UDF called EmployeesMissingDocs returns '1'.
Now my main issue is that this UDF expects values as parameters from different tables.
See example below
FUNCTION [dbo].[EmployeesMissingDocs] (
@Title varchar(50) = null,
@LicenseNumSignedYN bit = null,
@LicenseExpires DATETIME= null,
@BclsExpires DATETIME= null
) RETURNS VARCHAR(2000)
Where EmployeeID and Title come from Employeestbl, License info come from a second table and Bcls from a third one..
How can I perform this in a single update statement?