Task Blank ToUserId Updation
by 79 {PCategory}
select * from ATasksL where ToUserId is null
--delete from ATasksL where TaskId=0
select * from ATasks where taskid=45
UPDATE ATasksL
SET ATasksL.ToUserId = CAST(CASE WHEN CHARINDEX(',', ATasks.Allocatedto) > 0 THEN SUBSTRING(ATasks.AllocatedTo, 1, CHARINDEX(',', ATasks.Allocatedto) - 1) ELSE AllocatedTo END AS bigint)
FROM ATasksL
INNER JOIN ATasks ON ATasksL.TaskId = ATasks.TaskId
WHERE AtasksL.ToUserId IS NULL
SELECT CASE WHEN CHARINDEX(',', ATasks.Allocatedto) > 0 THEN SUBSTRING(ATasks.AllocatedTo, 1, CHARINDEX(',', ATasks.Allocatedto) - 1) ELSE AllocatedTo END AS Allocated, AllocatedTo AS Allocated1, * FROM ATasksL
INNER JOIN ATasks ON ATasksL.TaskId = ATasks.TaskId
WHERE AtasksL.ToUserId IS NULL
{PCategory}