ok

j

inline table valued function can call sp?thats my question

thanks drew,is there any other way.

i cannot use udf , as i cannot call sp inside it.

i need to get result of cursor in select statement.

where can i put this...

i m closing this thread

no this i need to do from udf which returns table

and i need to put in while or for condition

ok ,i m giving sample date this time

this TIME I AM GIVIng SAMPLE DATA plz help

MemberID index

-9 ...

OK ,IF I CANNOT HEN how can i store my logic which include execute sp and returns 1 value

i need to call this value in case statement

ok. i will go through book.

right now i need 1 solution

i have created 1 sp, and in that i am calling another sp.

now

this sp returns 1 float value

that i...

ok. i already posted my formula for cumulative.

i hv another prov

i have delcare variable

declare @abd datetime

now i need to get 1 date from function

like

select @abd = fromdate from item2(@rdfd)

fromdate hace...

i hv this formula for cumulative

(exp(sum(LOG(CASE WHEN I1 = 0.0 THEN 1 WHEN I1 IS NULL THEN 1 WHEN I1= -100 THEN 1 ELSE 1+I1/100 END)))/-1)* 100,

i am getting error...

this is what i have to figure out ,how they calculate it.

i dont know what is cumulative formula.

but this is how i am getting my final data in report.

so based on how they calculate , i need to do implement that...

NUMBER CUMULATIVE

0.00

2.78 2.78

1.01 3.82

2.07 5.97

1.71 ...

i have this data in 1 table

I1

2.3

4.5

3.4

2.3

1.2

now i need output lik this

cumulative of I1

----------

how to do it