With cteDate As (Select Wk=1,DateFrom = Union All Select Wk=DF.Wk+1,DateFrom= DateAdd(DD, -7, df.dateFrom) From cteDate DF Where DF.DateFrom > as (Select RowNr=1,TimeFrom = Union All Select RowNr=Df.RowNr+1,TimeFrom= DateAdd(MINUTE, df.TimeFrom) From cteTime DF Where DF.RowNr < B.*,A. Download (also available on the Mac App Store) NO VIRTUAL MACHINES Tired of having virtual machines eat up your system resources SQLPro for MSSQL is a native Mac application with significant performance and a large feature-set. In this example, 1 query 72 subsets Declare Date = '' Since the test expression count Has integrated SQL editor with many useful SQL editing features. So I want to run above query 12 times for following values of time generated (date part will remain same, only time part will change) 13:17:30 13:22:29 SQLPro is a visual database management and development tool for multiple databases. Is there any way I can run this same query (may be in loop or something) for different values of "time_generated"? For example I want to run this query 12 times to get data between 13:17:30 to 14:17:29 over five minute windows. I have a dirty query that pulls data for past 6 weeks, for same day of the week and same time window of the day.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |