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...

i want all records from #t

which are overlaping with entered @pointfrom = 2 and @pointTo = 10

--requirement is "f" can > or = to previous "range's "t" or...

where ever @pointfrom and @pointTo is overlaping with records ,considering the given critaria should come.

--requirement is pointfrom can > or = to previous "range's pointto" or pointto can be < or = to next range's pointfrom

--@Pointfrom and @pointto is passed in query as param.

--where...

is the second one correct or not.

i have to find out where it is overlapping in second case.

Pointfrom and pointto is passed in query as param.

where point from is...

can i save tempdb space by using cursor or it will also make worktable in tempdb?

yours sincerely