--All the marbles should be in order, Relating to the new attached glues.

1)ok, that means both queries are correct any one can be used?

2) i have chainged the join a.aid=i.aid

select a.aid, isnull(i.spoint ,j.spoint)

from #a a

left join #i i on a.Aid...

my question was some thing else , that is with out N it is working.

now u have written N which is also good , but i am trying to understand...

hi,

thank u,

i know about capital N , but i wanted to understand , if i have not used any char of Unicode in my xml, then why

capital...

yes i think this was the reason

well some body said DBCC UPDATEUSAGE (0); is also needed, is it correct?

i known begin tran and try cache , what i am asking is, which stmt might be the reason of generating this error.

your sincerley

thank u , but my query was , will try cache block any thing?

yours sincerley

i thought like transaction blocks , so it will also block

yours sincerely

no body is answering.

one more question

Q1 "set xact_abort no" should be the first stmt or set isolation level

that means

should i use like so.

set xact_abort no

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

or

SET...

yes , multiple user can have different col name.

q2) is not answered. will it do any good by removing or deleting.

pls answer

it is was not duplicate , i have overwritten the old one, becasue old one had got syntex error ( while typing)

so please consider the question. is the query ...

I have been using union at appropriate places, but i wanted to understand this one.

yours sincerely

hi,

if OBJECT_ID('dbo.act','u') is not null

drop table act

create table act(actid int,actname varchar(50),reportno varchar(50))

insert into act values(1,'whitewash','r1')

insert into act...