Forum Replies Created

Viewing 15 posts - 181 through 195 (of 13,460 total)

  • Reply To: How to implement HTTP POST with an attachment (cXML file with PDF)

    i think you are targeting the wrong tool.

    you want to use an SSIS package to pull data from SQL, and let that do the HTTP post.

    SQL, by itself, does not...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 3, 2019 at 6:19 pm

    #3659903

  • Reply To: SSRS 2016/2017 design

    so the scale out deployment will distribute the reports executions out to the SSRS farm, which is great if you have lots of calls to the reports. I would expect...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 28, 2019 at 8:49 pm

    #3658590

  • Reply To: How to programmatically find all non-English values across multiple tables?

    blindly updating is not a solution, as mentioned, but you can at least review the data and make plans accordingly.

    from the metadata, this query generates the queries to compare the...

    • This reply was modified 6 years, 11 months ago by Lowell.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 21, 2019 at 9:25 pm

    #3656312

  • Reply To: Looking for Step by Step Instructions for SQL Server Loop using Powershell

    I updated my original code sample with one I have just tested. it outputs data the way i would expect now.

    I am using a stringBuilder instead of a DataTable to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 18, 2019 at 12:09 pm

    #3654712

  • Reply To: #Temporary table in query not working

    NOT IN doesn't work the way you might expect if the column tested  has any NULL values.

    you'll want to exclude them explicitly.

    WHERE SoftwareTitle NOT IN
    (SELECT Software FROM...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 16, 2019 at 1:14 am

    #3654183

  • Reply To: How do I reassign which application gets invoked?

    once assigned, i think you have to Shift + Right click, and then choose open With...

    the dialog has the option to set the default application near the bottom.

     

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 13, 2019 at 1:53 pm

    #3653252

  • Reply To: script multi instance SQL server

    you'll just need a loop that iterates per server

    the question is where the list of servers comes from, here i have an example of populating form a query, but you...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 13, 2019 at 1:38 pm

    #3653241

  • Reply To: script d'olla IN RDS

    i think you should have gone straight to the source.

    https://ola.hallengren.com/versions.html

     

    09 Apr 2018

    Added support for Linux and Amazon RDS in the job creation in MaintenanceSolution.sql.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 11, 2019 at 2:52 pm

    #3652351

  • Reply To: SQL ROW COUNT AND CTE HELP PLEASE

    look specifically at your row number function. if you are getting duplicates, identify the column that causes duplicates, and add it to the partition by of hte row_number() statement:

    Lowell
    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 11, 2019 at 2:11 pm

    #3652323

  • Reply To: How to increase the timeout against a MySQL database

    connectionstrings.com suggested a slightly different syntax, but both are valid:

    https://www.connectionstrings.com/mysql/

    Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

    Connection Timeout=5;

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 10, 2019 at 9:21 pm

    #3651967

  • Reply To: How to increase the timeout against a MySQL database

    i think you can just modify the connection string in your shared data source.

    by default, it looks something like this, just a servername and a databasename, but you can modify...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 10, 2019 at 9:18 pm

    #3651966

  • Reply To: change the color each time the name of the server changes

    it depends on what you are after. one of the most common requests is to change every  other row for readability.

    an example:

    https://www.mssqltips.com/sqlservertip/3490/alternate-row-background-color-in-sql-server-reporting-services-tablix-and-matrix/

    so in that example,the rownumber*() function needs teh...

    • This reply was modified 6 years, 11 months ago by Lowell.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 10, 2019 at 9:04 pm

    #3651963

  • Reply To: Database last used

    without access to SQL, no you cannot find out.

    if you have access to view server state, the DMV's for index stats has the last time an index was used to...

    • This reply was modified 6 years, 11 months ago by Lowell.
    • This reply was modified 6 years, 11 months ago by Lowell.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2019 at 8:39 pm

    #3651183

  • Reply To: Need some help with inserting text

    a pair of examples. if you are only looking for items that are 6 chars and start with P, vs stuffing a bunch of zeros into it no matter what...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 6, 2019 at 9:13 pm

    #3650892

  • Reply To: Changing Owner NOT dbo_Owner

    i prefer the alter authorization command:

    ALTER AUTHORIZATION ON DATABASE::[WSS_Content]  to  [MyDomain\SharePointServiceAccount];

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 4, 2019 at 7:29 pm

    #3650233

    • Viewing 15 posts - 181 through 195 (of 13,460 total)