Forum Replies Created

Viewing 15 posts - 1 through 15 (of 46 total)

  • Reply To: A Digital Wish Card for Ken

    When I said "Hope recovery is swift!" you could've just said no but I guess you had to make a show of it. Definitely in my thoughts and FlatJeff's as...

  • RE: Need to load double pipe || delimited data in a table by using SSIS

    When you choose your delimiter, don't select the | delimiter option, actually delete that out and type ||. That should get the behavior you want

  • RE: split fixed width row into multiple rows in SSIS

    Sorry, I read too fast and missed that part.

    For the stream that will go into table2, you can use unpivot, specifying ID as passthrough, Seq as PivotKey column, City1/ST1 with...

  • RE: split fixed width row into multiple rows in SSIS

    Once you have the flat file source set up correctly, you could multicast and then send to two OLEDB destinations mapping the fields you want for each.

  • RE: IN CORRECT SYNTEX

    Thanks.

    All the aliasing in the world doesn't save you from an errant comma though. 🙂

  • RE: IN CORRECT SYNTEX

    and that's what I get for reading too quickly.

  • RE: IN CORRECT SYNTEX

    lonhanner (12/29/2012)


    UPDATE TRP_STATS

    SET TRIP_ID = TRIP,

    FROM TRP_STATS JOIN TRP_DETAILS

    ON TRP_STATS.TRP = TRP_DETAILS.TRP;

    Msg 156, Level 15, State 1, Line 3

    Incorrect syntax near the keyword 'FROM'.

    I get these error about...

  • RE: IN CORRECT SYNTEX

    Try:

    EXEC sp_rename 'Trips.Code', 'Area', 'COLUMN'

  • RE: require help with CASE query !!

    Shot in the dark as to getting you the data you want because I'm not sure I 100% understand but try this:

    (Select top 1

    Coalesce(Neonate.Vacuum_Extraction,Neonate.Forceps_Delivery,Neonate.Assisted_Breech_Delivery,Neonate.Spontaneous_Breech_Delivery,Neonate.Total_Breech_Extraction,Neonate.Cesarean_Section,Neonate.Normal_Vaginal_Delivery,'N/A')

    from DatamartDB2.dbo.IPR_Delivery_Report_Neonate_Delivery_Report_Neonate as Neonate

    where BLSession_Extended.sessionID...

  • RE: require help with CASE query !!

    Hello.

    From what I'm seeing, you're usage of isnull will not work.

    You are basically saying "when Neonate.Vacuum_Extraction is a null value, set it to string '0', and when string '0' equals...

  • RE: Get Left-most Char of Col A to insert into Col B

    If it is always going to the first character of column a, might consider redefining column b as a computed column to save you the pain of ongoing updates, etc....

  • RE: smart work with select

    I absolutely agree with you that this should never be used in production and was certainly not attempting to defend that position.

    Just saying that as a generation tool it has...

  • RE: smart work with select

    You are tasked with pulling out the data across 50 tables. They all contain any number of columns. You want all of it but know for a fact you don't...

  • RE: smart work with select

    Though it could be a case where you don't know the columns you do want but definitely want to exclude certain columns.

    Like excluding all transaction audit columns from any...

  • RE: More than one page per group

    I'm assuming you've checked the group settings to ensure that 'Add Page Break [Before|After] Group' is not selected?

Viewing 15 posts - 1 through 15 (of 46 total)