Forum Replies Created

Viewing 15 posts - 4,546 through 4,560 (of 5,109 total)

  • RE: Installing SQL Server 2012 Express failed on Windows 10 Home

    The error message says "Error description: Attempted to perform an unauthorized operation."

    Looks like you don't have permissions to install on your machine.

    Thom~

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

  • RE: Resize Tablix that contains rectangles

    Unfortunately, if you have objects inside an object (and then in your case, another object inside that object), then you have to shrink each object before shrinking it parent.

    SSRS won't...

    Thom~

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

  • RE: Visual Studio License for SSDT

    To quote from the SSDT Page:

    SSDT works best with Visual Studio 2015


    If you don't have Visual Studio installed on your machine, installing SSDT will also install a minimal “Integrated Shell”...

    Thom~

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

  • RE: json search

    Rechana Rajan (1/9/2017)


    we have json getting stored in one of the tables and how can we search inside the json.

    There is no native support for reading JSON in SQL Server...

    Thom~

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

  • RE: SSRS drill down report on multiple columns

    I see your goal, however, I therefore think your datasets and way your using SSRS don't align. SSRS is happy to receive summarised values, if that's all your going to...

    Thom~

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

  • RE: Using Checkpoint

    MMartin1 (1/9/2017)


    Thom A (1/8/2017)


    If your aim is to continue from a "checkpoint" after a failure, I would suggest 1 of two ideas.

    1. Log what you have processed thus far, then,...

    Thom~

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

  • RE: Anyway to prevent Deadlock tranaction errors?

    Should these processes actually be running at the same time? If they are both going to update a column at the same time, then you're going to be getting a...

    Thom~

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

  • RE: Split into multiple rows after certain character

    I'm impressed at your patience so far Sean, this is getting quite the ugly dataset.

    As Sean said before, I think at this stage you would be better off redesigning your...

    Thom~

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

  • RE: SSRS drill down report on multiple columns

    Firstly, the sample table you provided doesn't work for the rdl xml you provided. You are summing BIT columns, which you can't do (BIT can't have a value higher than...

    Thom~

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

  • RE: SSRS drill down report on multiple columns

    Do you mean that the parameters are not correct on the Sub report? This would mean that have been declared incorrectly in the on click action of the parent report.

    Thom~

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

  • RE: SSRS drill down report on multiple columns

    Somewhere your logic isn't correct if the data isn't consistent.

    What is the actual query your sub report is running? In your post you said it should be running something like,...

    Thom~

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

  • RE: Return some rows in columns

    ehlinger (1/9/2017)


    This isn't my database design, however, the actual database itself is in 1st Normal form. To get a quick and easy example I posted this knowing I'd have...

    Thom~

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

  • RE: Filtering Table Name.

    Why not exclude them in your WHERE clause?

    SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableName

    FROM sys.tables t

    WHERE t.name NOT IN('Table1','Table2','Table3','Table4','Table5','table6') --You could get these from a table if they could change

    Thom~

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

  • RE: Add Extra page for every single report page SSRS

    Considering you have been here long enough, you really should use the correct forum for your question. For example, some of the other topics you have created are in the...

    Thom~

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

  • RE: Need Help with Stored Procedure Data type converting

    Are your 0's in the previous lines meant to be empty fields? A 0 in an INTEGER Field is not an empty field. Neither is a blank String ('') an...

    Thom~

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

Viewing 15 posts - 4,546 through 4,560 (of 5,109 total)