Set rstTitlesPublishers = New ADODB.Recordset strSQL = "SELECT title_ID AS TitleID, title AS Title, " & _ "publishers.pub_id AS PubID, pub_name AS PubName " & _ "FROM publishers INNER JOIN Titles " & _ "ON publishers.pub_id = Titles.pub_id " & _ "ORDER BY Title" rstTitles...
***/ SELECT ti.HourlyBucket, COUNT(*) AS CountOfTrips FROM dbo.Trip AS tr INNER JOIN dbo.Date AS d ON tr.DateID = d.DateID INNER JOIN dbo.Time AS ti ON tr.PickupTimeID = ti.TimeID WHERE d.IsWeekday = 1 AND d.IsHolidayUSA = 0 GROUP BY ti.HourlyBucket ORDER BY ti.Hourly...
Set rstTitlesPublishers = New ADODB.Recordset strSQL = "SELECT title_ID AS TitleID, title AS Title, " & _ "publishers.pub_id AS PubID, pub_name AS PubName " & _ "FROM publishers INNER JOIN Titles " & _ "ON publishers.pub_id = Titles.pub_id " & _ "ORDER BY Title" rstTitles...
// Latest scorecard results for a given feature // set the feature flag name to query let QueryFeature = "MyFeatureFlag"; AEWExperimentAssignmentSummary | where FeatureName == QueryFeature | summarize arg_max(MaxTimeGenerated, AllocationId) | join kind=inner AEWExperimentScorecards on Alloca...