Skip to content

Tag: sql-server

Microsoft SQL Server Streak Counter

I have data in the following format: ID Period Date 1 1 2020-09-05 1 2 2020-10-01 1 3 2020-10-30 2 2 2020-10-01 2 4 2020-12-05 2 6 2021-02-05 3 1 2020-09-05 I want to calculate a streak grouping by both ID and period. The first date instance for each group should start at one, and if the date in the

How to get NULL or Zero values in SQL Server results set

Trying to get the output of all mentioned accounts(total of 9) even though there are no existing records for the GB.periode = 11 Tried using ISNULL(SUM(GB.bdr_val), 0) but still I’m only getting output for GB.reknr = 5210 OR GB.reknr = 5211 OR GB.reknr = 5250 OR GB.reknr = 5340. I have a sample DB layout below, I still need the

Add a filter to timeseries pairs

I have a time series plc tag data as below with values in ‘1’ or ‘0’ Using below code I can get the output Output But my requirement is, I only want to query going back 25 hours, so I add a predicate: But this returns the error: Msg 209 Level 16 State 1 Ambiguous column name ‘datetime’. Answer You

Between the time in SQL Server and ASP.NET

I am storing STARTTIME and ENDTIME in a SQL Server table by using ASP.NET webform. Now, as you can see in the row with timeTableID = 2, the inserted time value is 8:00 & 8:30 AM, But in the row with timeTableID = 3, the inserted time value is 8:15 & 8:25 AM, I don’t want this because its within