Data Profling tables within SQL Server w/out SSIS Mean_Value, Min_Value, Max_Value

  • Hello everyone,

    I have been giving the task of profiling databases and all the tables within it.

    Right now I'm collecting the following:

    Null_Count

    Null_Percentage

    Total_Record_Count

    I'm looking to capture Mean_value, Min_value, and Max_value and the unique_count.

    Any suggestions that would point me in the right direction of capturing this information?

    Regards,

    Jonathan

  • Jonathan Marshall (6/18/2015)


    Hello everyone,

    I have been giving the task of profiling databases and all the tables within it.

    Right now I'm collecting the following:

    Null_Count

    Null_Percentage

    Total_Record_Count

    I'm looking to capture Mean_value, Min_value, and Max_value and the unique_count.

    Any suggestions that would point me in the right direction of capturing this information?

    Regards,

    Jonathan

    Mean_Value of what?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • Mean max min values of numeric columns.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply