Steve Collins

Forum Replies Created

Viewing 15 posts - 661 through 675 (of 1,413 total)

Reply To: Splitting a group up into multiple groups using a score....

This project and my Forum project are basically in the same situation.
https://www.sqlservercentral.com/forums/topic/forum-api-project

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

April 30, 2021 at 7:53 pm

#3878003
Reply To: How to get the sum of hrs. logged for today, past 1 week, this month, & quarter.

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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

April 30, 2021 at 7:24 pm

#3878001
Reply To: Forum Api Project

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

April 30, 2021 at 3:48 pm

#3877917
Reply To: How to get the sum of hrs. logged for today, past 1 week, this month, & quarter.

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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

April 29, 2021 at 2:41 pm

#3877429
Reply To: Pivot table for report
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, 1 months ago by Steve Collins.
- This reply was modified 5 years, 1 months ago by Steve Collins.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 25, 2021 at 2:02 am

#3875413
Reply To: Splitting a group up into multiple groups using a score....

Ok nice. Good. This is my cup of tea. I'll take a look and definitely reply. Maybe a few days
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

April 25, 2021 at 12:14 am

#3875397
Reply To: extract name to 3 single columns
```
cross apply (values (charindex(',', string),
                     len(string))) st(cloc,...
```
- This reply was modified 5 years, 1 months ago by Steve Collins.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 24, 2021 at 11:27 pm

#3875381
Reply To: Pivot table for report

Oops (again). Thank you Jeff. I updated the answer with before/after 2017.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

April 24, 2021 at 10:45 pm

#3875371
Reply To: Deadlocks during concurrent delete operation

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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

April 24, 2021 at 10:01 pm

#3875363
Reply To: Problem with conversion from char to datetime

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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

April 24, 2021 at 4:09 pm

#3875265
Reply To: Problem with conversion from char to datetime

frederico_fonseca wrote:
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

April 24, 2021 at 3:46 pm

#3875252
Reply To: Problem with conversion from char to datetime
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
```
April 24, 2021 at 1:56 pm

#3875226

Reply To: Pivot table for report

Not too long ago there was a question for SQL Server 2012 with pretty much the same pattern.

https://www.sqlservercentral.com/forums/topic/how-to-make-pivot-to-feature-values-based-on-part-ca-and-x-exist-on-input-data/#post-3822116

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

April 24, 2021 at 1:33 pm

#3875224

Reply To: Pivot table for report

Yes, no STRING_AGG in 2012. We're in the 2016 Forum 🙂 To revert you could use STUFF+XML instead of STRING_AGG.

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

April 24, 2021 at 1:25 pm

#3875223

Reply To: Pivot table for report

Not dynamic

select tmp_channel, tmp_entity,
       sum(case when tmp_category='Cat1' then tmp_charges else 0 end) cat1,
       sum(case when...

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

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

April 24, 2021 at 12:10 pm

#3875202

Viewing 15 posts - 661 through 675 (of 1,413 total)