Forum Replies Created

Viewing 15 posts - 316 through 330 (of 542 total)

  • RE: Include condition in the combo box in a form (MS Access 2007)

    Ninja's_RGR'us (12/16/2011)

    Just add it in the query (datasource).

    I've had issues in the past (2000, 2003). Not sure if it was me or access but that solved it.

    Thanks for your...

    December 16, 2011 at 7:33 am

    #1422501

  • RE: Create parameter from getdate() to extract all previous years

    Jeff Moden (12/14/2011)

    pwalter83 (12/14/2011)

    Hi,

    I have a requirement to display all previous years starting from 2010 and above as parameters. The only way I can think of doing it currently is...

    December 15, 2011 at 4:39 am

    #1421837

  • RE: SUM of a single column in SELECT

    Adi Cohn-120898 (11/11/2011)

    Personally I don’t like doing things like that, but it can be done with the over clause. The code bellow is based on AdventureWorks database:

    select ProductID, SUM(ActualCost)...

    November 14, 2011 at 2:44 am

    #1407005

  • RE: Using DISTINCT within a JOIN

    Jeff Moden (11/10/2011)

    There are multiple ways to do such a thing. For example, (and depending on the required columns) you could make a CTE for the DISTINCT select on...

    November 10, 2011 at 8:07 am

    #1405788

  • RE: Making a SUM of COUNT

    JonFox (11/10/2011)

    ChrisM@Work (11/10/2011)

    This should do it:

    SUM(CASE WHEN e.EQUIPMENT_TYPE_CD like '20%' THEN 1 ELSE 2 END

    * CASE WHEN e.BOOKING_EQ_REQ_DETAIL_ID IS NULL THEN 0 ELSE 1 END) AS BookedTEU

    This gives you...

    November 10, 2011 at 7:34 am

    #1405747

  • RE: Making a SUM of COUNT

    ChrisM@Work (11/10/2011)

    This should do it:

    SUM(CASE WHEN e.EQUIPMENT_TYPE_CD like '20%' THEN 1 ELSE 2 END

    * CASE WHEN e.BOOKING_EQ_REQ_DETAIL_ID IS NULL THEN 0 ELSE 1 END) AS BookedTEU

    This gives you a...

    November 10, 2011 at 7:33 am

    #1405746

  • RE: Making a SUM of COUNT

    JonFox (11/10/2011)

    I'm guessing the error you're getting is: "Cannot perform an aggregate function on an expression containing an aggregate or a subquery."

    In order to do something like that, you'll probably...

    November 10, 2011 at 5:41 am

    #1405665

  • RE: Multiple parameters report- Free text search field

    Ninja's_RGR'us (10/18/2011)

    pwalter83 (10/18/2011)

    Ninja's_RGR'us (10/17/2011)

    pwalter83 (10/17/2011)

    Ninja's_RGR'us (10/17/2011)

    Well I'm out of ideas them. You know all I know about this problem and all the ways to treat the issue.

    Issue resolved

    So what...

    October 18, 2011 at 7:51 am

    #1395949

  • RE: Multiple parameters report- Free text search field

    Ninja's_RGR'us (10/17/2011)

    pwalter83 (10/17/2011)

    Ninja's_RGR'us (10/17/2011)

    Well I'm out of ideas them. You know all I know about this problem and all the ways to treat the issue.

    Issue resolved

    So what was the...

    October 18, 2011 at 1:54 am

    #1395726

  • RE: Multiple parameters report- Free text search field

    Ninja's_RGR'us (10/17/2011)

    Well I'm out of ideas them. You know all I know about this problem and all the ways to treat the issue.

    Issue resolved

    October 17, 2011 at 9:35 am

    #1395412

  • RE: Multiple parameters report- Free text search field

    Ninja's_RGR'us (10/17/2011)

    pwalter83 (10/17/2011)

    Ninja's_RGR'us (10/17/2011)

    Easy way to test for filters.

    Start a new trace and start the standard (default) trace.

    Depending on how SSRS plays here you might see something like SP_EXECUTESQL ......

    October 17, 2011 at 8:11 am

    #1395352

  • RE: Multiple parameters report- Free text search field

    Ninja's_RGR'us (10/17/2011)

    Easy way to test for filters.

    Start a new trace and start the standard (default) trace.

    Depending on how SSRS plays here you might see something like SP_EXECUTESQL ... 'EXEC yourProcNameHere'

    Done...

    October 17, 2011 at 7:54 am

    #1395338

  • RE: Multiple parameters report- Free text search field

    Ninja's_RGR'us (10/17/2011)

    pwalter83 (10/17/2011)

    Ninja's_RGR'us (10/14/2011)

    From your last message I assume that you have seen the command in profiler sent from either BIDS or SSRS.

    Please paste it here.

    P.S. You won't see the...

    October 17, 2011 at 6:06 am

    #1395254

  • RE: Multiple parameters report- Free text search field

    Ninja's_RGR'us (10/14/2011)

    From your last message I assume that you have seen the command in profiler sent from either BIDS or SSRS.

    Please paste it here.

    P.S. You won't see the full query...

    October 17, 2011 at 2:28 am

    #1395179

  • RE: Multiple parameters report- Free text search field

    Ninja's_RGR'us (10/14/2011)

    pwalter83 (10/14/2011)

    Ninja's_RGR'us (10/13/2011)

    Check up that series, might give you great pointers :

    http://www.sqlservercentral.com/articles/Video/66677/

    This is getting out of hand now, I am unable to find the particular piece of code...

    October 14, 2011 at 10:01 am

    #1394740

Viewing 15 posts - 316 through 330 (of 542 total)