Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 5,685 total)

  • RE: Can I rewrite the following query without using Row_number() function ??!!

    mounish (1/13/2011)

    When I embed this query in between many other queries along with JOINs, My oracle server is unable to execute.

    Just an FYI: You realize you posted this...

    January 13, 2011 at 11:47 am

    #1273206

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/12/2011)

    I think that green is an appropriate color for the US

    Did you have half an hour of work you were looking to pay me for...

    January 12, 2011 at 3:48 pm

    #1272698

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/12/2011)

    Grant Fritchey (1/12/2011)

    WayneS (1/12/2011)

    Grant Fritchey (1/12/2011)

    Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are...

    January 12, 2011 at 11:43 am

    #1272534

  • RE: Error Runing the Package SSIS.

    Post the script? My guess is you've got invalid 2k5 syntax (IE: MERGE). The other option is you need to turn on bypass prepare.

    January 11, 2011 at 5:59 pm

    #1272147

  • RE: CASE vs JOIN

    Vedran Kesegic (1/11/2011)

    In short: no. You probably will not have significant performance gains if you use "mutant" CASE statement.

    I'll agree with this, but add a few things.

    Regarding joins, check out...

    January 11, 2011 at 4:28 pm

    #1272133

  • RE: Security laws and publicly-traded companies

    Indianrock (1/11/2011)

    The problem of complying with laws in multiple states reminds me of how the SEC and other regulatory bodies failed in regulating Wall Street. A domestic-only focus...

    January 11, 2011 at 2:15 pm

    #1272094

  • RE: Proc Performance

    Reji PR (1/11/2011)

    I am not understanding, why you are using dynamic sql string?

    If My understanding is correct, you need to set the arguments in the where clause based on the...

    January 11, 2011 at 12:05 pm

    #1272021

  • RE: Assigning values to multiple variables with single SELECT (with a twist)

    GSquared (1/11/2011)

    Jeff Moden (1/10/2011)

    WayneS (1/10/2011)

    Craig Farrell (1/10/2011)

    GSquared (1/10/2011)

    Since you're using SQL 2008, can you switch from delimited lists of parameter values to a table variable parameter? Those are more...

    January 11, 2011 at 11:24 am

    #1272005

  • RE: Service Broker Activation not firing off

    Service Broker doesn't remove messages immediately, for a couple of internal reasons. It also won't remove messages that don't close the dialog properly.

    Check out these articles, specifically the parts...

    January 11, 2011 at 11:04 am

    #1271993

  • RE: SQL Issues

    You are under a brute force attempt to login, there's a virus or a trojan on your system.

    Get a network security expert in NOW.

    The login is always changing, and its...

    January 11, 2011 at 10:59 am

    #1271990

  • RE: Security laws and publicly-traded companies

    ^ Elliott's right. I blame it still being morning, sorry... and I was thinking of data security and protection in a different light.

    I live and breath SOX so often...

    January 11, 2011 at 10:57 am

    #1271986

  • RE: Security laws and publicly-traded companies

    The majority of laws for businesses come from three places these days. OSHA, HIPPA, and SEC.

    When you say security laws, do you mean *trading* securities (stocks, bonds, options), or physical...

    January 11, 2011 at 10:11 am

    #1271960

  • RE: Please help with SQL code

    pwalter83 (1/11/2011)

    Hi Craig,

    Thanks for your reply. The NCV_BL_DHL_TEMP table will be joined to MG_Location on

    NCV_BL_DHL_TEMP.POL_COUNTRY_CD = MG_Location.COUNTRY_CD

    Hope that helps.

    Kind Regards,

    Paul

    Precisely the issue. There's two FR rows and you're...

    January 11, 2011 at 2:31 am

    #1271762

  • RE: Rewriting the query without using 'Insert' <Query Optimization>

    Jeff Moden (1/10/2011)

    Actually, WITH was available in Oracle long before SQL Server. They don't call it a "CTE", though. Instead, they call it "Sub-Query Refactoring" and it works...

    January 10, 2011 at 9:55 pm

    #1271709

  • RE: Please help with SQL code

    Got distracted a while.

    Here's part of the problem:

    /*

    --One FR sample row

    insert into NCV_BL_DHL_TEMP

    values('10443663', 'LEH901114', 'SAEME', 'FR', 'HK', 'SVB', '648E', 'E', '02-06-2009', '2');

    -- ALL MG_Location Sample rows

    insert into MG_LOCATION

    values('FRTAR', 'TARNOS', 'B',...

    January 10, 2011 at 5:31 pm

    #1271673

Viewing 15 posts - 4,396 through 4,410 (of 5,685 total)