But that way I will not get null values in join column of other table

Thanks all, the problem was client table had multiple rows with with same client_panno that's a logical error.We are not supposed to have it that way.

But I want something like this where only null values are returned

select cc.cc_clientcode,cc.cc_rmcode,cc.cc_panno,cc.cc_productname

,c.Client_panno,c.client_userid

--,u.user_userid

from clientcode cc LEFT outer join client c

on cc.cc_panno=c.client_panno order by cc_clientcode

where c.client_panno is null

I am using Cusror because I am using SSIS package to insert records into the table.Since the SSIS uses bulk insert I can cannot validate individual record .So the cursor...

I know off course its a bad design. But there are some issues because,these tables are part of an Enterprise SW, its actually CRM and because of this and other...

The person who created the tables had made the createdby and modifiedby ad datetime so that was the problem.

However I ak u guys for help if i still have other...

I can guarantee that only one record is inserted at a time because its a enterprise software which I am customizing, since it generates client_clientid by itself i can be...

The problem was that the trigger was for insert only , after adding update its working.

However let me tell you that. This is for one record at a time ,its...

Thanks for the reply I might use that method in fact I have been told before to use the method you have advised,but I just want to know what is...

where and why do i require the where clause. The cursor has

For Select client_activeid from client Order By client_activeid

Open curclientRefId

Fetch Last...

See the Id should actually be check digit number. I still have to write code for that, I am testing this code because i need to use this format in...

See this is just a part of the whole requirement I am just splitting it in parts and testing it. I will have field called type so based on the...

To test that whether it is expecting only one row I uploaded only one row from excel nut even then it did not work..

First of all really sorry for the late reply.

Thanks for the code but the code is not right in our context.

Let me clear few thing here

1.ClientCode is an empty...

Also the excel sheet is getting uploaded properly without any error, so only the trigger is not getting executed,