Forum Replies Created

Viewing 15 posts - 211 through 225 (of 3,544 total)

  • RE: SSRS SUM(IIF()) on a matrix.

    Think you want something like this
    =(Sum(Fields!Booking_Count.Value)/ReportItems!Textbox1.Value)*100

    Replace Textbox1 with the actual name of the Total Count textbox

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Using SUM OVER without an Order by


    SELECT [Entry],Total_MPF,SUM(MPF) AS [MPF]
    FROM [tablename]
    GROUP BY [Entry],Total_MPF
    HAVING Total_MPF <> SUM(MPF)
    ORDER BY [Entry] ASC;

    From the data you posted...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Get the distinct records which having same date with different time stamp.

    Jonathan AC Roberts - Tuesday, March 19, 2019 9:09 AM

    Or you could use Jeff's favourite method: 😛

    declare @trend table (keyinstn...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Varchar(Max) storage

    Eirikur Eiriksson - Tuesday, March 19, 2019 9:14 AM

    David Burrows - Tuesday, March 19, 2019 8:04 AM

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Varchar(Max) storage

    Jeff Moden - Monday, March 18, 2019 10:22 AM

    Shirting gears a bit...

    Shirting... really :crazy:
    If you're shirting instead of shifting, we're...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Are the posted questions getting worse?

    Jeff Moden - Tuesday, March 12, 2019 10:00 PM

    Steve Jones - SSC Editor - Tuesday, March 12,...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Creating a Stored Procedure

    Jeff Moden - Thursday, March 7, 2019 4:25 PM

    BTW... I've said it in the past and I have to say it again......

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: query regarding compare-object output

    A simple google search would have found the answer, add the following to end of your code

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: The Extra Table

    Jeff Moden - Thursday, March 7, 2019 6:53 AM

    David Burrows - Thursday, March 7, 2019 2:14 AM

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: The Extra Table

    patrickmcginnis59 10839 - Wednesday, March 6, 2019 2:52 PM

    Sean Lange - Wednesday, March 6, 2019 2:27 PM

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Are the posted questions getting worse?

    Jeff Moden - Monday, February 25, 2019 12:16 PM

    Must be something in the air.  My Mom died Friday.  I've been ready for...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: date formats

    Sue_H - Wednesday, July 25, 2018 10:44 AM

    mtz676 - Wednesday, July 25, 2018 4:09 AM

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Friday, February 15, 2019 4:16 AM

    I guess it is my turn.

     I received a call this morning (2019-02-15) at approximately...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Interesting Use Case Of CEILING

    Jonathan AC Roberts - Thursday, December 13, 2018 2:48 AM

    Jeff Moden - Wednesday, December 12, 2018 8:52...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: DT_BYTE to DT_DBDATE

    sgmunson - Wednesday, November 14, 2018 6:24 AM

    David Burrows - Friday, November 9, 2018 9:20 AM

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 15 posts - 211 through 225 (of 3,544 total)