Pls Reply to My Q.?, T-SQL Experts, if i dont find the solution it will be like a problem to me..

even suggestions r welcomed ,i will try them.

i dont think it will work, still i will try

becoz for experimental purpose i tried dividing it directly by integer

1/2 like this.

and it was throwing error

iam using SQL-SERVER 2000,

i saw one post which had this option,but it was some 6 months, it said every inserted records make an entry in some system table, and we...

my exact code is like this.. i copying and pasting

set @SQlViUp= 'Update RMCPL_DAILY_ACTIVITY set RMCPL_MD_POINTS='+@EchVpoin +' where

RMCPL_USER_CD=4'

execute sp_executesql @SqlViup

and error message is

Server: Msg 8115, Level 16, State 6,...

set @SQlViUp= 'Update RMCPL_DAILY_ACTIVITY set RMCPL_MD_POINTS='+@EchVpoin +' where

RMCPL_USER_CD=4'

my query in stored procedure is as above, i just copied and pasted i tried datatype converting it into decimal it...

Great it works, but when i try to update it throws an error becoz datatype is numeric(18,2)

should i convert it to decimal ?

I TRIED THIS OPTION

WITH

FIRST I TRIED WITH

SET @EchVpoin = 1/2

THEN

seLECT @EchVpoin = 1/2

IT IS STILL SHWOING @EchVpoin =.00

??

its working .

but after geting a value iam updating a some rows in a particular table and the column is numeric, and iam updating using decimal

so it is throwing error.

in...

Pls Solve my Problem iam sukhoi971, i have posted 2 messages nobody is even vieweing it..

Thanks A Lot,

you solved my time consuming problem, no where in the sql server books there is any note of this thing.

and i got the answer within 3-5 minutes of...

thanks to u ppl for ur interst

i got the solution,

solution is-->

i did cast( fieldname as varchar(20)) or something for each and it worked..

each and every field was

but this does not provide any ans to her,

i could have answered,

but i dont know.

thanks jonathan, i was asked this query in an interview and i couldn't ans i was applying for the post of DBA hehe