Viewing 15 posts - 766 through 780 (of 2,693 total)
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
your inner query has a column (status) that is not on the group by - so you need to build your query differently
on this particular case and because you are...
October 17, 2022 at 6:21 am
Viewing 15 posts - 766 through 780 (of 2,693 total)