Viewing 15 posts - 151 through 165 (of 13,876 total)
I was asking about a subquery, not a view or a where exists.
That wasn't clear, given that the first two sentences of your original post were this:
Is there any circumstances...
February 24, 2025 at 3:29 pm
You don't mention the error you are getting, but I think you might have missed a bit of syntax:
CREATE FUNCTION LoafIngredientCostsOverTime
(
@StartDate DATE =...
February 24, 2025 at 9:02 am
thx morgan3445. there is no edit dax button in the properties pane of my sales table.
The Morgan3445 post contained a spammy link, so I reported it.
February 22, 2025 at 1:40 pm
Have a look at this. I used a temp table & added a PK for fun.
DROP TABLE IF EXISTS #temptable
CREATE TABLE #temptable
(
SomePK INT...
February 20, 2025 at 5:32 pm
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
Viewing 15 posts - 151 through 165 (of 13,876 total)