Why so much hate on SSIS? Yes it has some weird issues and things I'd love to see fixed but compared to DTS or hand coding all your ETL...

Steve Jones - SSC Editor (7/1/2015)

---

ZZartin (7/1/2015)

---

A math degree is not job training to be an accountant and a CS degree shouldn't be thought of as job training to be...

Steve Jones - SSC Editor (7/1/2015)

---

P Jones (7/1/2015)

---

As an IT pro and graduate, I've been involved in the recruitment of programmers and the very first requirement on the job spec....

I also disagree with that opinion, a CS degree is not supposed to be job training and it's ridiculous to imply that universities should even attempt for it to be...

I believe that she's "afraid" of someone having any access beyond the user level. When I came on board as a DBA, she wiould only give me access to a...

Well when you say your sys admin is the only person allowed to have that information is that actual company policy or just that noone has taken the time to...

Do you have a process that's keeping track of the file sizes on whatever schedule for you?

Lowell (6/30/2015)

---

this is usually frowned upon, because the unique string generated can (and eventually Will) end up being an offensive word. there's no need to show a string, when a...

Cake

Try this.

WITH TEMP_CTE AS(

SELECT PAT_ONE.PatientID, PAT_ONE.AdmissionDate, PAT_ONE.DischargeDate, PAT_ONE.Cost

FROM PatientProblem PAT_ONE

LEFT OUTER JOIN PatientProblem PAT_TWO ON PAT_ONE.PatientId = PAT_TWO.PatientID AND PAT_ONE.DischargeDate = DATEADD(day, -1, PAT_TWO.AdmissionDate)

WHERE

PAT_TWO.PatientID IS NULL

UNION ALL

SELECT PAT_TWO.PatientId, PAT_TWO.AdmissionDate,...

Well depending on the file format you could read the entire record as one column then parse it programatically, that may or may not be worth the effort though.

Jeff Moden (6/17/2015)

---

patrickmcginnis59 10839 (6/17/2015)

---

ZZartin (6/17/2015)Sometimes the only way people will accept they're wrong is if you prove them wrong. For example a perfectly plausible scenario is that columns...

patrickmcginnis59 10839 (6/16/2015)

---

ZZartin (6/5/2015)

---

EdVassie (6/5/2015)

---

You could try a little role-play.

Call your developers into a meeting, and have a box of paper left outside the room.

Tell a developer you need some...

Cola

Trip