anything against reading the manuals? relevant information will be there - and for some of those options should you have them on a video you would likely see a biased...

it has to do with the passwords for some logins being encrypted using that cypher - so only way to allow those clients to connect is for the server to...

multiple ways - I was just giving one of the ways with an incentive to search for it and try to understand it.

and... substring vs stuff - which one is...

you missing the fact I said reverse (use twice)

without giving you the code look at functions charindex, substring and reverse(use twice) - using these 3 you will be able to get that split

google for xml path rows to column

in adittion to the above you will also need a group by for the value column

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

have a look at https://learn.microsoft.com/en-us/sql/ssma/access/sql-server-migration-assistant-for-access-accesstosql?view=sql-server-ver16

you can have your Access db working normally with the tables on a SQL Server instance.

few caveats - the tables that the tool creates is not...

SSRS in Azure Sql - not possible - Microsoft want the clients to migrate SSRS to their PowerBI Premium platform. Cheaper to just get a VM for SSRS for this...

they didn't understand the question or the question was badly put.

a Azure VM is like any other VM on prem - it allows everything you use on prem. so a...

one of your possible issues is that @DT is a datetime - if this contains anything other than the date only your query will fail as you are comparing it...

yes - and that is WHY I said to...

shrink as you see on your image. and rebuild indexes afterwards of tables that are on that filegroup.

that means bad data somewhere - so try

select field..
from tbl
where try_convert(decimal(18, 4), field) is null

to identify the "bad" data

change OrigWeight /2000 to OrigWeight /2000.0

Thank you for your response, but I am looking for a query that searches all stored procedures for the '##' sign. I can't manually check all of them we...