Forum Replies Created

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

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

    Sangeeth878787 - Tuesday, February 28, 2017 2:26 AM

    Hi Martin,

    I am glad for message, but when there is no data associated, the...

  • 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...

  • 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...

  • RE: Index via SQL Server Job

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

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

    February 27, 2017 at 5:15 pm

    #1930586

  • 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?

  • 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...

  • 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,...

  • 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

    February 27, 2017 at 10:48 am

    #1930515

  • 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)...

  • 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...

  • RE: split time

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

  • 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.

  • 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...

  • 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...

  • RE: split time

    Could I have consumable data this time please?

    Thanks.

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