Viewing 15 posts - 16 through 30 (of 50 total)
Thanks for your lighting response
All working now.
Cheers
December 5, 2011 at 6:00 am
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...
December 5, 2011 at 5:48 am
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
...
December 5, 2011 at 5:36 am
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...
December 5, 2011 at 2:11 am
Is this near the IF Update or the From inserted etc.?
December 5, 2011 at 1:47 am
Thanks again.! Sorry so obvious!
December 3, 2011 at 3:27 am
Could any one help me on my last post?
December 2, 2011 at 10:10 am
Yes I had a play. Quite a large file and it was fine in 20 seconds. Good point though
Thanks for your help!
December 2, 2011 at 9:53 am
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...
December 2, 2011 at 9:23 am
Thanks for the pointer. I guess you put in like below.
EXEC UDEF_KD_CompressFile @cmd1, @cmd2
waitfor delay '00:01:00'
December 2, 2011 at 9:11 am
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,
December 2, 2011 at 8:08 am
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...
December 2, 2011 at 6:58 am
Some times I use the design mode which then screws up the layout.
Is there no way apart from reformatting manually then?
December 2, 2011 at 5:27 am
I am using the SQL Management Studio alter script. Note attached image
December 2, 2011 at 5:15 am
Viewing 15 posts - 16 through 30 (of 50 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy