One way to generalize the...

Ok the set up and explanation are appreciated.  Right off the bat tho there's an issue (which is hopefully a typo) with the sample data.  In the #tbl_transection table in...

Keep at it you're on the right track.  Your query doesn't seem to return any error so what's the question?  What's Wrong Output and Correct Output seems...

It appears the math in your example calculation is off (by 300.00) beginning on line 3: instead of 21.37 should it not be 321.37?

select 21.37 + (11033.21)...

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

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

Well I came up with pretty much the identical query.  Joining the rows back together using the array keys seems unavoidable.  In SQL Server...

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