Unable to Subtract Dates SQL Server

by

Using the sample data you posted (and adapting it slightly), here is my attempt to solve the problem:

SELECT BASESCORE, 
       Datediff(dd, MINDATE, MAXDATE) 
FROM   (SELECT BASESCORE, 
               Cast(Max(DATETIME) AS DATETIME) MaxDate, 
               Cast(Min(DATETIME) AS DATETIME) MinDate 
        FROM   table1 
        GROUP  BY BASESCORE)T

You can take a look at the full working version on SQL Fiddle.

Let me know if there was something I misunderstood 😉

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. T-SQL split string
  3. Conditional WHERE clause in SQL Server
  4. How to create a table from select query result in SQL Server 2008 [duplicate]
  5. Multi-statement Table Valued Function vs Inline Table Valued Function
  6. SQL Server Insert if not exists
  7. GROUP BY to combine/concat a column [duplicate]
  8. How to set table name in dynamic SQL query?
  9. Copy data into another table
  10. How do I see active SQL Server connections?
  11. EXISTS vs JOIN and use of EXISTS clause
  12. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  13. Why is a UDF so much slower than a subquery?
  14. Split function in SQL Server 2008
  15. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  16. Alternate of lead lag function in SQL Server 2008
  17. UNIX_TIMESTAMP in SQL Server
  18. How can I group by date time column without taking time into consideration
  19. Generate random int value from 3 to 6
  20. Add emoji / emoticon to SQL Server table
  21. SQL Server SELECT INTO @variable?
  22. How do I change db schema to dbo
  23. How to subtract 30 days from the current date using SQL Server
  24. Count records for every month in a year
  25. Safest way to get last record ID from a table
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment