Mr. Kapsicum (6/14/2013)

---

DECLARE @mv_mark varchar(500),

@ob_mark varchar(500),

@tot varchar(500),

@mv_mark1 varchar(500),

@ob_mark1 varchar(500)

SELECT @mv_mark =mv_mark

FROM internal_nontheory_mark

WHERE roll_no = '11csu002' AND regulation_sub_id = 15849

SELECT @ob_mark = ob_mark

FROM internal_nontheory_mark

WHERE roll_no = '11csu002' AND regulation_sub_id = 15849

SET @mv_mark1 = CAST(COALESCE(@mv_mark, '0') AS VARCHAR)

SET @ob_mark1 = CAST(COALESCE(@ob_mark, '0') AS VARCHAR)

select @mv_mark1,@ob_mark1