Viewing 15 posts - 181 through 195 (of 1,396 total)
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...
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...
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...
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
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...
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...
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 "/"...
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...
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...
June 23, 2023 at 6:36 pm
Can't see Jonathan's reply without a paging bump
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...
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...
June 21, 2023 at 7:25 pm
@steve-2 Collins,
Sorry... I tried your latest code on a max value of "just" 1 million. I stopped it at 2 hours and 8 minutes.
Well that's disappointing. Could it be...
June 20, 2023 at 7:52 pm
Ok... I'm a little gobsmacked... I ran your code with zero changes and it's riddled with syntax errors and,yet, it ran without error.
What is the following supposed to do...
June 20, 2023 at 3:52 pm
The doubled-up relational symbology isn't floating my boat on an SQL Server forum, either.
There are functions also as I'm sure you're already aware
June 20, 2023 at 3:13 pm
Viewing 15 posts - 181 through 195 (of 1,396 total)