Forum Replies Created

Viewing 15 posts - 211 through 225 (of 2,010 total)

  • RE: Race to post 1,000,000

    knowing how other things have gone from time to time, one might think the Thread would get that coveted post number. But yeah I'd take the field in a...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 22, 2010 at 3:55 am

    #1225421

  • RE: Select Distinct - Multiple Columns

    tsmith-960032 (9/21/2010)

    Luke L (9/21/2010)

    Why doesn't it matter which in records 1-2? If it doesn't matter why return that column at all?

    -Luke.

    Ok,

    ColumnA is a shipping number.

    Each shipping number...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 21, 2010 at 12:43 pm

    #1225154

  • RE: Select Distinct - Multiple Columns

    Why doesn't it matter which in records 1-2? If it doesn't matter why return that column at all?

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 21, 2010 at 12:28 pm

    #1225143

  • RE: Select Distinct - Multiple Columns

    so the sample data and expected output?

    If you're doing everything at rendering just pull everything, then group by columnA, add your calculations on columns b,c or whatnot. It's about...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 21, 2010 at 11:56 am

    #1225114

  • RE: Select Distinct - Multiple Columns

    Some sample data and required output would be very valuable here. See the first link in my signature for more info.

    You need to figure out if you'll do the...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 21, 2010 at 11:41 am

    #1225098

  • RE: Compare published reports

    I'd suggest you check out the RS Scripter available here. One of the options of this tool is to download the reports from your live server to a solution...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 21, 2010 at 9:29 am

    #1224957

  • RE: Syntax Help

    I'd be happy to help, but I don't understand the Crystal syntax. Any chance you can just post some sample data and expected results?

    It looks like you were just...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 21, 2010 at 9:05 am

    #1224922

  • RE: What is the max rows when exporting SQL 2008 R2 Reporting Services results to Excel

    What is the problem you are having? Can you describe it a bit better or provide error messages? The max number of rows in Excel 2007 is 1...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 21, 2010 at 6:49 am

    #1224749

  • RE: concatenating CASE stmt results

    Jeff Moden (9/20/2010)

    I don't like the short version at all because it "lies". If you expand the code it actually executes against variables, you find a big surprise. ...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 21, 2010 at 6:02 am

    #1224711

  • RE: concatenating CASE stmt results

    It's really a personal preference as AFAIK there's no performance difference, hence the "I prefer to avoid the short version". The longer (searched, or boolean depending on the...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 20, 2010 at 8:20 pm

    #1224470

  • RE: concatenating CASE stmt results

    Looks like Lutz beat me to it with a bit better sample code... Not something I would have thought to use a CTE for but it would definitely help with...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 20, 2010 at 1:02 pm

    #1224321

  • RE: concatenating CASE stmt results

    Couple of things here... It would be helpful if you posted some sample data and expected results as per the first link in my signature. Secondly, It looks like...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 20, 2010 at 12:58 pm

    #1224315

  • RE: Are the posted questions getting worse?

    GilaMonster (9/20/2010)

    *drum roll*

    *trumpet crescendo*

    ... and I think I'll leave things here for a little while.

    Edit: And as soon as i decide not to post for a few hours, there's a...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 20, 2010 at 7:15 am

    #1223995

  • RE: Raw Materials - The Decision

    Jack Corbett (9/16/2010)

    The only suggestion I'd make is to re-up the comics and make them viewable without joining SSC. I forwarded one to my boss once, not a DBA,...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 16, 2010 at 12:19 pm

    #1222480

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/16/2010)

    Luke L (9/16/2010)

    Alvin Ramard (9/16/2010)

    I give up. How can I expect to win when I'm dealing with people that do not appreciate good humour? 😎

    Good Humor?...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    September 16, 2010 at 11:30 am

    #1222431

Viewing 15 posts - 211 through 225 (of 2,010 total)