Forum Replies Created

Viewing 15 posts - 5,011 through 5,025 (of 5,109 total)

  • RE: Recovering a table from TB database

    Although this doesn't answer your question, why does a customer have the ability to delete a table? If this is something they definitely shouldn't be doing, it most definitely worth...

    Thom~

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

  • RE: Default "To" should be Email Address For Report Subscriptions

    You posted this last month as well, asking exactly the same question.

    I'm pretty sure that this isn't a function of SSRS though. I haven't seen it in 2008 to...

    Thom~

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

  • RE: Sequential read from table

    Luis Cazares (6/8/2016)


    For a fast sequential read of a table to move data from one system to another, you could also use SSIS.

    You're doing ETL work, use the ETL tool.

    This...

    Thom~

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

  • RE: Sequential read from table

    Sounds like your after a *shivers* Cursor.

    Would this do the job?

    Create Table #Loop (ID int, Name varchar(20))

    Insert into #Loop

    VAlues (1, 'Steve'),

    (2, 'Jane'),

    (3, 'George'),

    (4, 'Harold')

    Declare @Name varchar(20)

    Declare Loop_Cursor Cursor...

    Thom~

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

  • RE: query calculation based on group by columns for different logic

    I'm not 100% sure on the logic of your table here. What I've created below definitely isn't scalable if you were to have a department without 2 employees (what even...

    Thom~

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

  • RE: SSRS show trend chart by up and down arrow over column chart per series groups

    How are you going to show arrows in a chart? Visually this should be pretty apparently if you are showing it in a chart, as the line/bar will be higher...

    Thom~

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

  • RE: one ssis package to load all .csv files into relevant tables

    A Foreach loop is what you're after.

    I have something similar, that checks our SFTP "In boxes" once a day to see if we're received any new files. Files in specific...

    Thom~

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

  • RE: Date time convertion problem

    If you're using the calendar, that shouldn't be a problem. Are you able to confirm the browser they are using?

    Thom~

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

  • RE: How to convert existing reports to view on mobile/smart devices?

    When you say latest version, do you mean 2016? if so, 2016 has had an overhaul with Mobile Devices in mind. Here's a link to the MSDB article about creating...

    Thom~

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

  • RE: Date time convertion problem

    This sounds like you're entering a date that isn't valid but effectively "could be". Take, for example 31 January 2016. I would type this as 31/01/2016, but an American would...

    Thom~

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

  • RE: SSIS : how to use variable in update statement

    Thom A (6/3/2016)


    The fact that the error says that your connection failed, really doesn't suggest there's a problem with the variable mapping, and is the connection manager. Especially if you...

    Thom~

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

  • RE: SSIS : how to use variable in update statement

    The fact that the error says that your connection failed, really doesn't suggest there's a problem with the variable mapping, and is the connection manager. Especially if you have the...

    Thom~

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

  • RE: SSRS server slow after it's been running for a while - restart fixes

    I would hazard a guess that it's hardware limitations. Are you running sufficient RAM on your server? Are you running any other services apart from SQL on the server?

    SQL Server...

    Thom~

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

  • RE: DATE issues with IE and FF

    I assume you're talking about the display at the top of the page, where you select your dates, and other parameters? If so, this isn't a problem with SSRS, it's...

    Thom~

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

  • RE: Count employees based on date difference

    For questions like this, it best to give us some sample data and table set up.

    Can you provide some create and insert statements? It would also probably help to...

    Thom~

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

Viewing 15 posts - 5,011 through 5,025 (of 5,109 total)