Viewing 15 posts - 646 through 660 (of 1,413 total)
In the code below 'start_cte' creates a column called 'start_ind' which is equal to 1 when the AVAILABLE column has changed from 0 to 1 else it is 0. To...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 3, 2021 at 2:32 am
Because they're different tools for different jobs. JSON or XML are supposed to be versatile(unlike older mainframe type hierarchies) and capable of being transmitted and consumed by a broad...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 21, 2021 at 1:22 pm
The issue isn't so much that SQL server can't parse and format json it's that the data is represented in fundamentally different ways. And what your translation layer is...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 20, 2021 at 8:32 pm
I've seen our CMS mistakes made with various ETL tools, web frameworks, ORMs. Don't fight the tools, learn how to use them.
Fighting the tools is futile in most cases...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 20, 2021 at 2:06 pm
It seems the CASE conditions could be simplified because it's not necessary to test the CHARINDEX prior to REPLACE. If the search characters are not present in the string then...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 16, 2021 at 12:13 pm
With the 2 SQL functions and 1 procedure above in place, the following steps should results in a functional Forum API with 32 .NET Core 3.1 API endpoints wired up...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 15, 2021 at 2:47 pm
.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 13, 2021 at 7:45 pm
.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 13, 2021 at 4:39 pm
.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 13, 2021 at 4:04 pm
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
Viewing 15 posts - 646 through 660 (of 1,413 total)