if it can be done by another way which is faster let me know

i got it using

where id=@id

and (

(@con=0 AND YEARMONTH >=Replace(@YearMonth,'-',''))

OR (@con<>0 AND YEARMONTH <>Replace(@YearMonth,'-',''))

)

the whole sp cannot be posted as there are many joins

to get the result & check i prepared 3 different SPs with conditions as stated above

SP1 contains @dt1...

not fully understood

using the above i am not getting any records

but in query analyser i get 100 records with date condition & id condition

ALTER PROCEDURE [dbo].[JOBRECINSERT]

@JOBID as bigInt,

@YEARMONTH as int,

@TRANSTYPE as char,

AS

BEGIN

DECLARE @ERNO AS INT

BEGIN

SET @ERNO=(SELECT EID FROM TABLEA where JOBID=@JOBID)

SET @ERNO=@ERNO+1 ...

there is no 4 in the SP

i even checked with select * from table1

i am not sure where do i get it from but i found this on debugging

?cmdupdate.CommandText

"4"

?cmdupdate

{System.Data.SqlClient.SqlCommand}

...

checked the sp with jst return stmt

also checked it with simple select stmt without parameters

checkedd connection string

but still when executed frm application gives the same error

ya i updated the stored procedure as given by u

i even tried by hardcoding the values in sp without passing the parameters still i get the error as below

System.Data.SqlClient.Sqlexception }:...

no i have not created anytriggers

and i modified the sp as given by u ,still the same error

CREATE TABLE [dbo].[M_PRDT](

[PID] [numeric](18, 0) NOT NULL,

[PNAME] [varchar](50) NOT NULL,

[PRATE] [float] NOT NULL,

[SCHEME] [bit] NOT NULL,

[REMARKS] [varchar](50) NOT NULL,

CONSTRAINT [PK_M_PRDT] PRIMARY KEY CLUSTERED

(

[PID] ASC

)WITH (PAD_INDEX = OFF,...

not ableto undertstand why i get syntax error near 4

no i mean the output needed is

empid 'basic' da ta hra...

using the sql that i gve also give s me the same out put a this

but this is not i need

i mean i get the empid repeated

i shld get...

create table sal(empId nvarchar(10), sal_comp nvarchar(10), IncomeAmount int)

--drop table sal

insert into sal values ('SPIKE', 'basic', 100)

insert into sal values ('SPIKE', 'da', 300)

insert into sal values ('SPIKE', 'hra', 400)

insert...

i tried exporting

1) to excel

it appears in a single column as seen in the report viewer

2) to pdf

only one label is visible that too in the center of...