Skip to Content
0

I need to Convert Varchar to Integer in sap bods

Dec 05, 2016 at 10:54 AM

312

avatar image

Hi All,

I nee to Convert Varchar to Inetger in sap bods?

I have source is varchar datatype and Target is integer data type

I have in source column is Mastercard is 'Yes' and but target will be showing in '1'

Please let us know..

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Dirk Venken
Dec 06, 2016 at 11:24 AM
0

decode(source_column = 'Yes', 1, 0)

Share
10 |10000 characters needed characters left characters exceeded
kris k Dec 06, 2016 at 12:56 PM
0

Thanks Dirk

Share
10 |10000 characters needed characters left characters exceeded
kris k Jan 23 at 12:56 PM
0

Hi Shazin,

Thanks for replay! I need to test stored procedure step by step. In this stored procedure they are used 20 select statements. All select statements are temp tables. I need to figure out which select statement taking lot of time. I have tested in SQL Server side but i need to test SAP BODS also.

Thanks,

krish.

Share
10 |10000 characters needed characters left characters exceeded
kris k Jan 22 at 11:59 AM
0

Hi Dirk,

I am going to ask you one question ?

Below the Script is SQL Server Script

IF OBJECT_ID('tempdb..#tblDebugLog') IS NOT NULL

DROP TABLE #tblDebugLog

How to write above the script in SAP BODS in Scripting? Can you please let me know.

If you replay to me it is very helpful.

Thanks,

krish.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Write a database procedure and call it from DS.

This will be helpful Click Here

Shaz

0