I found the mistake it was the wrong table name ,but this is giving me the rownumber as 1 and showing 1 record .

How do I get the actual row...

Thanks for your reply.

I tried this.

I have a temp table which contains the data.

select ROW_NUMBER() OVER (ORDER BY id)as RowNumber,*

From #TempSearch

...

Thanks for the reply

What if i replace Null with 0

with function ISNULL() as 0 is not a value that will be present in my table for cID.

After this will not...

I will have to check in the stored procedure for each description parameter is null or not and if not null I will insert row in Table A

like

if(description 1 is...

Thanks for your reply

I am using sqlserver 2005 and is this feature also available there..I am not aware of this feature.It woule be of help if you could explain

Thanks for the reply.

Then If user selected only 3 param,I will pass only three and I do not need to pass the rest as they are null by default.Is that...

There are 13 choices available out of which user can select may be 1 or 2 or 3 or may be all 13.

So the description parameters will depend on what...

I dont think there is any problem in the logic because there is a similar job which exceutes fine .The one i mentioned in my previous post is the example...

no my objective is just to select the records ,it doesnt matter whether the record is updated one or not.

Job A

insert into A

update A

In my job B which does...

Thanks for the reply.

My job A does some insert and updates on Table A

Job B select data from table A at the same time.

There are no records for select as...

Thanks for the reply.It helped me

Thanks for the help.

I have understood .

Thanks

Thanks for the reply.

If you count from january 17 to feb 7 .the total no of days is 22.

Plesae let me know if i am wrong.

Thanks

Thanks for your reply.

This is the full query.The table description is as follows

In table A ,the columns are

id,sequence,name,address....

For one id there are multiple sequences.

Table R

id,sequence,startdate,enddate....

Table also has...

Thanks for your reply.

I am a begineer .

I tried to check the actual execution plan.

There is an index seek on Table A which having cost as 37%.There are other parameters...