if you dnt mind would please explain the "sp_executesql" what is the use??

and what should be do there??

while executing dis query error occured on output:

exec

hey friend

i am executing dis qury on sql server 2000 only...its not server 2008

while em using str in my query its showing error, like

select slno,entrydate,goals,kpi,weightage,goals_review_date,reviewcomments,reviewedby,reviewdate

from GOALSDTL

union

select str((slno,entrydate,goals,kpi,weightage,goals_review_date,reviewcomments,reviewedby,reviewdate),5,2)

from GOALSDTL_History

error:

doest convert date into int

create table tab1(name varchar,class int(22),noofsubject numeric(12),rank int(10),test varchar(22),stuid int(11),accodomicyear nvarchar(22))

create table tab2(name varchar,class int(22),noofsubject numeric(12),rank int(10),test varchar(22)),stuid int(11),accodomicyear nvarchar(22))

insert into tab1 values(' ravi',2 ,5 ,' ' ,'revision-II',002244,2011)

insert into...

...

friends year is'2011-2012' data type is"nvarchar"

while i am paasing inputs on procedure its shows error of

"error converting datetime from character string."

please give me any suggestion???

is any other alter natives there ???

In that same query i have histroy_date is there , i want to display the data if date contains null and not null....... how to pass the condition on procedure

hi friends,

I am getting the expect output, making the modification on accyear......

alter procedure fst_der

(

@eid varchar(70),

@b-2 datetime,

@C datetime,

--@hist datetime)

as

begin

select slno,goals_type,entrydate,

goals,date_of_commitment,kpi,

weightage,goals_review_date from LIMS..GOALSDTL_Audit

where...

how to pass this value '2011-2012' into accyear in procedure

while i am giving the input of empcode and accyear wanna show entire details.....

/* EXEC data_ddl '001244','2011-2012'

expecting output:

slno goals ...

create table data_dd(slno numeric(22),goals varchar(22),kpi varchar(22),weightage numeric(22),record_status char(8),empcode varchar(12),accyear date)

insert into(1,'webdevelopment',2451,40,u,002244,'2011-2012')

insert into(6,'webdevelopment',2451,46,u,002244,'2011-2012')

insert into(8,'webdevelopment',2451,46,u,001244,'2011-2012')

insert into(9,'webdevelopment',2451,46,u,001244,'2011-2012')

while i am giving empcode and accyear as input in procedure has shown the entire data in...

while em exectue the procedure

exec data_dd '002244','2011-2012'

showing null .... not given expected output

if i need the output means what i ve do