THANK YOU MY FRIEND 🙂 works

I have SQL 2000 with SP2

Yes I have that fixing some erros I will take a look at it...thanks

nope...no erros just invalid user sa

What I'm doing is.

other server creates a TXT file from all records and save it as ex: file name 07300300.15S, so what I need to do is look for that...

Ex: suppose the number found is 15

so I need it understand 15.S

nao, nao e' randon number

the number can be something between 01 and 99

how I do that, how I change that @@ to make sql understand that can be any number...

EX: If I run Select TOP 5000 and process it

How I select the next range of 5000???

it's a file with huge data to be processed daily, I have around 100.000 records and I want to process like 5.000 at time how I do that?

well , it's not working at all, i'm trying this: and it takes too long, don't know any idea???

declare @areadesc char(50)

DECLARE csrSites CURSOR FOR

SELECT area_code FROM billable_temp

select @count=(select count(*)...

thanks alot...it's working

THANK YOU

the @file1 is e:\smdr\03062300.15s

from mromm statement running but said

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'e:'.

Thanks...works

I mean airtime is numeric

I did and everything is fine.

the Airamt is numeric field