Grant Fritchey (6/20/2011)

---

Jayanth_Kurup (6/20/2011)

---

I agree when done properly Agile is great for the developer , in fact I have enjoyed working in this manner coz it allows me to do...

[rant]

AAARRRGGGHHH....

One more person, just one more, who applies for an SSIS position (it's specifically advertised as an SSIS position) who's done nothing more than use it as a cross-server source/destination...

Why not just:

UPDATE Working_PIS SET...

Errrrm, not sure why you'd want a while loop/Tally table at all here.

This code will return what you need:

select

( AccountBalance * CONVERT( Money, PosNegSwitch + '1')) AS AcctBal

FROM

#WorkingTable

TallyTable/WhileLoop is usually...

That's a really odd percentage result calculation. What are you trying to get at in English? The math seems kinda wonky to me.

bpowers (6/20/2011)

---

Is there an "Update" control item available? If not, any idea on how we can accomplish an update to our table based on the primary key in our speadsheet?...

opc.three (6/18/2011)

---

I haven't tried implementing it to see what the real pros and cons are but I read you can install the Integration Services (IS) service on a server not...

Well, if you just want a generic idea...

Account, Security, AmortizationCalculations, OutstandingLoans, etc...

What are you trying to do here? If you're looking for someone to hand you a built design...

Roy Ernest (6/17/2011)

---

GilaMonster (6/17/2011)

---

Off to the UK for a week and a half. Can some people keep an eye on the corruption forums make sure that any problems don't get...

GilaMonster (6/17/2011)

---

Off to the UK for a week and a half. Can some people keep an eye on the corruption forums make sure that any problems don't get unchallenged stupid...

GSquared (6/17/2011)

---

Craig Farrell (6/17/2011)

---

Baaaah, I posted there at 200 points. ...

Phil Parkin (6/17/2011)

---

Actually, I was wondering about that. Does that mean the problem is that she has to get a full blow version of SQL Server to get the SSIS...

Opa! I haven't seen a homework question buzz by in a while.

It must be... 24 hours?

Woot!

Alright, let me ask you the first question, if the origination database and the...

WayneS (6/16/2011)

---

Edit: trying to get work to send me. They seem open... but at today's pricing, plus 2 pre-cons, + 6 nights in hotel, it's like $3600. We'll see what...

Baaaah, I posted there at 200 points. I'm just that...