I'm an SMS administrator and I'm giving myself a crash course in SQL. This sounds like a really simple issue that some SQL guru can figure out in a flash. I want to make a report that lists all of our ...

Note: See the appendix for a description of DLIB.OUTOFSTK. You can use the SQL procedure to create a view that joins the data from these three sources and displays their output. The SAS WHERE or ...

I have a table that logs a record containing a userid, a fileid and a date, one record inserted every time that file is downloaded.<BR><BR>I want to get the top 10 downloads by count for a given date ...