SQLTougherGuy (8/17/2015)

---

Hello,

Is there a performance hit if I use CAPITOL LETTERS (like this) in column names for my SQL Server tables? Logically I would think that lower case letters would...

Steve Jones - SSC Editor (8/17/2015)

---

Probably slightly incorrect to say it's only one expression. It could be, but it could be multiple ones.

I'll change the question, but I'm not sure...

Use an expression for the connection string of the connection manger used to the to the file to e imported.

In that expression, use a formula that sets the date values...

I would have felt bad if I got this one wrong.

Good one to start the week with Steve.

sknox (8/17/2015)

---

And here starts the obligatory pedantry. 😛

is not quite correct. The correct statement is:

In a conditional split...

Eirikur Eiriksson (8/14/2015)

---

SQLRNNR (8/14/2015)

---

Maybe he has coded it differently than you...

First thing I would do is run a query that shows be all the people with the multiple rows, and their data. Then, looking at the data, see if you...

Did you try it a 2nd time?

Lynn Pettis (8/14/2015)

---

Alvin Ramard (8/14/2015)

---

Lynn, as far as I can tell, your script will work as long as the row for PercentFullTime = 1 is the same rows as AnnualizingFactor...

Lynn, as far as I can tell, your script will work as long as the row for PercentFullTime = 1 is the same rows as AnnualizingFactor = 2080. For...

Eirikur Eiriksson (8/14/2015)

---

Alvin Ramard (8/14/2015)

---

Lynn Pettis (8/14/2015)

---

Something like this:

declare @TestTable table(

EEID int,

Name varchar(64),

AnnualizingFactor int,

PercentFullTime...

Lynn Pettis (8/14/2015)

---

Something like this:

declare @TestTable table(

EEID int,

Name varchar(64),

AnnualizingFactor int,

PercentFullTime decimal(3,2));

insert into @TestTable

values

(1,'Marvin, Leo',2080,1...

Lynn Pettis (8/12/2015)

---

< Rant >

I don't know about others but I am really tired of people thinking that using vulgarity is appropriate in a professional environment and this is a...

djj (8/12/2015)

---

jasona.work (8/12/2015)

---

RG...

I'm thinking about it.