Forum Replies Created

Viewing 15 posts - 4,171 through 4,185 (of 5,109 total)

  • RE: Filter based on a condition

    I can't actually see a details group on your Tablix 5, only the Group Rodzaj.

    I'm not entirely sure on what your aim is here, so I've giving two...

    Thom~

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

  • RE: get date / only sql

    Sergiy - Monday, February 27, 2017 6:01 PM

    That would be an additional filter:
    AND Department = 'Catering'

    And if the Customer...

    Thom~

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

  • RE: Index via SQL Server Job

    jake.dabrowski - Monday, February 27, 2017 3:02 PM

    Thom A - Monday, February 27, 2017 12:55 PM

    Thom~

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

  • RE: Index via SQL Server Job

    Does the account that the SQL Agent is running under have permission to access that database and drop indexes on it?

    Thom~

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

  • RE: Count(*) output blank but required Zero

    That isn't my query, at all. I don't refer to i.[Time at Call] > '2017-02-27 14:35:32.697' in my where clause, and my reference to the country is in...

    Thom~

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

  • RE: SSRS - Indicators

    Do you mean the Rim colour? No, you can't change it. The traffic lights are effectively just an image, the rimmed ones just have a black surround.

    You can,...

    Thom~

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

  • RE: Issue while inserting hardcode value into column

    Insert into @Emp (ms,'Function')
    Select datediff(ms,@sttime,@etime)

    Your error message is really telling you the problem here, you're trying to insert data into the columns ms and

    Thom~

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

  • RE: Count(*) output blank but required Zero

    Sangeeth878787 - Monday, February 27, 2017 9:04 AM

    Hi Thom,
    As you said   exactly,  I  want to show a count (of 0)...

    Thom~

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

  • RE: Filter based on a condition

    lukaszpiech - Monday, February 27, 2017 8:55 AM

    .rdl file won't give you any data, right? I can't reveal any data.

    Not unless you've...

    Thom~

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

  • RE: split time

    Without DDL, this should work:
    WITH DaySplit AS (
      SELECT * FROM (
      VALUES ('AM', '09:00', '13:00'),
            ('PM', '13:00', '17:00')
            ...

    Thom~

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

  • RE: Filter based on a condition

    Could you instead provide the .rdl file, rather than an export from Excel? We'll know what your report looks like then, and what your object names are, etc.

    Thom~

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

  • RE: split time

    joanna.seldon - Monday, February 27, 2017 6:27 AM

    Hi

    I don't understand sorry..this is an example of the data I am using

    I am...

    Thom~

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

  • RE: Count(*) output blank but required Zero

    rot-717018 - Monday, February 27, 2017 6:24 AM

    yah you're right, I forgot --> COUNT never returns NULL ... thanks for pointing this out...

    Thom~

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

  • RE: split time

    Could I have consumable data this time please?

    Thanks.

    Thom~

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

  • RE: get date / only sql

    Sergiy - Monday, February 27, 2017 4:20 AM

    Everything is much simpler, really

    SELECT Whatever
    FROM orders
    where Orderdate >= @OrderdateOnly
    and OrderDate < dateadd(dd,...

    Thom~

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

  • Viewing 15 posts - 4,171 through 4,185 (of 5,109 total)