Great Work. Keep Posting about Big Data. 🙂

Nice question to Start a Day 🙂 🙂

any answer for this question please.?

what you are trying to do here is to add a varchar value to int value. which is not possible.

think a little bit more logical. if you dont get the...

it is the same post posted by me on different forum. 😎

any sql master for help.?

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...

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 =...

12.00 is not an integer. so you can convert this value to an int.

if it is 12 then you can do it.:hehe:

Toreador (5/13/2013)

---

I wrongly assumed the point of the question was that the table wouldn't have an identity column because it wouldn't be created at all due to the lack of...

an identity column against each row would serve the purpose.....

you can use merge join then

Same goes for me as well.... just lost...

Kingston Dhasian (4/26/2013)

---

You might appreciate a complete answer but it will not...

Kingston Dhasian (4/26/2013)

---

You will need to create a trigger check if the column has been updated

If the column has been updated, you can do a ROLLBACK in the trigger with...

friends, since i am new to sql, i have little confusion with this query ( i.e. choice number two and four)

Choice two: SELECT ID, COALESCE(IsAvailable, GETDATE()) FROM #Test

choice four:...