Viewing 15 posts - 661 through 675 (of 1,419 total)
It appears you're looking to join rows where p1.usr_kataloghierarchie is not null and p1.pm_extended_id equals the left 8 characters of p2.pm_extended_id.
select p1.usr_kataloghierarchie, p2.pm_extended_id
from pm_process p1
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 12, 2021 at 11:26 am
Are you using the .NET Framework or .NET Core? The code above references System.Web.Services which implies the full framework. Since you're migrating off of SOAP endpoints is this reference still...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 10, 2021 at 11:55 am
Rob, sorry, yes.
Are you just saying that the project you started on that thread is in the same sort of position as this one or that you have some sort...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 9, 2021 at 1:26 pm
Thanks for the reply. That works or why not just copy what Scott did
SUM(CASE WHEN PAYCODE <> 'SICK' THEN...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 3, 2021 at 11:09 am
It appears the math in example 3 is off a little. You could try something like this
;with SampleData (person, costcenter, amount, paycode, [date]) as (
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 2, 2021 at 2:21 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 1, 2021 at 2:50 pm
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
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
.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 30, 2021 at 3:48 pm
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
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 25, 2021 at 2:02 am
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
cross apply (values (charindex(',', string),
len(string))) st(cloc,...Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 24, 2021 at 11:27 pm
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
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
Viewing 15 posts - 661 through 675 (of 1,419 total)