Viewing 15 posts - 1,366 through 1,380 (of 2,917 total)
If you NEED to do this in SSIS, I think you are going to need a for each loop (or similar).
If you can do this on the TSQL side 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.
March 2, 2021 at 9:32 pm
I agree with ScottPletcher here that there is little value in that sort of assessment and there is a LOT of things that can impact it. If your table has...
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 2, 2021 at 9:19 pm
Was just reviewing the execution plan, and my thoughts are (experts feel free to tell me I'm wrong here):
1 - the "SELECT(COUNT()...)" statements are checking if the result is less...
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 2, 2021 at 4:46 pm
Kristen,
In your scenario, I am not sure service broker is the route I would go either. The biggest part that would make me use a different solution is that there...
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 2, 2021 at 1:58 pm
Hello Kristen. To address your concerns, messages very rarely fail to send. For a message to fail sending, pretty much the only cases I can think of are that 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 1, 2021 at 7:49 pm
One way would be to use a test environment (so you don't break any production data) and run all of the stored procedures and see which ones give a data...
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.
February 26, 2021 at 4:15 pm
Happy to help. I am just glad you were on 2017 or newer as otherwise that STRING_AGG function wouldn't have worked and we'd have needed to get more creative.
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.
February 25, 2021 at 8:04 pm
Sorry about that. Did not realize the order was important.
But that is just as easy to handle:
SELECT [Quarters]
, [Function]
, [Product]
, [Manager]
, string_agg(GM ,';...
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.
February 25, 2021 at 7:37 pm
This is pretty easy to do actually since you are on 2017!
Check this out:
SELECT [Quarters]
, [Function]
, [Product]
, [Manager]
, STRING_AGG([GM] ,'; ') AS [GM...
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.
February 25, 2021 at 7:03 pm
I personally don't see it being a problem having 1000's of messages being sent at once. I would still send them on a single conversation. The advantage to that 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.
February 25, 2021 at 4:39 pm
As a thought, what about if you switched C1 to be an IDENTITY value or a SEQUENCE or a calculated column and not insert it via a stored procedure but...
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.
February 24, 2021 at 10:00 pm
My opinion, this is a good use of service broker. We have a VERY similar thing happening on our systems, but it is a 2-way thing with service broker. Server...
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.
February 24, 2021 at 9:13 pm
My recommendation is going to still be get a monitoring tool.
If that is not an option, you are going to need a linked server or SSIS or something in place...
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.
February 24, 2021 at 8:39 pm
If this was my task, I would buy an ERP rather than reinvent the wheel.
If you need to do this strictly in SQL, you would need to know the "max...
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.
February 24, 2021 at 4:55 pm
Might be a dumb question, but does that need to be dynamic SQL?
My thoughts here are to take your last 2 IF statements and have them assign a value 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.
February 24, 2021 at 2:01 pm
Viewing 15 posts - 1,366 through 1,380 (of 2,917 total)