Hi All,
In the below example, I want to insert all records. But during insertion C_Is_LumpSum field is taken empty.
I need to avoid empty record in the column C_Is_LumpSum.
Note : This table already having data with the column C_Is_LumpSum having some empty field. Hereafter I want to insert value in the column C_Is_LumpSum.
Ex:
IF EXISTS (select I_Student_ID, I_Batch_ID, C_Is_LumpSum from dbo.T_Student_Batch_Details where C_Is_LumpSum != '')
BEGIN
INSERT INTO dbo.T_Student_Batch_Details (
I_Student_ID,
I_Batch_ID,
I_Status,
Dt_Valid_From,
C_Is_LumpSum
) VALUES (
142586,
5041,
1,
GETDATE(),
'N')
END
Thanks
Karthik