Forum Replies Created

Viewing 7 posts - 151 through 158 (of 158 total)

  • RE: What permissions do you need to run jobs via SQL Agent?

    Can you run the job by using the Service Account that is running the SQL Agent?

    =======================================================================

    April 9, 2018 at 4:29 pm

    #1986043

  • RE: Column set to varchar(max) error

    I receive emails every time a 500 error occurs on the web server and yesterday I...

    =======================================================================

    April 7, 2018 at 9:44 pm

    #1985899

  • RE: SELECTing a hierachy


    AccountName    Level    IsCurrent      Parent

    District 1        1             0         ...

    =======================================================================

    April 7, 2018 at 2:13 pm

    #1985894

  • RE: GDPR and Business Objects

    christian 52014 - Tuesday, March 27, 2018 3:32 AM

    Unfortunately, Session_context() didn't work as I hoped to.
    I used it in a procedure, which worked...

    =======================================================================

    April 7, 2018 at 1:40 pm

    #1985892

  • RE: How To Update Multiple Conditions Using MERGE Statements

    Hi,
    Looks like you are working with slowly changing dimensions.  An alternate way is to split the MERGE statement into two, INSERT and UPDATE separately.

    --Use Merge...

    =======================================================================

    April 6, 2018 at 11:31 pm

    #1985874

  • RE: Checking sort order and fixing it

    Hi,

    ROW_NUMER()  analytical function can be used to generate a new number for each row.

    Select t.*, ROW_NUMBER () over (order by sortid)   RowNumber
    from #tblTasks...

    =======================================================================

    April 6, 2018 at 10:22 pm

    #1985872

  • RE: SQL Server 2016 Job running long

    Hi,
    Reduce the Degree of parallelism setting to 2 and give it a try.

    =======================================================================

    April 6, 2018 at 9:34 pm

    #1985871

Viewing 7 posts - 151 through 158 (of 158 total)