Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 5,109 total)

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson - Saturday, October 14, 2017 7:31 AM

    Phil Parkin - Saturday, October 14, 2017 7:24 AM

    Thom~

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

    October 14, 2017 at 7:40 am

    #1963686

  • RE: SSRS Chart Custom Colors by Category Group

    In all honesty, I'm not sure you can for your current set up. I notice that some of the bars are the same colour in the P and E columns,...

    Thom~

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

    October 14, 2017 at 3:43 am

    #1963680

  • RE: Are the posted questions getting worse?

    Ed Wagner - Friday, October 13, 2017 1:46 PM

    Thom A - Friday, October 13, 2017 11:00 AM

    Thom~

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

    October 14, 2017 at 2:41 am

    #1963679

  • RE: TSQL help on strings

    Luis Cazares - Friday, October 13, 2017 1:49 PM

    Actually, I think that the solution is something as the one presented here:

    Thom~

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

    October 14, 2017 at 2:41 am

    #1963678

  • RE: calculation

    Also, for the values you have supplied, what is the expected value for your expression? The TotalValue is 4,944 for the sample data and expression you've supplied, which doesn't match...

    Thom~

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

    October 14, 2017 at 2:20 am

    #1963677

  • RE: calculation

    adisql - Friday, October 13, 2017 8:56 PM

    Thank you for the response.
    Here are the sample data of these three columns.

    Thom~

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

    October 14, 2017 at 2:14 am

    #1963676

  • RE: Are the posted questions getting worse?

    Luis Cazares - Friday, October 13, 2017 1:57 PM

    I'm all set to start my birthday weekend in New Orleans. Any recommendations for...

    Thom~

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

    October 14, 2017 at 1:55 am

    #1963675

  • RE: TSQL help on strings

    Have a look at rtrim and ltrim, or just trim if you're on SQL 2017.

    Thom~

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

    October 13, 2017 at 1:31 pm

    #1963636

  • RE: Are the posted questions getting worse?

    Good! We're meant to be migrating our main 3rd party server over tomorrow, but thought I'd check just before the end of day that everything was ready. New server has...

    Thom~

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

    October 13, 2017 at 11:00 am

    #1963618

  • RE: Get the SSIS Package names from database

    What deployment method have you used. MSDB, SSISDB or file system (I really hope not the latter!).

    If SSISDB, try:
    USE SSISDB;
    GO
    SELECT p.name AS ProjectName,...

    Thom~

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

    October 13, 2017 at 9:45 am

    #1963599

  • RE: Are the posted questions getting worse?

    Phil Parkin - Friday, October 13, 2017 9:28 AM

    Thom A - Friday, October 13, 2017 9:20 AM

    Thom~

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

    October 13, 2017 at 9:36 am

    #1963594

  • RE: User Not able to access Schema owned tables

    ksr39 - Friday, October 13, 2017 9:09 AM

    Hi Thom,
    yes the user is in an AD group and the group has db_readonly...

    Thom~

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

    October 13, 2017 at 9:21 am

    #1963583

  • RE: Are the posted questions getting worse?

    Phil Parkin - Friday, October 13, 2017 9:10 AM

    Michael L John - Friday, October 13, 2017 8:56...

    Thom~

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

    October 13, 2017 at 9:20 am

    #1963582

  • RE: User Not able to access Schema owned tables

    When you say he's in a group, is this an AD group or do you mean a Database role?

    Is the user a member of any of AD...

    Thom~

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

    October 13, 2017 at 9:01 am

    #1963570

  • RE: Are the posted questions getting worse?

    ThomasRushton - Friday, October 13, 2017 2:27 AM

    There are a few other gotchas with SSMS 17.3 - particularly with its now-non-support...

    Thom~

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

    October 13, 2017 at 4:42 am

    #1963526

    • Viewing 15 posts - 2,866 through 2,880 (of 5,109 total)