Viewing 15 posts - 946 through 960 (of 6,676 total)
On the server where the package is running.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 6:23 pm
If you get the same message, then the driver isn't installed on the server. Install the 74 bit driver.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 6:14 pm
Any triggers that could be rolling back the transaction?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 6:07 pm
The message is pretty clear - the OLE DB provider the package requires is not registered on the server. When you develop on your workstation you are developing using a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 6:03 pm
I would re-evaluate the code and remove any redundancy where possible. For example, I often see someone perform an insert into a table (often a temp table) followed by multiple...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 5:57 pm
Instead of using LEAD or LAG you could use MIN/MAX/FIRST_VALUE/LAST_VALUE depending on requirements. Or - you could define a default value to all null values.
Which one you use depends on...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 5:45 pm
Does this work?
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.DBMail.html
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 5:41 pm
And last but not least, thank you for your unabashed comment on the certs. I could go on a tear about them but I'll just leave it at that....
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 5:35 pm
Yes - please show the full script/procedure. This can and will help someone else and will be a good contribution to the community.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 4:53 pm
Small change - you need to use this:
--==== Build the table data and return in the xmlResults variable
Declare @columnList varchar(max) = cast((Select concat(', coalesce(sum(Case When ft.Entity...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 4:24 pm
There were a couple of small mistakes in the header code I posted - here is the updated version:
--==== Create the table header
Select @tableHeader =...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 3:39 pm
If by row total - you mean an additional column at the end, then please review the thread I linked to in a previous message. That code adds a totals...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2021 at 2:54 am
This should get you close - you still need to build the rest of the HTML code but that all exists in the examples I linked to.
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 24, 2021 at 9:39 pm
I looked at your earlier attempt - which doesn't look anything like the cross-tab examples. Since you have not provided data in a consumable format (create/insert statements) it is really...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 24, 2021 at 3:30 pm
Yes - the totals are calculated using grouping statements and the pivot is done using FOR XML. Or - you can pivot the data into a temp table and dynamically...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 24, 2021 at 1:53 pm
Viewing 15 posts - 946 through 960 (of 6,676 total)