Viewing 15 posts - 691 through 705 (of 13,838 total)
Thank you
@JDate is getdate, i dont need that I have j_date that contains data, so pretty much this field j_date need format as mm/dd/yyyy
I get that. Just substitute your...
December 7, 2023 at 6:45 pm
Added local variables to make the code work in isolation. Your best bet is to output as a string:
DECLARE @J1 INT = 1;
DECLARE @JDate DATETIME = GETDATE...
December 7, 2023 at 3:55 pm
Do you have any other local drives with available space?
December 7, 2023 at 1:01 pm
Does the schema of the Access DB also change much?
If not, it would be better, in my opinion, to build a process to refresh the data in your SQL Server...
December 7, 2023 at 11:04 am
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
Viewing 15 posts - 691 through 705 (of 13,838 total)