Viewing 15 posts - 706 through 720 (of 13,849 total)
A correct validation will be of great help to you.
Please explain why.
December 7, 2023 at 8:37 am
Good job providing the table DDL and desired results. All you need to do now is give us the associated INSERT statements which generate the test data to populate the...
December 5, 2023 at 9:16 am
Apparently I WAS WRONG.
I'm framing this! 🙂
December 4, 2023 at 8:38 am
OK, that is good news.
In VS, take the following option:
Tools/SQL Server/New Schema Comparison
This will allow you to select your source database (local) and target (Docker version) and will then compare...
December 3, 2023 at 6:03 pm
Forgive my lack of Docker knowledge – I've never used it. How do you connect to your database from outside of Docker? Can you connect to it from VS?
December 3, 2023 at 5:21 pm
Hello @phil-parkin
Not the seem the output is different
But the question is the same!
November 30, 2023 at 2:03 pm
Hello @phil-parkin
Thanks for your help.
Your solution resolve the problem with the sample that i give but i executed with other data i got some wrong result
Perfect, thank you. That...
November 30, 2023 at 9:24 am
This seems to be the same question as https://www.sqlservercentral.com/forums/topic/t-sql-slicing-status-by-related-time-periods-and-other-status
Why did you create it again?
November 30, 2023 at 9:22 am
If you are familiar with PowerQuery, another possibility would be to create another spreadsheet which consumes the data from the original spreadsheet and does some manipulation in the process. Your...
November 29, 2023 at 3:38 pm
UPDATE MM2WO
SET sDesc = TRANSLATE(sDesc, '&<!>!-=', ' ')
WHERE ...https://learn.microsoft.com/en-us/sql/t-sql/functions/translate-transact-sql?view=sql-server-ver16
TRANSLATE not available in 2016.
November 28, 2023 at 7:04 pm
Jeff - that's what I am doing now, just using Replace(). I wanted to know if there was a better way to do it and so far it looks...
November 28, 2023 at 9:35 am
Neat solution, but I disagree with this comment:
it happens often that you need to save a list of single values/parameters that are valid, temporarily or stably, for the whole application.
In...
November 27, 2023 at 11:11 am
It's an ungainly piece of code, but I think it gets the right results.
SELECT ssh.id
,ssh.OrderNumber
,ssh.RelayPoint
...
November 25, 2023 at 11:43 am
Sorry to keep modifying this response. It's taken me a while to formulate a question I am happy with.
In your sample results, we see XN78/980.
The latest row for this combination...
November 23, 2023 at 1:26 pm
Yes it should be possible.
(condition 1) && (condition 2)
November 21, 2023 at 9:28 am
Viewing 15 posts - 706 through 720 (of 13,849 total)