hi,

thanks for your ansewrs,

i need to catch the first status in the

first raw in table

sharon

hi ,

i soory if it wasnot not clear :

but this what i neeed :

find the rows where the status changing form 0 to 1 and...

thank you vary muce for your explanation.

so if i undersatnd there is no diffrent if i put one and only regular index on column

or ...

hi,

yes it was interview question

(bad question for me:)

thank sharon

thank you vary much

you help me alot

sharon

thank you vary much ,

its was what i looking for .

what its starnge for me is how sql now to take each value from acloumn 🙂

this...

hi,

this is alot of data crossing 2 server that far away from each other

i dont want to do backup and restore all the time....

in log shipping the...

thank you

help me very much

hi,

maybe i miss something , but both clolumn hava index mean that cloumn ordered ( sql no need to sort them , thay all ready sort)

all so the select...

first thank you for your reply,

second i run this quary :

select da.userid,us.id from usagc.dbo.data_accounts da

inner join usagc.dbo.data_users as us

on da.userid=us.id

on both cloumn i put an index

second...

thank you its very good

thank you , its work great.

sharon