thnak u:-):-):-):-)

thank u

thanks a lot..

thank u sir for your advise....using dynamic sql is dangerous means surely i will change my procedure ....

so there is a way to get a o/p using dynamic sql right..but how....i don't know many thing about dynamic sql....how do i insert the values in a same row...

thank u sir.i got it

thank you very much sir...it works well .and i have to sum both the values so i tried this but the same problem?

SET @total = CAST(( CAST(ISNULL(@mv_mark, 0) AS INT)...

yes i know that.but i need '12.00' as result.so what should i change here?

i don't understand,what you mean by sample data???

can u help me sir? i am new to db

CREATE proc [dbo].[student_marks]

@roll_no varchar(20)

AS

BEGIN

CREATE TABLE #temp

(

semester INT,

marks INT

)

INSERT INTO #temp

(

semester,

marks

)

SELECT

semester,

( SELECT SUM...

can anyone help me? i am new to db....

CREATE proc [dbo].[student_marks]

@roll_no varchar(20)

AS

BEGIN

CREATE TABLE #temp

(

semester INT,

marks INT

)

INSERT INTO #temp

(

semester,

marks

)

SELECT

semester,

( SELECT SUM...

sir can u help me to find out?????how can i pass more values in the below parameter???

SET @cursemcredits = ( SELECT SUM(credit)

...

hello sir..can u plz help me .....i don't knw how to solve this conflict ''The INSERT statement conflicted with the FOREIGN KEY constraint "FK_product_details". The conflict occurred in database "catalog",...

hi everyone.....i am the beginner of sql......can anyone help me to find out the mistake where i made????ive tried many times bt again nd again i gt same result"null...

hi everyone.....i am the beginner of sql......can anyone help me to find out the mistake where i made????ive tried many times bt again nd again i gt same result"null...