none
SQL Query to return all columns & values if [DateModified] today RRS feed

All replies

  • Hi,

    You might be able to use a UNION query for this. For example:

    SELECT [Code], "Attribute1" As [Attribute], Attribute1 As [Value] FROM TableName WHERE DateModified = Date() AND Attribute1 Is Not Null UNION SELECT [Code], "Attribute2", Attribute2 As [Value] FROM TableName WHERE DateModified = Date() AND Attribute2 Is Not Null UNION and so on...

    ORDER BY [Code], [Attribute]


    Hope it helps. ..


    • Edited by .theDBguy Saturday, September 15, 2018 2:24 PM
    Saturday, September 15, 2018 1:53 PM