Thanks for your lighting response

All working now.

Cheers

I am now getting the following message. There is a column name STK_PRIMARY

this is in the STK_STOCK table???

Msg 209, Level 16, State 1, Procedure UDEF_COSTPRICE_UPDATE_DATE_KWD, Line 24

Ambiguous column name...

I am getting the following errors??

Msg 1011, Level 16, State 1, Procedure UDEF_COSTPRICE_UPDATE_DATE_KWD, Line 20

The correlation name 'i' is specified multiple times in a FROM clause.

ALTER TRIGGER [dbo].[UDEF_COSTPRICE_UPDATE_DATE_KWD] ON stk_STOCK

...

Thanks , but I can't seem to get it in the right place. Comments Please!

alter TRIGGER [dbo].[UDEF_COSTPRICE_UPDATE_DATE_KWD]

ON stk_STOCK

for INSERT,UPDATE

AS

IF UPDATE (STK_COSTPRICE)AND...

Is this near the IF Update or the From inserted etc.?

Thanks again.! Sorry so obvious!

Could any one help me on my last post?

Yes I had a play. Quite a large file and it was fine in 20 seconds. Good point though

Thanks for your help!

I have tested this and it works. Thanks very much. I guess that it thinks the exec has finished but like you say it still needs to do...

Thanks for the pointer. I guess you put in like below.

EXEC UDEF_KD_CompressFile @cmd1, @cmd2

waitfor delay '00:01:00'

Thanks for you help guys.

I came up with the following and it works. It was that little int hint! Cheers.

CAST(RIGHT('00000000'+ cast(cast(round(Price,2) *100 AS int)AS varCHAR(9)),9)AS CHAR(9))AS Price,

Thanks for the response. You have put 20.55 as hard test. I am having to do this on the vaules the query returns. Where whould you put the...

Thanks! We will give it a whirl.

Some times I use the design mode which then screws up the layout.

Is there no way apart from reformatting manually then?

I am using the SQL Management Studio alter script. Note attached image