Tried this and it will work's but only if I run it with out the group by and compute statement CONVERT(NUMERIC(5,2),PO_LINE.QTY*PO_LINE.PRICE) problem is  when I copy this line to the group by list...

SO SO SO SWEAT,

THANKS CAIN

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'BALLOONS'.

Server: Msg...

U don't want to run anti-vir, where your data lies. This is per mcafee, there's a danger in data corruption. I happen to have program files on my server so...

THanks that did !! I keep looking at the first one.

SOUNDS LIKE YOU GUYS ARE HEADED IN THE RIGHT DIRECTION. Looks like this is where the problem lies. heres a sample. of one patient.

SELECT Facility,PatientPrimaryKey,ServiceCode,DateOfService,description

FROM tbl_PerformedProcedure where PatientPrimaryKey...

I started with this and rec. dubs., so I added the distinct and the join in order to get rid of them maybe I am going about it a little wrong? 

select...

Thanks, to be more specific I am trying to get the total sum billed, 1 statment time I get 9.4 mil. when I add two add two col. I get 12.5...

tried that yesterday,didn't work.

I tried again for the hell of it and IT WORKED

SWEEEEET !!!!! I think I left of the 'local'

tryied that to, got it already exists.Then I run @@servername and its 'null'? makes no since

tried that already says it exsists. so I then rerun @@servername and it still says null no makes no since

Thanks that will work.

I am grading a live box and want a backup of db to send to test server before I take down the...

Thanks thats almost it but I need to keep the last four digits '1111. I looking to replace the first four digits only.

41331111 55551111

41331112 55551112

41331113 55551113

dont know...