Viewing 15 posts - 2,026 through 2,040 (of 2,917 total)
That is strange. Generally, that error is accompanied by some other messages. You checked both SQL instances for error messages and that is the only error message you see? Not...
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 20, 2020 at 7:29 pm
Any other errors in the log? I imagine you are getting some error prior to that one which may help in troubleshooting and pointing you in the correct direction...
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 20, 2020 at 5:33 pm
DEFINITELY not an ideal solution, but works with the sample data (plus an extra a ways in the future). It assumes the documentID is the order in which documents arrived,...
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 20, 2020 at 5:28 pm
Nice easy question that I actually got hit with recently. Code that had been running live for 11 years, someone reported it was missing a column. Went digging and saw...
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 20, 2020 at 2:40 pm
But from my limited testing, I think that having multiple stored procedures (one for each possible scenario and one "master" one that is used to call one of the others)...
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 17, 2020 at 9:15 pm
As a thought, rather than handling this in SQL, could you handle this in your import or export tool? Instead of having multiple "footer" fields, could you concat them before...
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 17, 2020 at 8:44 pm
Ok, so to sort it how you want, I think this should work:
SELECT CATEGORY_DESCRIPTION
,JANUARY
,FEBRUARY
,MARCH
,APRIL
,MAY
,JUNE
,JULY
,AUGUST
,SEPTEMBER
,OCTOBER
,NOVEMBER
,DECEMBER
,AVERAGE
,STD_DEV
,STDDEV_1_POS
,STDDEV_2,POS
,STDDEV_3_POS
,STDDEV_1_NEG
,STDDEV_2_NEG
,STDDEV_3_NEG
FROM (
SELECT PARENT
,CATEGORY_DESCRIPTION AS CATEGORY_DESCRIPTION
,SUM(JANUARY) AS JANUARY
,SUM(FEBRUARY) AS FEBRUARY
,SUM(MARCH) AS MARCH
,SUM(APRIL) AS APRIL
,SUM(MAY) AS...
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 17, 2020 at 7:26 pm
Well, the order is likely going to be unreliable anyway as you have no order by clause in there. If you need it in a specific order, you will need...
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 17, 2020 at 6:51 pm
Is the vendor tool dropping the indexes OR are you dropping them?
If it is you, why not disable them and then rebuild rather than dropping and recreating?
Do you need 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.
April 17, 2020 at 6:44 pm
I agree with frederico_fonseca, this should work. I see no reason why that stored procedure wouldn't work unless you need it to create all of the indexes dynamically in which...
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 17, 2020 at 5:10 pm
What error are you getting in your backups? That error message will be the best way to tell what is wrong...
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 17, 2020 at 5:04 pm
scdecade - will that not fail still if columns don't exist (ie footnote3 may not exist)? I just did a test on that and, like my solution, SQL sees "footnote3"...
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 17, 2020 at 4:19 pm
As a thought... if you disable the writing to destination step of the SSIS package, do you get errors still?
I am wondering if MAYBE the problem is on the destination...
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 17, 2020 at 4:10 pm
I am not 100% sure if IF statements would handle that better or not. Been a while since I tried it. Just tried it and it does not work. So...
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 17, 2020 at 4:03 pm
My bad... didn't see the attachment. Sorry about that.
Looking through it now and will let you know if I see something to do what you need.
EDIT - your attached script...
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 17, 2020 at 3:33 pm
Viewing 15 posts - 2,026 through 2,040 (of 2,917 total)