if copying from SSMS you can also go to tools->options->Query Results->SQL Server->Results to Grid and tick option "Retail CR/LF on copy or save"

4GB is way way too low for anything that includes SQL Server and other software running on same pc.

on a new laptop I would not have chosen anything with less...

all your sys.... tables are specific to the database you run this code on.

do do what you need you either use full dynamic sql (where you add "use [@DatabaseName]" before...

• This reply was modified 2 years, 8 months ago by frederico_fonseca.

based on what the OP said above it is "rate of return" - can be done in SQL but not quite as presented above on the example.

https://towardsdatascience.com/calculating-internal-rate-of-return-irr-in-bigquery-75e6703e8ec3 or https://social.msdn.microsoft.com/Forums/sqlserver/en-US/868f5c56-bb32-4e8b-975b-ba72710c2215/using-sql-to-calculate-the-irr?forum=transactsql

can you give us the original unchanged Excel formula - if it is made up of multiple steps ask your analyst to aggregate it into one, and then give the...

what exactly are  you trying to calculate? would be good if you could supply the original required formula as well as the english instructions of what it is its intention.

the...

sorry too busy at work.

Regarding plan - can you get an ACTUAL explain plan? the one supplied is just an estimated one which does not necessarily reflect the actual execution.

but...

this looks like a CRM style app - likely doing queries on single entities each time, likely using views on top of views to implement things like row security based...

that is just a normal where clause you would add as in any other case.

where p.x <> 0 or p.y <> 0 -- this processes the row if either has...

simple outer apply is the better option I think

select p.CustNo
     , amt.ExpenseType
     , amt.Amount
from #p p
outer apply (select 1...

it keeps surprising me that people still build stuff that is supposed to run on a server, were Excel/Office is neither licensed neither supported, and expect everything to work fine.

or...

any of the SQL Clients allows you to setup a command execution timeout - that is for the full execution of either a single query or the whole of a...

as per manuals you can upgrade to either - 2022 has significant functionality which would make it the desired target for me.

don't you you can find it elsewhere if it does not show on those dm views.

another thing you will not catch with those is tables used within dynamic sql. this...

for anything being kicked off by the users against the server the user will require access to the server and to the database - access can be restricted to exactly...