Where do you draw the lines between languages, applications, and tools?  In the SQL realm imo Redgate, Quest, etc. are "no code software" tools.  The output (if used properly) is...

This project and my Forum project are basically in the same situation.

https://www.sqlservercentral.com/forums/topic/forum-api-project

Hi there marksquall.  It shouldn't be necessary to combine the queries.  There are 2 queries because your question seemed to contain 2 parts.  Part 1, calculate the date difference in...

.

One alternate approach could be to use OUTER APPLY and locate the logouts using SELECT TOP(1).  Then you could use ISNULL to assign a default value to cases where there's...

If you add GROUPING SETS the non dynamic code looks something like this.  Since most people want the total to appear on the bottom row, 2 grouping columns were added...

• This reply was modified 5 years, 3 months ago by Steve Collins.
• This reply was modified 5 years, 3 months ago by Steve Collins.

Ok nice.  Good.  This is my cup of tea.  I'll take a look and definitely reply.  Maybe a few days

cross apply (values (charindex(',', string),
                     len(string))) st(cloc,...

• This reply was modified 5 years, 3 months ago by Steve Collins.

Oops (again).  Thank you Jeff.  I updated the answer with before/after 2017.

It's too broad of a question question because everything depends on the totality of your situation.  In general imo clustering on a GUID (which is intentionally random) is likely to...

Rereading what both Jeffery and me posted, it's correct and doesn't need editing.  The CONVERT is not necessary.  Frederico is also correct too.  CONVERT will work if the correct format...

datetime DOES have a format on convert - and that is what is causing it to fail.

format 1 is US - so date string should be on format...

Datetime has no format so using CONVERT with a format code is not necessary.  The code should work if CONVERT is completely removed.  Or you could use CAST instead.

Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können