Forum Replies Created

Viewing 15 posts - 2,926 through 2,940 (of 5,109 total)

  • RE: Compare two columns

    TheCTEGuy - Monday, October 9, 2017 8:00 AM

    Don't know if this suffice the requirement. Below code is efficient than the above
    [code...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: expecting ID or quoted_ID. Help!

    What do you mean by "isn't reportable"? What's wrong with it?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: expecting ID or quoted_ID. Help!

    The syntax "USE @DatabaseName" isn't valid. You can't provide a variable as part of a statement, you'll need to use dynamic SQL.

    Considering, however, that you're doing...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Long-running script with IE11

    DatabaseQueryTimeout is a setting in your SSRS config file, as I stated in my 1st reply. Sounds like that is still set to 120. Like I said before, check...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Long-running script with IE11

    Could you have a look at the SSRS logs, see if it's showing anything in there in regards to your report.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Long-running script with IE11

    zouhair.ouichdani - Monday, October 9, 2017 6:33 AM

    From report server when I launch report builder to open the report and execute it,it...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Long-running script with IE11

    zouhair.ouichdani - Monday, October 9, 2017 6:11 AM

    Hi Thom,
    Thank you for your prompt reply.
    Regarding the Report timeout it's already set to 3600...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Query Help with 2 tables

    Without consumable sample data or DDL, this is a guess and untested, however, maybe:
    SELECT s.AILMENT_NAME, AAs.[Status]
    FROM tblAILMENT A
      JOIN tblASSESSMENT-AILMENT AA ON A.AILMENT_ID =...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Query Help with 2 tables

    Thanks for the edits. I've editted my post a couple of times, but you won't get a subscription for those so I'm posting again. Have a look at my comments...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Query Help with 2 tables

    What is your question here? You haven't asked one. Questions end with a Question Mark (?), where as you have simply made a statement that you want to use a...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Long-running script with IE11

    The problem isn't IE11, it's that your SSRS instance is set to time out the query after 2 minutes. As your report is taking more than 2 minute to run...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: How to troubleshoot this database update or insert schedule scenraio?

    We are missing a lot of information here. We don't have any details on what your DDL looks like at either end, or what the query being used is to...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: problem with sa account after cloning server

    The guide explains how to force the type of application can connect. Also, note that if you're in Single User, do not expand any of the menus, just open a...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: problem with sa account after cloning server

    motif - Sunday, October 8, 2017 1:03 PM

    By sysadmin I meant local comp admin, maybe I was not clear - output...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: problem with sa account after cloning server

    urban.robert - Sunday, October 8, 2017 12:18 PM

    you didn't read what I have posted with understanding. Of course I have full...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 2,926 through 2,940 (of 5,109 total)