Viewing 15 posts - 1,306 through 1,320 (of 2,917 total)
I personally don't know MySQL, but I think it really depends. To change the order of the columns, you change the order of them in your SELECT. For example, if...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 22, 2021 at 9:25 pm
I like Jeff's approach here, but my preference when moving large amounts of data from table A to table B on a different database is to do it outside of...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 22, 2021 at 8:26 pm
I do not know of any forum similar to this for MySQL. I do not use MySQL myself.
But I think your query for the most part should translate between the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 19, 2021 at 9:35 pm
The worst part about the tools is licensing. That is such a pain in the butt. MSDN (visual studio subscription I think is the new name) is a GREAT example...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 19, 2021 at 9:31 pm
So that is progress, but still 2 issues. First - there is no sample data. Second - that is not Microsoft SQL Server code.
But, from looking at what you posted,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 19, 2021 at 6:57 pm
My approach, looking at it, you are wanting all rows where there is an IN followed by a SOLD.
For a start with your WHERE clause, filter out all rows where...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 19, 2021 at 5:59 pm
If it is in an SSIS package (ie the job step calls an SSIS package and is NOT calling direct TSQL), you should have no issues as the SSIS package...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 19, 2021 at 3:45 pm
If memory serves, they will not show and will need to be re-created. This is easy to do if the old server is still online and you know which jobs...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 19, 2021 at 3:36 pm
From reading the error, it sounds like it is telling you exactly what is wrong - you are sending an NVARCHAR datatype and it requires a VARCHAR datatype.
Not 100% certain...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 19, 2021 at 3:34 pm
First, I could be mistaken, but that does not look like SQL Server code. Is that MySQL or PostgreSQL?
Secondly, that screenshot is not "consumable" by us.
Third, the screenshot only shows...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 18, 2021 at 9:31 pm
It is as ratbak says, excel files don't help us. We have no easy way to take an Excel file and create temp tables from it. Plus, the excel file...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 18, 2021 at 8:10 pm
If you provide some DDL and sample data, I'm sure someone can help. With what you provided (excel not tested as that is always risky), we have no way to...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 18, 2021 at 6:15 pm
Not sure then. On my system, I have SSRS 2016 running on SQL Server 2016. If memory serves, SSRS 2016 has its own web host and doesn't rely on IIS...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 18, 2021 at 6:10 pm
Quick read of the documentation, for an XFS filesystem, it seems you can SET the block size larger, but the kernel will only let you mount it if the partition...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 17, 2021 at 10:10 pm
I am not an expert on this, but my understanding is that it is recommended.
Same thing in windows, it isn't that you HAVE to set it to 64k, it just...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 17, 2021 at 5:07 pm
Viewing 15 posts - 1,306 through 1,320 (of 2,917 total)