ALTER PROC [dbo].[InsertPatientTestEntry]
@ID UNIQUEIDENTIFIER
,@MedicalTest_ID UNIQUEIDENTIFIER
,@AssignedTest_ID UNIQUEIDENTIFIER
,@Exp1 VARCHAR(MAX)
,@CreatedBy VARCHAR(50)
,@UpdatedBy VARCHAR(50)
,@PatientID UNIQUEIDENTIFIER
AS
BEGIN TRANSACTION
BEGIN TRY
DECLARE @xmlfile XML=CONVERT(XML, N''+@Exp1+'')
IF EXISTS (SELECT 1 FROM dbo.PatientTestEntry AS PTE WHERE AssignedTest_ID = @assignedtest_id AND convert(date,CreatedDate,101) = Convert(date,getdate(),101))
begin
select 'Update table with Xml here'
end
INSERT INTO [PatientTestEntry]
([ID],[MedicalTest_ID],[AssignedTest_ID],[Exp1],[CreatedBy],[CreatedDate],[UpdatedBy],[UpdatedDate],[PatientID])
VALUES(@ID,@MedicalTest_ID,@AssignedTest_ID,@xmlfile,@CreatedBy,dbo.GetCurrentDate(),@UpdatedBy,dbo.GetCurrentDate(),@PatientID)
;WITH XMLCol(XMLStr)
AS
(
SELECT * FROM
( ...
Go to the complete details ...