Viewing 15 posts - 1 through 15 (of 46 total)
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...
July 7, 2020 at 4:01 pm
When you choose your delimiter, don't select the | delimiter option, actually delete that out and type ||. That should get the behavior you want
March 19, 2014 at 3:07 am
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...
March 31, 2013 at 6:47 pm
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.
March 31, 2013 at 6:38 pm
Thanks.
All the aliasing in the world doesn't save you from an errant comma though. 🙂
December 29, 2012 at 6:04 pm
lonhanner (12/29/2012)
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...
December 29, 2012 at 5:37 pm
Try:
EXEC sp_rename 'Trips.Code', 'Area', 'COLUMN'
December 29, 2012 at 3:17 pm
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...
November 28, 2012 at 3:00 pm
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...
November 28, 2012 at 2:12 pm
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....
November 14, 2012 at 8:59 pm
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...
June 21, 2012 at 9:47 am
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...
June 21, 2012 at 9:34 am
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...
June 21, 2012 at 9:07 am
I'm assuming you've checked the group settings to ensure that 'Add Page Break [Before|After] Group' is not selected?
May 19, 2012 at 12:27 am
Viewing 15 posts - 1 through 15 (of 46 total)