can you please be more specific about what do you need to do?

Hi this is another option you can use to solve your issue; I don’t have a SQL server to test the code I hope it works

SELECT

vcase.case_number AS 'Case',

vcase.style...

Paul,

I'm a little confused why do you need the Budget Year if you have date columns? maybe i didn't understand correctly, but you can use something really simple like.

Select *...

Hi Lynn I just realized that thanks and is working fine I didn't try the cursor idea at the end, because it was taking like a minute and a half...

No problem Marker any thime

check what's on the abc.txt file is probably using the server that is asking you to link

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 Float(8)

AS

BEGIN...

you can try the following code instead

'{%Current Date MM/DD/YYYY%}'

Replace(convert(varchar(10),getdate(),110),'-','/')

for example you will get for today the following format

09/10/2009

I hope it will work for you

Thanks Jeff for the reply, I try your idea but I'm staying with the cursor is almost 30 seconds faster.

I found the solution just in case someone whant's to know i just change the @@Fetch_Status for @@Cursor_Rows and added a counter

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

RETURNS Float(8)

AS

BEGIN

Declare...