Viewing 15 posts - 196 through 210 (of 1,414 total)
Is x a column in table A? It seems so. The SQL language does not support dynamic join types or JOIN conditions derived within a WHERE clause based on CASE...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 30, 2023 at 7:58 pm
There is probably a better method:
Well I came up with pretty much the identical query. Joining the rows back together using the array keys seems unavoidable. In SQL Server...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 14, 2023 at 7:49 pm
If I'm understanding then perhaps an INSERT statement and an UPDATE statement. Possibly it could also be done using a MERGE statement however I don't use such syntactic sugar. Also,...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 7, 2023 at 2:15 pm
Author Joe Booth gives SSC a nice mention in this YouTube video at about the 11:11 mark. The channel is Syncfusion which afaik is a .NET UI kit vendor (which...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 25, 2023 at 4:34 pm
Curious, why not create 2, 4, or ?? procs instead? Instead of enums in C#, a UDT, and dynamic SQL could you not get rid of the parameterization and just...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2023 at 12:54 pm
If I'm understanding then imo there are possibly some non-modelled attributes and/or relationships. Also, when the spec says to record the address at the time of the transaction imo that...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 11, 2023 at 4:26 pm
Understood. For me, performance is 2nd only to a correct result... and its a very, very close second and I, having learned many painful lessons about it in the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 31, 2023 at 11:44 am
So I thought to unpivot and then find the distinct and thereafter pivot it again. Which is lengthy.
Yes imo you've got the right ideas unpivot and re-pivot is what's...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 28, 2023 at 2:59 pm
DENSE_RANK is the better solution in this case though. Good on Drew it's another interesting one
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 27, 2023 at 8:58 pm
Yes sorry, I didn't save that gpt context. Iirc I posted the question in its entirety and asked for sample data and a solution. The query it came up (which...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 27, 2023 at 5:44 pm
In Postman you could open the POST method and then click on the '</>' code symbol. That should generate the cURL code of the request. When I ask ChatGPT-4 to...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 25, 2023 at 8:03 pm
Sorry about that, apiEndpoint corrected, it was a typo. I am getting the same error still. 404 not found.
Is the port number required there? Thanks.
Try it without the "/"...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 25, 2023 at 4:52 pm
In the PostAsync method you're appending "/token" to the end of the HttpClient's base url which you assigned as:
string apiEndpoint = "https://helloworld.org:443/xyz/oauth2/token";
That would make the combined url...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 25, 2023 at 4:14 pm
I took the total time (10 seconds) from the time given in SSMS application. In the messages it reports the time from statistics for the first insert and then the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 23, 2023 at 6:36 pm
Can't see Jonathan's reply without a paging bump
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 23, 2023 at 5:48 pm
Viewing 15 posts - 196 through 210 (of 1,414 total)