Forum Replies Created

Viewing 15 posts - 4,441 through 4,455 (of 5,109 total)

  • RE: SSC Forum Updates

    Brandie Tarvin - Thursday, January 19, 2017 4:23 AM

    Is it just me, or is anyone else getting like an inch & 1/2...

    Thom~

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

  • RE: Permissions issue with a sysadmin account

    This looks like the error that existed with a prior version of SSMS 2016 (I believe it was either the October or November version). What version of SSMS are they...

    Thom~

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

  • RE: ssrs 2010 report server with lots of warning messages

    Warnings won't really slow the report down, per say, but they could give you unexpected results. Some items may not display what you were expecting, or in the layout you...

    Thom~

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

  • RE: SSRS Report - Print to one page

    Depends what you mean by "print to one page".  Where are you printing from? The SSRS web portal, a downloaded report as PDF (and the report is overlapping onto other...

    Thom~

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

  • RE: ADMINISTER BULK OPERATIONS

    This is a role I really need to read more into. Reminds me that i really need to get our CRM account permissions "dumbed" down. It's good to know that...

    Thom~

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

  • RE: Need help with deleting/updating duplicates in two tables

    There are a number ways you could, do this. You could get the list of your duplicates first, and insert them into a dataset, for example a temporary table. You...

    Thom~

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

  • RE: Need help with deleting/updating duplicates in two tables

    Cursors are inherently slow, so I'm not surprised it's taking awhile.

    One way to identify duplicates is by using the GROUP BY(Transact-SQL) and HAVING (Transact-SQL). You could use this...

    Thom~

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

  • RE: Question about CASE WHEN on a column

    Luis Cazares - Wednesday, January 18, 2017 11:23 AM

    Also, there's no need to use ELSE on Thom's code. When there's no...

    Thom~

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

  • RE: Sum Query search

    This looks like a homework question (You have your question number in your post). Perhaps some further reading on GROUP BY (Transact-SQL) would assist you better with your learning.

    Thom~

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

  • RE: Question about CASE WHEN on a column

    No edit button on the mobile site is annoying....

    Thom~

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

  • RE: Question about CASE WHEN on a column

    Your CASE statement should look like this:
    CASE Eventcode WHEN 'Open' THEN EventAdded ELSE NULL END

    Edit: Got the laptop, so I can finish my post now.

    The...

    Thom~

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

  • RE: Microsoft access and sql server

    sqlfriends - Wednesday, January 18, 2017 9:05 AM

    How many concurrent users allowed ?

    In Access, or on SQL. If SQL, how many...

    Thom~

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

  • RE: SQL Server 2016 Express Installation Error

    if you have the ability to, now is an excellent time to make a backup of your PC (and set a restore point, as it's a home PC).

    Thom~

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

  • RE: Five Useful SQL Server Management Practices

    John Mitchell-245523 - Wednesday, January 18, 2017 4:05 AM

    I was thinking more about staggering backup jobs on different servers, rather than...

    Thom~

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

  • RE: Five Useful SQL Server Management Practices

    John Mitchell-245523 - Wednesday, January 18, 2017 3:33 AM

    Thom A - Wednesday, January 18, 2017 2:56 AM

    Thom~

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

Viewing 15 posts - 4,441 through 4,455 (of 5,109 total)