Forum Replies Created

Viewing 15 posts - 226 through 240 (of 541 total)

  • RE: Create select statement for the query

    Sean Lange (10/17/2012)

    pwalter83 (10/17/2012)

    robert.gerald.taylor (10/16/2012)

    pwalter83 (10/16/2012)

    I have a requirement to create a CASE statement for the following condition:

    SUM of NCV_BL.TEU where NCV_BL.POL_LOCATION_CD or NCV_BL.POD_LOCATION_CD is not present in MG_VSLVOY_SCHEDULE.PORT_CD for...

    October 18, 2012 at 5:43 am

    #1550416

  • RE: Create select statement for the query

    robert.gerald.taylor (10/16/2012)

    pwalter83 (10/16/2012)

    I have a requirement to create a CASE statement for the following condition:

    SUM of NCV_BL.TEU where NCV_BL.POL_LOCATION_CD or NCV_BL.POD_LOCATION_CD is not present in MG_VSLVOY_SCHEDULE.PORT_CD for the SAISAN_VESSEL_CD, SAISAN_VOYAGE_CD...

    October 17, 2012 at 8:40 am

    #1550058

  • RE: Query runs slow

    ChrisM@Work (8/16/2012)

    Paul, have you tried these two yet?

    WHERE MB.CREATE_DT > = DATEADD(HOUR,-14,GETDATE()-1) -- similar to DATEADD(D, 0, DATEDIFF(D, 1, GETDATE()))

    WHERE MB.CREATE_DT > = DATEADD(HOUR,0,GETDATE()-1) -- similar to getdate() -...

    August 16, 2012 at 9:20 am

    #1526661

  • RE: Query runs slow

    Sean Lange (8/16/2012)

    ChrisM@Work (8/16/2012)

    pwalter83 (8/16/2012)

    Hi,

    The query I am working on runs very slow due to a piece of code -

    CREATE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) -1

    Could someone...

    August 16, 2012 at 8:06 am

    #1526600

  • RE: Query runs slow

    ChrisM@Work (8/16/2012)

    pwalter83 (8/16/2012)

    Hi,

    The query I am working on runs very slow due to a piece of code -

    CREATE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) -1

    Could someone please suggest...

    August 16, 2012 at 7:20 am

    #1526558

  • RE: Using 2 servers in same connnection in SSIS package

    SQLRNNR (7/17/2012)

    pwalter83 (7/17/2012)

    SQLRNNR (7/10/2012)

    You can have 1 connection manager and have a variable to overwrite the server expression for that connection manager. But only 1 at a time.

    A better...

    July 18, 2012 at 3:02 am

    #1514080

  • RE: Using 2 servers in same connnection in SSIS package

    SQLRNNR (7/10/2012)

    You can have 1 connection manager and have a variable to overwrite the server expression for that connection manager. But only 1 at a time.

    A better description of...

    July 17, 2012 at 9:59 am

    #1513690

  • RE: Query runs very slow due to FOR XML PATH usage

    Sean Lange (7/5/2012)

    pwalter83 (7/5/2012)

    Sean Lange (7/3/2012)

    Start with this from Gail. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]

    Hi Sean,

    Would you be able to help me now ?

    Thanks,

    Paul

    Sorry yesterday was a holiday here in the US. It looks...

    July 5, 2012 at 7:53 am

    #1509124

  • RE: Query runs very slow due to FOR XML PATH usage

    pwalter83 (7/5/2012)

    ChrisM@Work (7/5/2012)

    Hi Paul

    Here's what I suggest you do.

    First, comment out the three CROSS APPLY blocks and the references to their results in the output of the query, like...

    July 5, 2012 at 7:21 am

    #1509111

  • RE: Query runs very slow due to FOR XML PATH usage

    ChrisM@Work (7/5/2012)

    Hi Paul

    Here's what I suggest you do.

    First, comment out the three CROSS APPLY blocks and the references to their results in the output of the query, like so:

    SELECT...

    July 5, 2012 at 5:38 am

    #1509049

  • RE: Query runs very slow due to FOR XML PATH usage

    Sean Lange (7/3/2012)

    Start with this from Gail. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]

    Hi Sean,

    Would you be able to help me now ?

    Thanks,

    Paul

    July 5, 2012 at 2:49 am

    #1508984

  • RE: Query runs very slow due to FOR XML PATH usage

    pwalter83 (7/4/2012)

    Sean Lange (7/3/2012)

    Start with this from Gail. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]

    I think the reason for the slow performance could be due to these lines of codes. I have also attached the Execution...

    July 4, 2012 at 8:58 am

    #1508810

  • RE: Query runs very slow due to FOR XML PATH usage

    Sean Lange (7/3/2012)

    Start with this from Gail. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]

    I think the reason for the slow performance could be due to these lines of codes. I have also attached the Execution plan.

    CROSS...

    July 4, 2012 at 2:16 am

    #1508640

  • RE: Concatenate 2 rows based on grouping

    ChrisM@Work (6/20/2012)

    Since GENERAL_COMMODITY_CD table has a different cardinality to your result set, having multiple rows per BOOKING_ID, you will need to preaggregate it, either as a CROSS APPLY or as...

    June 20, 2012 at 7:44 am

    #1503423

  • RE: Concatenate 2 rows based on grouping

    ChrisM@Work (6/20/2012)

    pwalter83 (6/20/2012)

    ChrisM@Work (6/20/2012)

    Are you seeing one row per BOOKING_ID in your output?

    - here's where adequate sample data would have helped 🙂

    yeah, I get only one row per BOOKING_ID...

    June 20, 2012 at 6:24 am

    #1503360

Viewing 15 posts - 226 through 240 (of 541 total)