I tried creating alias but acces denied.

sum(cast(t.duration as float(5,1))/360000) as Duration ,result is 12.41

sum(convert(decimal(8,1),(t.duration)/360000)) as Duration, result is 6.0

12.41 is the correct value. but i just need to display only 12.4.

according to the second conversion the...

I want to divide duration/360000 and the value returned shud have only one decimal point .

If the value returned is 51.000001, i need just 51.0

I tried it already but the values i got are different

15.0

6.0

7.0

6.0

39.0

0.0

I want to divide duration/360000 and the value returned shud have one decimal point

when am doing this

sum(convert(decimal(8,1),t.duration)/360000) as Duration

am getting

51.00000000

12.40000000

30.80000000

15.00000000

48.10000000

1.60000000

but i need only 1 decimal point

I am not sure why am not getting the result as expected though am trying to test with known result.

Hey guys have you tried doing this, is it working?

everytime I...

if this is not getting result,is there a way to find a table or column name which was recently updated or recently inserted a row

thanks

its a char value

tried with some other sample date where i know the table and column name but its not giving nay result in the temp table.

when in ran that query i gives me an error saying invalid object name for most of the tables though the table name is correct

sample data is exact like.the size of the DB wud be 900MB

If its not possible, i wud like to know how can i can find a table which is updated...

yeah i nkow how to check if i have some idea about the column, i just have some piece of date and need find where it is stored.

thank you very much matt. Appreciate your help

thanks matt, it works

may i know what is that % doing there

am not sure if am explaining it correctly..let me try again

I have time in millisec like 630000 in my DB for which it was entered as 1.75 from the app...