Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 5,685 total)

  • RE: SubQuery problem

    Here we go again.

    CELKO (3/9/2012)

    This is minimal polite behavior ON a SQL forum.

    Please, remove this comment from your cut and paste. The hypocrisy is stifling and I don't...

    March 9, 2012 at 11:37 am

    #1457328

  • RE: SubQuery problem

    jjohnson 40837 (3/8/2012)

    We see by my data the current query doesn't pull the total records for #2 but only record 1 & 3, I've adjusted my SQL to use a...

    March 8, 2012 at 5:34 pm

    #1456894

  • RE: Replacing NULL measure with a value or zero

    You don't necessarily want to default the cube to replace nulls with 0s because then it'll set your averages and counts to be inaccurate. Unless, of course, you WANT...

    March 8, 2012 at 5:28 pm

    #1456893

  • RE: If Statement...2nd try...:)

    jbalbo (3/8/2012)

    SELECT TAG_NAME = 'CUST_CLIENTNAME', TAG_DATA = (SELECT C.FNAME + CASE WHEN C.MNAME IS NULL THEN '' ELSE ' ' + C.MNAME END + ' ' + C.LNAME

    FROM CLIENT C...

    March 8, 2012 at 5:24 pm

    #1456892

  • RE: SSIS question

    Lynn Pettis (3/8/2012)

    Have to ask, but why the restriction on the number of records in each file? Personally, I can't think of a good business case for this.

    In my...

    March 8, 2012 at 5:11 pm

    #1456888

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (3/8/2012)

    mtillman-921105 (3/6/2012)

    Look, the first invisible car?

    I think it might create some problems if those were let loose in traffic.;-)

    I want two... I know I'm end up wrecked...

    March 8, 2012 at 3:43 pm

    #1456855

  • RE: SSIS question

    Recently did this.

    Create a proc performing the file grouping like above with row_number().

    Perform an execute sql task to determine the max file iteration you need from the query....

    March 8, 2012 at 11:48 am

    #1456731

  • RE: Long running query on only one server

    SQLJocky (3/8/2012)

    I have a query that ran in 3 seconds on a 2008 server, then we moved the database and everything to a different 2008R2 server (backup, restore) and now...

    March 8, 2012 at 11:45 am

    #1456728

  • RE: SSIS

    ramchandra2cool (3/6/2012)

    How is that it is taking in SSMS only 9 secs. And when i place the same query in the SSIS it is taking more time to pull the...

    March 6, 2012 at 2:46 pm

    #1455606

  • RE: Are the posted questions getting worse?

    SQLRNNR (3/6/2012)

    jcrawf02 (3/6/2012)

    Evil Kraig F (3/6/2012)

    And a week of troubleshooting later I'm back.

    If, for some reason, you just can't seem to get the login for SSC to work (page cannot...

    March 6, 2012 at 2:25 pm

    #1455592

  • RE: Are the posted questions getting worse?

    jcrawf02 (3/6/2012)

    Evil Kraig F (3/6/2012)

    And a week of troubleshooting later I'm back.

    If, for some reason, you just can't seem to get the login for SSC to work (page cannot be...

    March 6, 2012 at 2:22 pm

    #1455588

  • RE: Are the posted questions getting worse?

    And a week of troubleshooting later I'm back.

    If, for some reason, you just can't seem to get the login for SSC to work (page cannot be displayed), turn on SSL...

    March 6, 2012 at 2:15 pm

    #1455582

  • RE: How do I return only entries with multiple categories in a junction table?

    drew.allen (2/27/2012)

    CELKO (2/23/2012)

    Start using the ANSI/ISO row constructors

    Evil Kraig F (2/27/2012)

    Nah, I much prefer something that makes sense to the people I work with instead of forcing them to conform...

    February 27, 2012 at 3:14 pm

    #1452327

  • RE: Running Sql Server Program files on RAID10 - is this necessary for performance ?

    isuckatsql (2/27/2012)

    I know that you should run SQL data files on RAID10, which i have.

    I've run many large systems on RAID-5 with limited issues. Failure exposure is higher but...

    February 27, 2012 at 1:31 pm

    #1452272

  • RE: Better option than using Stored procedures

    raghuveer126 (2/24/2012)

    My team mate suggested me its beter that SQL query be in the report rather than using SP. But i have parameters and how can i put sql...

    February 27, 2012 at 1:25 pm

    #1452271

Viewing 15 posts - 1,726 through 1,740 (of 5,685 total)