Currentlty working on data types and trying to get query to run faster....its a bit slow

lol...I didnt take ur comment any other way than which is was intended.....my question to u was b/c i was curious to know what other way i should have attacked...

Yes toddasd it is….

Sean Lange how would u have gotten it to move to the next row without a cursor

HEY....IT WORKS...BUT I NEEDED IT TO CYCLE THROUGH MULTIPLE ROWS OF DATA WHICH HAS DIFFERENT SERIAL NUMBERS.....I KINDA FIXED IT.....I KNOW U WOULDNT LIKE THIS BUT I WRAPPED UR...

thanks alot for taking the time to assist me i appreciate it toddasd...i now see that declaring everything as varchar has came back to bite me..it was easy at the...

the data type in the first table is like that as a result of me importing the data from a excel sheet

CREATE TABLE [dbo].[Test_Sales](

[TRAN_DATE] [varchar](50) NULL,

[TRAN_TYPE] [varchar](50) NULL,

[AVERAGE_COST] [varchar](50) NULL,

[PRICE]...

Thank you for ur advise

this is a row of data from the table which contains multiple record query must move to each row and analyze

TRAN. DATE ITEM CODE SERIAL NUMBER...