Viewing 15 posts - 106 through 120 (of 13,838 total)
Hello,
I have tried various methods to accomplish this using functions like PATINDEX, DIFFERENCE, and the Levenshtein Distance function, but I haven't been successful.
I have two columns of type VARCHAR, and I...
February 20, 2025 at 5:21 pm
Can you confirm you have downloaded and installed version 1.5 of Microsoft.DataTools.IntegrationServices.exe?
It should appear in your Programs and Features list. Also, have you rebooted since installing?
February 19, 2025 at 2:58 pm
Although it does not directly address your question, my suggestion would be that you learn how to use Tabular Editor (link) rather than VS to modify your tabular models....
February 18, 2025 at 1:45 pm
Here is one way. There may be more elegant ways, but I'm short on coffee at the moment.
February 18, 2025 at 9:55 am
Why have you posted a random query? Please ask a question.
February 12, 2025 at 6:11 pm
Can you somehow modify the process to make it incremental, or are all the rows always new?
If you have space, perhaps you could try running the insert to a staging...
February 11, 2025 at 4:30 pm
Want to acomplish all calculations in a few minutes.
That's a requirement, not a question.
Why don't you start by presenting what you have tried so far, along with your findings?
February 9, 2025 at 4:16 pm
WITH MyCTE AS (
SELECT Unit, ORDER_DATE, row_number() over (partition by unit order by ORDER_DATE desc) as RowNum
FROM #TEST_TABLE)
SELECT Unit, Order_date
FROM MyCTE
WHERE RowNum = 2;
This does not...
February 9, 2025 at 4:14 pm
WITH ordered
AS (SELECT UNIT
,ORDER_DATE
,rn1 = ROW_NUMBER ()...
February 9, 2025 at 11:56 am
Assuming you're trying to move away from a self-hosted model, there is a halfway house. We have found that Azure DBs (ie, DB as a service) are extremely expensive if...
February 7, 2025 at 8:48 am
SQL server became slow before I ran exec sp_updatestats
Is this a blog post, or are you hoping for a response?
February 7, 2025 at 8:37 am
What is your question?
February 7, 2025 at 8:35 am
A SSAS model is called a Semantic Model in Azure:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand
February 6, 2025 at 4:06 pm
Did you do any research before posting your questions?
February 6, 2025 at 4:03 pm
Hi we know (or believe) ssas saas gets stood up separately when a company migrates to sql saas.
But what happens to ssis and ssrs? from what i remember there...
February 6, 2025 at 4:00 pm
Viewing 15 posts - 106 through 120 (of 13,838 total)