| About the Transact-SQL category |   | 0 | 2147 | May 7, 2015 | 
        
          | Pivot Tables in SQL |     | 2 | 33 | October 22, 2025 | 
        
          | Remove leading left zeros only |           | 18 | 3917 | September 23, 2025 | 
        
          | SUBSTRING Functions |         | 5 | 57 | September 16, 2025 | 
        
          | alculate the total daily medication dosage for each patient between specified start and end dates to generate a daily report. |       | 15 | 168 | September 11, 2025 | 
        
          | Getting a sum for date ranges of 7 days when there are missing dates |       | 6 | 62 | August 22, 2025 | 
        
          | Find the statistical MODE |         | 3 | 45 | August 21, 2025 | 
        
          | Select from a comma separated string |       | 3 | 47 | August 5, 2025 | 
        
          | Compare alpha results to INT after get values from a string |           | 7 | 72 | July 30, 2025 | 
        
          | Calculating Survey Scores by Month and YTD |       | 10 | 105 | July 30, 2025 | 
        
          | Extract part of a string with inconsistent length |       | 2 | 94 | July 30, 2025 | 
        
          | Recursive CTE Alternative |       | 3 | 1291 | July 30, 2025 | 
        
          | Consecutive count of holidays if first date of a month is holiday |         | 12 | 88 | July 4, 2025 | 
        
          | SQL MERGE How to Insert non duplicates and return duplicates? |     | 3 | 275 | June 23, 2023 | 
        
          | I need help with checking the sql query |       | 3 | 82 | June 21, 2025 | 
        
          | average duration increasing inline with exec counts |     | 1 | 32 | June 12, 2025 | 
        
          | Pivot data but keep equal number per metric |     | 2 | 49 | May 22, 2025 | 
        
          | Who has joined and who has left |     | 2 | 57 | May 19, 2025 | 
        
          | Show difference between records in master file and submitted records |       | 5 | 72 | April 28, 2025 | 
        
          | BATCH CTE and recursion - CTE table doesn't exists |       | 2 | 79 | April 20, 2025 | 
        
          | HOW To get result from delete a row then execute store proc |     | 1 | 55 | April 6, 2025 | 
        
          | SUMIF scenario in SQL |       | 3 | 83 | April 5, 2025 | 
        
          | Fill forward for YTD calculations |     | 3 | 45 | April 5, 2025 | 
        
          | Error with BULK Insert in T-SQL |         | 5 | 63 | March 23, 2025 | 
        
          | Summing Count of Appointments within 30 days for each Date |         | 3 | 68 | March 19, 2025 | 
        
          | I need the logic for this requirement |     | 2 | 56 | March 8, 2025 | 
        
          | Sql to get latest record under some condition |       | 4 | 89 | March 8, 2025 | 
        
          | Query taking long time to run |         | 3 | 77 | March 6, 2025 | 
        
          | Create a store procedure to Update From One Table to Another Based on an ID |       | 3 | 56 | March 3, 2025 | 
        
          | Find when SQL raw was created  when no date column |     | 1 | 41 | February 28, 2025 |