Home Forums Cloud Computing SQL Azure - Development How to make my number shorter?? RE: How to make my number shorter??

  • May 21, 2013 at 5:50 am

    #1616948

    karim.boulahfa (5/21/2013)

    ChrisM@Work (5/21/2013)

    karim.boulahfa (5/21/2013)

    The valua is FLOAT of the column

    FLOAT is the data type.

    Can you show some sample data for the columns I listed?

    select *

    from StatisticalDisk

    Thats are the rseult of the colmns valua's

    nStatisticalDiskID DpolltimestTypenSizenUsed_AvgnUsed_min nUsed_max nTimedelta nDatatype nStatisticalDiskIdentificationID

    188323672013-05-02 13:24:23.627Fixed Disk25801953280119614586881196145868811961458688600,00292968751254

    188323682013-05-02 13:24:23.643Fixed Disk89769836544369119641603691196416036911964160600,00292968751255

    188323692013-05-02 13:24:23.673Fixed Disk262824960107304961073049610730496600,00292968751256

    188323702013-05-02 13:24:23.690Fixed Disk25801986048797573127975731279757312600,00292968751257

    Its about nUsed_min/max and AVG

    Thanks. What are the units? Bytes? You need to know this for your output column headers.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden