Viewing 15 posts - 2,176 through 2,190 (of 2,919 total)
Sorry for the delayed response, but that is the method I would use. Basically exactly the code you have.
Then before you do the delete, do a quick check to make...
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.
July 22, 2019 at 7:29 pm
You would need the same logic in your delete. Your insert and delete logic should be the same or you will either insert data that isn't deleted (resulting in duplicate...
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.
July 11, 2019 at 5:26 pm
Can you have duplicate OperatorID's in the Transaction table?
try running the following query on the Transaction table:
WITH duplicateCheck AS
(
SELECT OperatorID, count(OperatorID) OVER (PARTITION BY OperatorID) AS OperatorCount
FROM...
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.
July 9, 2019 at 7:57 pm
I still see that link taking me to an article about Data Compression Double Take which seems different than SQL and T-SQL for Beginners or is that where it is...
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.
July 8, 2019 at 5:37 pm
With the sample hourly rate being 10,000, I was just trying to make sure I picked a value that was substantially large enough to cover almost everything possible in 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.
July 5, 2019 at 4:21 pm
Do you need this to be "real time" data or can you load the data into some system (Hadoop, SQL Server, Oracle, etc) on a nightly basis?
I am not 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.
July 5, 2019 at 2:54 pm
I would not recommend putting an excel file on here. Not many people will nab that as there is inherit risk of downloading random files from the internet...
I would 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.
July 4, 2019 at 7:05 pm
I think all you need to do is change how it is formatting the cell. When I paste that in with a straight paste (no paste special or anything like...
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.
July 4, 2019 at 6:59 pm
Without seeing the data or having any idea of what things look like, what I would do is something like this for your case statement:
CASE
...
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.
July 4, 2019 at 6:51 pm
I think the link in the OP points to the wrong post?
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.
July 4, 2019 at 6:43 pm
The problem with trying to manage 1,2,3 as well as a,b,c is what happens when you hit 1,a,1? One solution could be to just sign each letter a numeric value...
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.
June 28, 2019 at 11:19 pm
I see a few things that will make this tricky. The first being that the datetime column has no time. So how do you know that m5 went from 3...
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.
June 28, 2019 at 6:50 pm
With them being physical disks, I think that setup looks like it should be good.
Your next question about the types of disk (SSD or Other) and RAID, that really depends...
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.
June 27, 2019 at 3:29 pm
Are your disks on a SAN or physically attached to the machine?
SAN disks in a good SAN should be set up in RAID by the SAN controller and should be...
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.
June 26, 2019 at 10:03 pm
If you do go the SSIS route, there are a few things to watch out for:
SSIS will...
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.
June 26, 2019 at 6:07 pm
Viewing 15 posts - 2,176 through 2,190 (of 2,919 total)