In this scenario, I’ll have a table that has column that is Fruit, this column will have about 1000 + distinct entries in it an a entry on a per day basis. What I’m trying to do is for each distinct type of Fruit, I want to find where the day has sold 2x the amount of fruit from the previous two days com..
Tag : sql-server
I have a challenge to limit a data run on last 90 days, but take into account that there may be differing data entry dates for a grouped set of IDs. If I just run the query to limit data to last 90 days, it will not always pull in all the grouped data (of sets of 6). For the most part, the data entry will all be done on same day. However, there are times we don’t have the values, so data is entered next day or up to weeks later. I am trying to solve that if any of the 5 activities has an entry date within 90 days to grab the companion grouped data that may be older than 90 so it shows up in the r..
While the attempt to debug any query (on local server) I have an exce..
Closed 8 mins ago
Closed 5 mins ago
Error:Msg 191, Level 15, State 1, Line 1712Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller qu..
In my one table I have a date column who’s default value is GETDATE()
However, I would like to have that time be set back 3 hours.
What would be the best way to..
In my one table I have a date column who’s default value is GETDATE()
However, I would like to have that time be set back 3 hours.
What would be the best way to..
I am using Database Experimentation Assistant to replay trace files I captured from my production server. The trace files are on Azure Storage account. When I replay it I see the following m..
I have two databases on the same SQL Server. One is used for production (used by the users), and the other is a test database used for testing. The testing database has the same tables and structure as those in the production database and most tables have a primar..