Perfect.  I think we may have a little work to do on the Condit but check this out.  Remember, don't think about what you want to do to a row......

I work on sql server 2012 I don't understand condition below do this condition as below

case WHEN Po.PortionKey LIKE '%[_]%' 
THEN
 SUBSTRING(Po.PortionKey, LEN(LTRIM(RTRIM(Po.PortionKey)))+1,LEN(LTRIM(RTRIM(Po.PortionKey)))) end
 as modifiedportionkey

what...

Thanks, Scott.  The readily consumable test data you provided had a couple of bugs in the CREATE TABLE statements.  For example, there is no such datatype as "NVCHAR"... that had...

Ok apologies I am new to this. On another note how do you find a tables details, like column names and data type (for example in SAS you have...

@vsamantha35

You never came back to say what you folks ended up doing nor how it worked or....

I can't speak for the others but I'd find it very interesting.  Thanks.

My goal is to get the results below. Trying to get the nearest date and result from the #Data table where the resultdate<=ProcDate. An outer apply is taking 4...

I mostly agree with Scott and Frederico on this subject... I almost always force LOBs to be out of row for a table.  I'll add that I also generally default...

partially incorrect - reading the manual helps so do read the "Create table" statement on the manuals where you may learn something.

and having (max) data inrow is in some...

Jeff, one of the best things I ever heard about comments is this:

Comments don't exist to describe what the code is doing.    They exist to describe what the...

Hi,

I've recently setup VPN on our AWS account and had my AWS bill go up by $200.  It appears that you pay for it even when nobody uses it. ...

Shifting gears back to the function that was used, I've added a smidgen of additional bullet-proofing.

 CREATE OR ALTER FUNCTION dbo.ufnStringToPbase
      ...

I have a Visual Studio project web site that I have been using for years. The move to SQL server 2019, has apparently broken it.

When I call the dataadapter.Fill...

As you said in your original post...

The move to SQL server 2019, has apparently broken it.

The reason the move broke it is now obvious... the function lived in the master...

Not only some representative data along with the expected output but how about a description of what the function is supposed to do, please.

I would also get into the habit...

What IS the limit you're trying to set it to, how many files does it have, and how big is your largest table/index?