Yes i checked is on. Also checked the firewall settings.

I can connect to the default instance in the same server.

SELECT LASTNAME FROM CPM.dbo.T_CANADIAN

WHERE '678567' BETWEEN '673001' AND '679000'

AND 'Z' BETWEEN 'P' AND 'P'

this worked.

Please tell me how to do it.

CREATE FUNCTION [dbo].[f_ServiceAvailability]

(

@DateForm DATETIME,

@DateTo DATETIME

)...

I need the result in percentage value.

The accumulated date range has to be converted to percentage?

Please help.

I want to use CURSOR, which will be scanning the temporary table.

So with cursor you will be reading the temporary table row by row. Then I have to compare...

Sample data:

reading_timestamp level

06/09/2005 1000

07/09/2005 ...

Thanks very much for your help.