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,...

• This reply was modified 1 year, 2 months ago by  Steve Collins. Reason: Renamed CTE to more clearly reflect its purpose

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...

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...

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...

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...

Yes imo you've got the right ideas unpivot and re-pivot is what's...

DENSE_RANK is the better solution in this case though.  Good on Drew it's another interesting one

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...

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...

Try it without the "/"...

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...

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...

Can't see Jonathan's reply without a paging bump

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...

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...

• This reply was modified 1 year, 5 months ago by  Steve Collins.
• This reply was modified 1 year, 5 months ago by  Steve Collins.
• This reply was modified 1 year, 5 months ago by  Steve Collins.