Forum Replies Created

Viewing 15 posts - 271 through 285 (of 3,232 total)

  • RE: testing value of a subquery in the SELECT clause

    WayneS (11/2/2010)

    buddy__a (11/2/2010)

    I think the derived table would create an even more complicated query since the query in the derived table would require and additional join to create a key...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 2, 2010 at 3:31 pm

    #1245782

  • RE: Reporting Strategy - Looking for suggestions/comments

    A view is a good place to add columns and aggregations, but I don't understand why you have a trigger and stored procedure for this. Views are materialized when...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 2, 2010 at 3:22 pm

    #1245779

  • RE: Week Part

    Can you give me an example of the raw data that would make up the groupings that you have there? Table DDL would help too.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 2, 2010 at 3:19 pm

    #1245776

  • RE: Need to Exclude One Of The Following

    Duh.....I didn't notice that all of the other column values were the same.....GROUP BY would definately be the best option. Thanks Lutz!

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 1, 2010 at 9:58 am

    #1244904

  • RE: 100 Years Ago, What Would You Be?

    Law enforcement.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 1, 2010 at 9:20 am

    #1244881

  • RE: Need to Exclude One Of The Following

    Here's one way......given I don't know anything about your table structure, size, or indexing, this will work. If it does not perform well, post your table DDL and some...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 1, 2010 at 8:38 am

    #1244855

  • RE: How to get the result from SP to dataflow task

    That's exactly what I'd recommend to do (obviously from the other post).

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 1, 2010 at 8:19 am

    #1244838

  • RE: First time SSIS package guy here

    preensheen (10/29/2010)

    John Rowan (10/25/2010)

    The source adapter can usually glean the result set metadata from nested SP calls, but it sometimes gets confused when there are several nestings and many selects...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 29, 2010 at 11:11 am

    #1244347

  • RE: How to get the result from SP to dataflow task

    preensheen (10/27/2010)

    John Rowan (10/26/2010)

    Data Flow source adapters do allow for SP execution. Does attempting this give you an error?

    Yes, i am trying to pass parameter and and everything correctly...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 3:54 pm

    #1243898

  • RE: Combining two tables into one view and joining columns

    That would work if the 2 tables were in fact related by idnum=idnum, but the OP did not say the tables were related.....just similar.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 1:37 pm

    #1243809

  • RE: Permissions

    Thanks for posting the solution. I'm sure this will help somebody else down the road.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 12:46 pm

    #1243784

  • RE: Replacing text within a single column, but not the entire string

    Look at the STUFF function in BOL.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 12:40 pm

    #1243779

  • RE: Problem With Header

    Why can't you just include the double quotes in with the header variable? How are you getting the header variable into the file?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 12:39 pm

    #1243777

  • RE: Combining two tables into one view and joining columns

    CREATE VIEW Transactions

    AS

    SELECT idnum,

    trndate,

    amount * -1 as amount

    FROMPurchases

    UNION ALL

    SELECT idnum,

    trndate,

    amount

    FROMPayments

    GO

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 12:06 pm

    #1243763

  • RE: Percentdiff?

    DECLARE @TABLE_A TABLE (PCode char(3), MonthPop int)

    INSERT INTO @Table_A

    SELECT '5F5', 400000 UNION ALL

    SELECT '5F7', 777777 UNION ALL

    SELECT '5HG', 222224 UNION ALL

    SELECT '5HP', 153086

    DECLARE @TABLE_B TABLE (PCode char(3), MonthPop int)

    INSERT INTO...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 10:36 am

    #1243699

Viewing 15 posts - 271 through 285 (of 3,232 total)