I need to Convert Varchar to Integer in sap bods

[former_member281308]

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

[former_member281308]

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.

[former_member281308]

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.

[former_member442248]

Write a database procedure and call it from DS.

This will be helpful Click Here

Shaz

[former_member281308]

Thanks Dirk

[former_member187605]

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