hi,

How i can give permision for non admin users. ???

Thanks

Here no error messege showing. ( i dont know how to debug stored procedure ).

Just i tried to get dataset(im using c# asp.net) . Always my dataset blank. then...

Thanks Karl for your reply.

But i heared Cursurs are memory huter. So if i use cursors will it take more time or are there any othere way to do this

I dont clear with this answer. So if there are more than two criterias to search, is that theory applicable or not.

ex-

SELECT RefNumber, ProjectName, Type, Details,...

CREATE PROCEDURE [dbo].[VIEW_REPORTS]

@BRC_START_DATE datetime,

@BRC_END_DATE datetime,

@Hild_Branch varchar(50),

@REPORTSIZE int,

@RPT_REPORT_NAME varchar(10),

@USER_ID INT,

@ReportType_Code nvarchar(50)

AS

declare @MonthFirstdate as varchar(50)

declare @Month as varchar(50)

Declare @Year as varchar(50)

set @year =year(@BRC_END_DATE);

set @Month='';

if MONTH(@BRC_END_DATE)<10

begin

set @Month= '0' + month(@BRC_END_DATE);

set @MonthFirstdate=...