Some info about Query..

[Former Member]

Hi.. See the image..

I had created one table in sap b1

it has some values ... some 45 ,34,23,

so

i had written a query as

select max(code) from [sales_oppr]

But, it is showing diff values instead of max value may i know why..

[Former Member · Accepted solution]

Hi,

   Try this....

    Select max(cast("code" as numeric)) from [@sales_oppor]

Rgds,

Priya

[Rafaee_Mustafa]

Hi Seenu,

By default UDT created 2 fields Code and Name of nvarchar field type. Convert your field to INT

Try

SELECT MAX(CAST(Code AS Int)) FROM @sale

Regards,

[KennedyT21]

Hi Seenu,

What is the Filed Type for Code... it should be Int as for your required result. I think now it is nvarchar...

try this

SELECT ISNULL(MAX(CAST( code  AS Numeric)),0) FROM  [sales_oppr]

Regards

Kennedy

[ANKIT_CHAUHAN]

Hi Seenu,

Try this

SELECT ISNULL(MAX(CAST(" + Column + " AS Numeric)),0) FROM [" + Table + "]

Hope it helps...

Thanks

[KennedyT21]

Hi Seenu ,

I think the data has some error... check with the Data

your Query is correct

Regards

Kennedy