none
Find Tables in an SQL Server Database having date greater than today RRS feed

  • Question


    • Hi 

      I am looking for a query which returns all the tables list with in a database of sql server instance which are have date value greater than today.

      For Example: I have 100 tables in a database , some of them are daily truncate and load always Load_Date columns of these tables will be 1 date that is getdate(), and some tables have multiple date values in Load_Date as they are not truncate and load .

      So based on the Load_Date column i need to find tables which have multiple date values.

      Please help me to get SQL code for this
      .Thanks

    mardi 28 mai 2019 06:19

Toutes les réponses

  • Hi 

    I am looking for a query which returns all the tables list with in a database of sql server instance which are have date value greater than today.

    For Example: I have 100 tables in a database , some of them are daily truncate and load always Load_Date columns of these tables will be 1 date that is getdate(), and some tables have multiple date values in Load_Date as they are not truncate and load .

    So based on the Load_Date column i need to find tables which have multiple date values.

    Please help me to get SQL code for this.

    Thanks

    • Fusionné Olaf HelperMVP mardi 28 mai 2019 06:22 Same question from same OP
    mardi 28 mai 2019 05:58