SQL Query?

[GhostlyPea]

Hi guys,

Need a little help here if possible as I haven't really touched SQL or Access style queries since my A-Levels...

Server - 2k8 R2
SQL - SQL 2008 R2

Essentially I have a database that I need to run a query against (I guess) to see if something has updated in 24 hours.

What I do know that may be helpful:

Table name that the information resides in - configarchive
Field that has the last time update in - downloadtime
This information needs to be tied to an object in another table called nodes where the field in question is call nodeid

So as a summary what I need is to have rows of information displayed with some kind of indicator whether the field downloadtime is within 24 hours of the time the report has been run?

Ideally this could then be automated somehow to run nightly and have the results e-mailed through in some kind of readable format.

I know this is possible because the creators of the software have indicated that it is, however they don't support custom SQL queries so I'm after some help

If you need any more info let me know and Ill see what I can get

Thanks

- GP

 

[GhostlyPea]

Lovley, thanks so far!

I'll have a look tomorrow and see if I can find what the common field is.

Cheers!

- GP