Viewing 15 posts - 571 through 585 (of 26,490 total)
You need to use a tally table. In the code below I create one as part of the query.
declare @AppDate datetime = '2014-01-01';
with e1(n)...
December 20, 2018 at 8:56 am
December 19, 2018 at 3:46 pm
December 19, 2018 at 2:18 pm
The question on everyone's mind, will the SQL Bolts win their fourth Championship? Looks close and it will come down to just one thing, On any given Sunday.
December 19, 2018 at 1:58 pm
Dumb thought, could ID:27 be a statistic on the table?
December 19, 2018 at 10:45 am
To restore the same database on the same server without overwriting the existing database you will need to rename the database and the physical file names.
December 18, 2018 at 4:50 pm
December 18, 2018 at 2:09 pm
It is the SQL Bolts and Prestige Worldwide in the Championship Game next week.
December 17, 2018 at 9:21 pm
Problem
December 17, 2018 at 12:03 am
I would say that is dependent on what you are attempting to return. If it is the min or max of a specific column, you may be correct.
December 16, 2018 at 11:51 pm
This was a tough week. Only three teams accumulated 100+ points.
December 16, 2018 at 9:53 pm
December 16, 2018 at 5:58 pm
SQLDCH - Friday, December 14, 2018 10:25 AM
Looks like I may lose this week. Chargers shutdown Mahomes...
December 14, 2018 at 11:08 am
Another problem I just saw, your correlated subqueries in your select list have quite a few that use TOP 1 but there is no ORDER BY. What this means is...
December 13, 2018 at 8:42 am
Viewing 15 posts - 571 through 585 (of 26,490 total)