Forum Replies Created
Viewing 15 posts - 61 through 75 (of 290 total)
-
Reply To: find the number of values less than the current row
Jonathan AC Roberts wrote:declare @DaysToLookBack int = 5
select *
from [dbo].[TestTable1] a
cross apply (select count(*) Count
... -
Reply To: find the number of values less than the current row
Jonathan AC Roberts wrote:There aren't 3 values less than 88 within 5 days of (including the reference date) 2024-02-28
2024-02-28 minus 4 days is 2024-02-24.
So there are only 2 rows less than that...
-
Reply To: find the number of values less than the current row
Jonathan AC Roberts wrote:The gaps in dates shouldn't be an issue.
The data you provided isn't the data you put in your amendment of the query.
The results from the test data you provided...
-
Reply To: find the number of values less than the current row
Jonathan AC Roberts wrote:Has TRADE_DATE got a time part on it? If so is it not always midnight?
Can you supply some test data?
np. here you go:
CREATE TABLE [dbo].[TestTable1](
[company] [nvarchar](50)... -
Reply To: find the number of values less than the current row
Jonathan AC Roberts wrote:declare @DaysToLookBack int = 5
select *
from [dbo].[TestTable1] a
cross apply (select COUNT(*) Count
... -
Reply To: find the number of values less than the current row
SoCal_DBD wrote:This is the output I get. (In fact I did a copy/paste from my post).
my bad. i made a typo when i copied over the formula. ...
-
Reply To: find the number of values less than the current row
SoCal_DBD wrote:It's Friday afternoon and this was a nice small example. Here's my offering:
-- Create sample data
DROP TABLE IF EXISTS #Example
CREATE TABLE #Example
(DayNum... -
Reply To: find the number of values less than the current row
ScottPletcher wrote:Need sample data that is directly usable, that is, CREATE TABLE and INSERT statement(s), not just a splat on the screen.
no problem. here you go:
CREATE TABLE...
-
Reply To: how to speed this query up?
ScottPletcher wrote:You've already got restrictions based on @LOOK_BACK_PERIOD in the WHEREs, it would just be more efficient to pre-filter rather than waiting until some processing has been done on all...
-
Reply To: how to speed this query up?
duplicate post by accident
-
Reply To: how to speed this query up?
ScottPletcher wrote:Did you add the WHERE condition for the TXN_DATE? If you have a long history in the table, that would help the most.
Then try an index on (txn_date, company)...
-
Reply To: how to speed this query up?
ScottPletcher wrote:Need the DDL for the table to sure of more specific recommendations for best speed, but, assuming you will keep a long history in this table:
(1) Either: (A) cluster...
-
Reply To: how to speed this query up?
sure thing no problem.
I have attached an Excel sheet with sample data and expected outcome. In case you prefer to not download file then here is a screenshot with description. ...
Viewing 15 posts - 61 through 75 (of 290 total)