I am getting parse error -

Incorrect syntax near ')'.

and also the columns SELECT E.col1, E.Col2,

It got worked, TY

Quick question -  Do I need to keep this If condtion inside the procedure or do I need to keep it after calling this procedure...

I got t But ho I can assign entire Insert script to @Count  variable ? so it returns as out.

Alter proceudre dbo.validate

@Count...

dbo.Sudent Schema
ID
EMployeeCd
EmpNum

Insert into dbo.Student values
(1, 1245678334,001)
(2,678345678,002)

dboEmployee Scehma

ID
EMployeeCd
EmpNum

Insert into dbo.Employee values
(1, NULL,NULL)
(2,NULL,NULL)

based...

TY,Answered

all these 3 tables has relation on ID column; dates are used for validation purpose

Yeah,Yes.
It will check for If exists if there is no record it will not go inside right?
I changed the code like below - The issue is after...

I understand, With this code that you mention I am not able to get any record into insertion part

ALTER PROCEDURE CATOI (
...

The logic which i did is correct?

ALTER PROCEDURE [dbo].[ICATOU]
@ID nvarchar(40)

AS
BEGIN
SET NOCOUNT ON

IF EXISTS(SELECT 1 FROM dbo.Emp WHERE ID=@ID)
BEGIN
    BEGIN TRY
   ...

no that it not situation.@col1 parameter is unique, If the record already exists it will delete and again inserted.
This proc is calling form another proc where it has...

TY, quick question suppose if i am using two If exists blocks here can i keep it in same try catch block ?

Alter procedure CATOI
@col1 nvarchar(10)
AS

Right now the data is showing as

--00000000
--02005523

So with the patindex is there a way to remove only the first 0 from the data which...

But we are not ready using Merge statement..

In the same way can I use delte from exception and again inserting into std exception table what we are doing...

No , My logic is different, I understand his example -
But i have taken that join query outside of the cursor - there is a purpose to take that...

I have a question on this Cnt.
This query I make it as outer cursor query
SELECT DNum,LNum,Cd,count([EMployeeUI])