Need To Pass Parameter Value inside Cast in Cursor

Question

5.00/5 (1 vote)

See more:

SQL-Server-2008

SQL

declare cursor_deci cursor

for select SOuD_CuBal,uom_noofdecimal,sm_code from #itm
declare @sm_code int,@UoM_NoofDecimal int 
declare @SOuD_CuBal as numeric(21,6)
declare @newSOuD_CuBal as numeric(21,6)
open cursor_deci
fetch next from cursor_deci into @SOuD_CuBal,@Uom_Noofdecimal,@sm_code
while (@@FETCH_STATUS =0)
begin
''update #tmp2 SET cubal  = CAST((@SOuD_CuBal)  as decimal(18,@Uom_Noofdecimal)
where sm_code = @sm_code
fetch next from cursor_deci into @SOuD_CuBal,@Uom_Noofdecimal,@sm_code
end
close cursor_deci
deallocate cursor_deci

its giving error near update statement
any suggestions are welcome

Thanks and Regards
Harsha

Posted 3-Jan-13 1:30am

Harsha Dev

Updated 4-Jan-13 1:52am

v4

Add a Solution

Comments

URVISH_SUTHAR1 3-Jan-13 8:13am

Hay Harsha, May I know what error you getting :)

Harsha Dev 3-Jan-13 8:21am

Expecting Integer at @Uom_Noofdecimal :(

But i need to pass integer value by parameter. (Through @Uom_noofdecimal)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

URVISH_SUTHAR1 · Answer 1 · 2013-01-03T02:45:00

Solution 1

Hay Harsha,

See below code and if you can make your query proper then you can get result as int.

SQL

declare @aa as decimal(18,2) =25000.545
select cast(@aa as int)

Let me know if you have any query for above :)

Posted 3-Jan-13 2:45am

URVISH_SUTHAR1

Comments

Harsha Dev 3-Jan-13 22:47pm

ya it will work Thanks, but in the place of int value 2 i need to pass a parameter so that it will take int value from the parameter passed :)

URVISH_SUTHAR1 4-Jan-13 0:41am

try this :)

declare cursor_deci cursor

for select SOuD_CuBal,cast(uom_noofdecimal as int) as uom_noofdecimal,sm_code from #itm
declare @sm_code int,@UoM_NoofDecimal int
declare @SOuD_CuBal as numeric(21,6)
declare @newSOuD_CuBal as numeric(21,6)
open cursor_deci
fetch next from cursor_deci into @SOuD_CuBal,@Uom_Noofdecimal,@sm_code
while (@@FETCH_STATUS =0)
begin
''update #tmp2 SET cubal = CAST((@SOuD_CuBal) as decimal(18,@Uom_Noofdecimal)
where sm_code = @sm_code
fetch next from cursor_deci into @SOuD_CuBal,@Uom_Noofdecimal,@sm_code
end
close cursor_deci
deallocate cursor_deci

Harsha Dev 4-Jan-13 7:26am

Thanks for trying... :)

No Same Error is poping Out near Update Statement,
@Uom_NoOfDecimal expecting an Integer :(

Any more Suggesstions are Welcomed.

URVISH_SUTHAR1 4-Jan-13 7:35am

really unable to understand why you need to cast it, you can define decimal directly

there is something you must need to think, what you say? :)

Harsha Dev 4-Jan-13 7:42am

directly if i put integer then its hard Coded no use, I have a UnitMaster table in the database where i have column named UoM_NooFDecimal it is an integer value. through that unitmaster table and UoM_noOfDecimal column i am trying to cast the column Cubalto no of decimal places.

Harsha Dev 4-Jan-13 7:43am

ya u are write i tried directly casting in select statement but it is not good :)

URVISH_SUTHAR1 4-Jan-13 7:54am

May I know why it is not? :)