Viewing 15 posts - 721 through 735 (of 2,649 total)
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
October 31, 2022 at 6:03 pm
google for xml path rows to column
in adittion to the above you will also need a group by for the value column
October 28, 2022 at 2:43 pm
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...
October 27, 2022 at 11:08 pm
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...
October 25, 2022 at 8:22 pm
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...
October 25, 2022 at 5:33 pm
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...
October 23, 2022 at 11:11 am
Will shrinking the filegroup this way cause fragmentation issues? I just want to know the safest way to do it.
Thank you.
yes - and that is WHY I said to...
October 21, 2022 at 4:45 pm
shrink as you see on your image. and rebuild indexes afterwards of tables that are on that filegroup.
October 21, 2022 at 4:14 pm
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
October 20, 2022 at 8:56 pm
change OrigWeight /2000 to OrigWeight /2000.0
October 20, 2022 at 7:03 pm
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...
October 20, 2022 at 6:58 pm
you likely missing a step on your initial setup of the catalog - or you aren't using parameters on your packages correctly.
have a look at https://www.sqlservercentral.com/steps/ssis-catalog-environments-step-20-of-the-stairway-to-integration-services - step by step...
October 19, 2022 at 9:42 pm
There are a number of restrictions and possible gotchas with filtered indexes. In theory they are great, in practice they can be difficult.
would you care to explain...
October 18, 2022 at 8:05 pm
There are a number of restrictions and possible gotchas with filtered indexes. In theory they are great, in practice they can be difficult.
would you care to explain exactly which...
October 18, 2022 at 6:10 pm
can you post the table DDL (including indexes/PK) and explain the process of inserting and updating this table BEFORE you try to do the update above.
what you say above looks...
October 18, 2022 at 7:37 am
Viewing 15 posts - 721 through 735 (of 2,649 total)