you will need to find your model either someowhere on the outside or potentially by using a tool like cpu-z which can sometimes identify what it it.

see https://www.hp.com/sg-en/shop/tech-takes/post/how-to-find-hp-laptop-model-number#:~:text=The%20most%20common%20location%20to,or%20behind%20an%20access%20panel. for some...

that's because you failed to understand what you are doing on your powershell script.

Insert into dbastuff.dbo.Tbl_Alerts

SELECT '$Capuretbl',Max(DateStored) FROM [$($Row[0])]"

you are surrounding the contents with square brackets - so the table...

what is the definition of the clustered index. My guess is that it includes "DraftNum " as one of its columns.

this based on the definition of a non clustered key.

from...

you need to use pastetheplan - loading the file fails

if you still have the old laptop you could use it to run SQL on its own - and have your app on your new laptop connect to it through...

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 3 years, 4 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...