if i didint found ,i need fetch from another function and put into this function

create function function_name(@returndata [varbinary](max))

return table

field1 dattype,

field2 datatype

)

he just told me i cant help u with code,so i need help from you,

i already provide sample data and everything.

company's data are private , i cannot put it in...

simple logic,

suppose i have number between 1 to 10.

i need to check that in 1 table

i have following number

1,2,3,4, 7,8

so s5, 6, 9, 10 are missing in...

result set ,and it has 2 fileds (fromdate and todate)

fromdate suppuse = 10-30-2010

todate = 10 - 30- 2011

i need to check wheather this date is there in item2 function

help me with this code

its not showind date

declare @row1 datetime

set @row1 = @fromYTD

while(@row1 = @Todate)

begin

select thrudate from item3

set @row1 = DATEADD(MONTH , 1 , @row1)

end

plz help me

ok.

this dates are in 1 udf and i need to add in another udf.

let me explain you.

(1) i am executing sp , and am passing param @todate

(2) now i need...

i havent reach this point,untill i get how to see what dates r missing

ok.

just tell me logic

how can i get if this dates r missing in field

thanks.

i will give you feedback when i will get back to this position

thanks

coz while executing sp, i am passing fromdate and todate.

so its taking only that date, in both function

OK,

BASICALLY PITEM AND PITEM4 Calling function fitem and fitem4

now this two function item has data for some fromdate and to date and values

item4 has fromdate,todate and vales,but for all date.

while...

CREATE procedure [pPerformance1]

------Required parameter----------------

@FromDate datetime,

@ToDate datetime,

begin

declare @ReportData3...