yes..it was run 15 days back only ( in both server).

Some more points...

I have tested the indexes and statistics...there is no difference between both servers and number of rows are almost same between the two server.

I have posted it twice. How should i delete it ?

I clicked 'DELETE' button. but i am unable to delete it.

oops...i said blindly SQL sorts the data automatically... I have phrased my words wrongly...

YES..UNION will sort the the data by using internal workt table.

but the sorting order looks different...Thats...

Thanks for quick reply....

actually i got this error messag while running a job..since it was very urgent my manager sit near to me...he even not give some time to look...

Garadin,

i have tested your code...

original output:

aaazzzz

bbb

zzz

ccc

b

a

bb

i got the below result set...

bbb

zzz

ccc

bb

it didn't show

aaazzzz.

yes...it should work..

because it should use the ascii value..so ascii value for b is always greater than ascii value of a...so it will show the first part...

but in my case....

what...

Basically

where name > ''

should avoid balnk string values. Am i right ? how it will check the datapages internally? thats what i wanted to know...

yes...i have tried your code...

the result is like as below

#1:

Jonny

kamatchi

karthik

kuhan

ravi

#2:

kuhan

ravi

but if i don't have index...or if we dont have ordered result set....what will happen? it leads to wrong result set....

ok.

but if we have unordered data...what will happen ?

you sample data has ordered, so we no need to worry about the result...

i think we can use ORDERBY clause...but again if...

Chris,

I have tested your scenario.

create table #t1

(

name varchar(15)

)

go

insert into #t1

select 'karthik'

union

select 'kuhan'

union

select 'kamatchi'

union

select 'Guna'

union

select 'ravi'

query:

select * from #t1

where name > 'karthik'

output:

ravi

kuhan

why it is not showing the remaining...

Any more inputs ?

Any inputs ?

This new field should be used in the where clause as a filter.

Say for example,

TableName: Emp

Columns:

Eno int

DOB...

If you want to know more about 'TALLY' table, i know your answer would be 'YES'. so read the below article....

http://www.sqlservercentral.com/articles/TSQL/62867/