WayneS (10/6/2010)

---

Craig, did you consider the effect...

David Webb-200187 (10/6/2010)

---

Some possible paths would be to either broaden his scope and move into an Architect position, or specialize and do consulting in a specific area like data security,...

Senior DBAs don't advance, they just learn more...

... or end up in management.

craig-404139 (10/6/2010)

---

^^ Thanks. I'll start chewing through that and seeing if it fits. At first glance I have no idea what it's doing. Like I mentioned I've never had to...

Edit: Sorry for the multi-edit. Something didn't play nicely with the code= statements when I tried to first post this.

The Test Harness:

SELECT TOP 1000000

IDENTITY(INT, 1,1) AS N

INTOTally

FROM

Master.dbo.SysColumns sc1,

Master.dbo.syscolumns sc2

ALTER...

craig-404139 (10/6/2010)

---

Craig Farrell (10/6/2010)

---

Craig,

Is it safe to assume that this field will alway end in numerics? If so, I may have a simple solution for you regarding the variable...

kenambrose (10/6/2010)

---

Having different specifications for a finished deliverable does not mean the methods one uses to implement the deliverable have to be different.

I worked for years in custom manufacturing industry....

Yep, and that was cheatin', Alvin...

Simon? Ready. Theodore? *munchmunch* 'ere... "AAALLLLVVVVIIIINNNN!!!"

And now I have that episode of the Smurfs stuck in my head when they're bringing Brainy to the moon...

Yeah, Gail was quite busy today...

And Mr. 13, you missed. 😉

Hey! hold on there, I want on that wagon!

15!

Yawhoops... I'm the man...

To hose down the inbound flame war:

Regardless of how the R&D department at Honda works, the point is that the engine is a finished product, then reproduced.

The equivalent of a...

Stefan Krzywicki (10/6/2010)

---

jcrawf02 (10/6/2010)

---

Alvin Ramard (10/6/2010)

---

We're now in an infinite loop....

Sorry, bad code, it should have been:

UPDATE tbl

SET

@carryme = NullableCol = ISNULL( NullableCol, @carryme)

FROM

tbl

ORDER BY

tblID

Oops.