Ya gotta love it when the ops cooperate.

jac (12/22/2008)

---

I agree that 99.9% of administrative duties can be safely used via a wireless connection, but I think if I have to run that script again (the other 0.1...

Using Luke's good code example, you can label to "sum", as well...

--create test table

CREATE TABLE #test (

id INT,

amount MONEY)

--insert sample data

INSERT INTO [#test]

SELECT 1,10.00

UNION ALL

SELECT 1,20.00

UNION ALL

SELECT 2,10.00

SELECT CASE...

That's good advice if you're going to do something like that... but, most maintanence doesn't require a single connection like that. Not sure that's enough justification to give up...

Be very careful.... anytime you find the need to update or insert your own numbers into an IDENTITY column, you're probably doing something...

Japie Botma (10/21/2005)

---

Assuming it is not a live table and you know what and why you want to do this, you can remove the identity from the column, update the...

Um.... I don't know much about IIS, but I'm pretty sure that you're going to have to make a trip to OSQL via a command shell call.

The best thing to...

Here's a real cheater method...

SELECT SIGN(SUM(Col1+0)), SIGN(SUM(Col2+0)), SIGN(SUM(Col3+0))

FROM SomeTable

Not sure I spelled it right but...

"Gung hay fat choy"... happy new year!

Also, if the code really isn't "proprietary", post your procedureal code and let us have a go at it, eh?

Kit Brandner (12/22/2008)

---

Try a 23-character long alphanumeric PIN code with certain characters excluded for legibility that can't be repeated in the database. So Jeff's solution wouldn't work. I suppose I...

leonp (12/22/2008)

---

1. This is an Informatica workflow from a UNIX server; reading from and writing back to the SQL server on Windows

2. It has 7-8 processing steps for each of...

In most cases, yeah...

In that case, I dunno what the original problem was.

Heh... ya know? And doesn't the word "kudo" sound cool? Sounds like the name...

Here's the problem with that... long before the move to the new forum on SSC, Matt Miller and I...