How do I do?

Hi,

This was the expected result, the problem is that when I put this in a stored procedure gives the following error:

Can not drop the table '#tmp_datesforMonthAM', because it does not...

Hi,

The stored procedure below will select price changes due for example to a promotion, through the function.

The stored procedure works only if only for a record, whenever I run spPriceH...

I have a table with the following product sku fields, price and discount, and wanted to create a historical table of the products that whenever alter prices or discount reflects...

Hi,

I want the stored procedure receives a loop in the query

Thanks

Not what I want.

I can not use defalut values??, because my function can not be "in"

In the "Available Values" menu have 2 parameters

then my idea is eg...

Many thanks David for help was this really the expected result

well where I get this error, but do not know how to solve.

I have the following expression

=(IIF(Fields!Estado.Value = "IVA", -CDbl(Fields!TotalFinal.Value),CDbl(Fields!TotalFinal.Value))) and (IIF(Fields!Estado.Value = "DEL", CDbl(0),CDbl(Fields!TotalFinal.Value)))

to join the two with...

Let's start from the beginning, to see if I explain myself better.

I initially wanted everything that was put DEL 0, now I want to put col2

only with your...

col1 col2 col3

test1 10 OK

test1 60 DEL

test2 5 OK

obtained result

col1 col2 col3

test1 10 OK

test1 2 DEL

test2 5 OK

result we wanted to get

col1 col2 col3

test1 10 OK

test1 -66...

There is the solution?

I'm so sorry but I could not understand ...: (

The value I have in col2 is 66, by placing the expression gets 2 when it should be -66?

Another example I have 60 and it appears as 4, when...

Now needed something else. placing the value of the negative col2 instead of 0.

I've tried doing the following ways and not resulted, where I am going wrong?

=SUM(IIF(Fields!col3.Value = "DEL",CDec(Fields!col2.Value)-(Fields!col2.Value),CDec(Fields!col2.Value)))

=SUM(IIF(Fields!col3.Value...

Thank you very much. Your solution worked.