It would help if you could also post the DDL for the table(s), sample data, expected results based on the sample data.

If you need help with this, please read and...

I use CHAR(13) + CHAR(10) when I need to insert a sequence in a string.

To be honest, I don't know how to your questions as there is very little real information in any of your posts. All I know is some scheduled job...

Sorry, tired eyes. I read your post wrong. First, it would help to see the actual error message. Second, it would also help if you would post...

What does the stored procedure return?

A little hard to help you. It would help if you could provide the DDL for the tables, sample data that is representative (made up) of your actual data,...

I have to agree with Seth. there really isn't enough information in your post to really help you. If you could provide your code, DDL for the tables,...

Silverfox (9/11/2009)

---

Do you know what really frustates me at times, is when someone posts after you have posted, and says, yes that is correct or says exactly the same as...

vallolet04 (9/10/2009)

---

I actually modified the function because I had to include extra info this is the final version of the function

ALTER FUNCTION fn_ImporteconDescuentoFinal (@Importe float(8),@Cliente varchar(10))

RETURNS...

Please show...

What database are you in when you run the ALTER DATABASE?

Based on the sample data, I'd drop the = from the >= in the where clause.

I'm not sure about this at all. It has been a while since I was in a database class, but I seem to remember in most of them that...

Not having anything with which to test it, I think this is what Jeff was thinking:

ALTER FUNCTION fn_ImporteconDescuento (@Importe float(8),@Cliente varchar(10))

RETURNS Float(8)

AS

BEGIN

Declare @AuxImporte Float(20);

...

How does the id tie into this? From what I can tell it is nothing more than a row identifier. Am I wrong?