Viewing 15 posts - 616 through 630 (of 2,917 total)
I agree with ZZartin, there is no left join in that query... I don't see any joins...
Now, that being said, execution plan is going to be your friend for performance...
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.
April 6, 2022 at 10:40 pm
I just wanted to add in that I am not a big fan of the "SELECT * INTO" approach to table creation. It recreates the table, but only the bare...
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.
April 5, 2022 at 2:56 pm
My guess - you got a bad download. I would try re-downloading it and give it another shot. Failing that, I would guess that something is blocking some downloads for...
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.
April 5, 2022 at 2:23 pm
Your syntax is wrong for SQL Server. You can't use SELECT in a CREATE TABLE statement. I recommend you review the documentation from Microsoft on CREATE TABLE syntax (https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver15) and...
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.
April 5, 2022 at 2:13 pm
Without seeing your data or table structures, my best guess is one of the following:
1 - your data is unordered - that is you are not putting in an "ORDER...
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 24, 2022 at 10:05 pm
The error message is telling you EXACTLY what is wrong - the path was not found.
Looking at your code, there are a few things that I am a little confused...
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 23, 2022 at 2:15 pm
Personally, I think that sounds like a lot to work on, but I am hoping that you do get some interest in it. One concern an end user may have...
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, 2022 at 4:38 pm
Personally, I wouldn't put the GPX file on there. I have never looked at those, but I have a feeling that it contains GPS data in there. People could use...
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 21, 2022 at 9:52 pm
I agree with TangoVictor on this one - I would be looking to have the business sanitize the data before allowing it to be handled by SSIS. one user puts...
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 21, 2022 at 9:28 pm
What I would strongly recommend to get good results on this forum is:
1 - post DDL in a consumable format such as:
CREATE TABLE sample (JSONData NVARCHAR(MAX))
2 -...
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 21, 2022 at 9:18 pm
I agree with Homebrew01 here - I would do this in a table. That way the logic is EASY to update in the event your fiscal year changes. You MAY...
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 21, 2022 at 9:11 pm
To add to what Jeff said - I got my DBA (Jr. DBA at the time) job with no degree or any certs. I got some certs after getting 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 21, 2022 at 5:48 pm
My approach was to get certified in the tool I was going to be supporting - Microsoft SQL Server. I started my training at Ucertify which I liked as it...
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 21, 2022 at 4:05 pm
I am 99% sure that that is a limitation of HTML. Can you imagine the headache if you clicked on a single link and 100 web pages popped open you? ...
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, 2022 at 5:32 pm
My opinion - this should be solved at the presentation layer, but you also have some data issues. First, I'd fix the data issues - your RCLTIM column is a...
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, 2022 at 5:29 pm
Viewing 15 posts - 616 through 630 (of 2,917 total)