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...

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

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...

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.

Thanks.

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

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

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...

Try:

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

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...

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...

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....

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...

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...

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...

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