Viewing 15 posts - 196 through 210 (of 1,413 total)
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
I just improved the process a bit. You can use GENERATE_SERIES to specify the multiples of the prime that you want to delete. Also, another thing I learnt today...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 23, 2023 at 5:12 pm
Here's another non improvement over other methods afaik. In theory this one seemed to hold a lot of promise imo. When I gave it to ChatGPT to craft an explanation...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 21, 2023 at 7:25 pm
Viewing 15 posts - 196 through 210 (of 1,413 total)