regardless of other items, there is one thing you do need to confirm - is the HOST set to have cpu at full power all the time (or not) and...

CTE is defined BEFORE any of the remaining sql.

with cte1 as (select ...), cte2 as (select ...), cte3 as (select ...)
select *
from table f
inner join cte1 on...

neither does it deal with scientific values where the whole string IS the value

declare @String varchar(30)
select @String = '1E02'
select 
 try_convert(float, @string)
,case 
when ISNUMERIC(@String) = 0 then...

while this looks like spam post I'll give it a go in case it isn't.

you should first read the manuals for triggers in sql server to fully understand how...

in my shop all instances are created using a powershell script - with defaults set for everything and potentially override...

the last " is not null or " gets removed from the output which is as per design e.g. the separator is only added if there is a string to...

• This reply was modified 3 years, 5 months ago by frederico_fonseca.

then something you doing not exactly as it is.

I've tried your sql just replacing your function with sys.columns from master db and it works as expected with a total of...

elaborate on ssms limits? have a look at https://stackoverflow.com/questions/64704240/ssms-what-is-the-max-string-size-that-can-be-displayed-in-the-grid-for-varchar

and did you try what I said?

if by not working you mean its not displaying it on SSMS that is "right" - SSMS will not display the full content.

if you wish to see all its content...

smells like the usual lambda spam of "i got this" with a link

if the initial string has no spaces you can use a combination of charindex and substring - you should be able to built something with these 2 functions without the...

Instead of enabling both successful and failed logins - you can configure an audit instead.  The audit can also send the data to the application event log - but...

from what is defined on this manual (you did read it didn't you?) it will not add entries to the log - furthermore you need to explicitly set CDC...

on a diff note - might be good to start looking at options to replace reportviewer (and SSRS altogether) as .net core does not, and according to ms, will not,...

you are mixing serverreport with localreport and I think that is your issue.

from https://learn.microsoft.com/en-us/sql/reporting-services/application-integration/using-the-winforms-reportviewer-control?source=recommendations&view=sql-server-ver16

you can see on the local report mode that the parameter is added to the local report...