Is the second instance going to fail over at the same time as the default instance?

or are you looking to set them up "opposite" each other in a pseudo...

Funny - I thought the IS guy was the one who had to go in and figure out why the toilet clogged, and the IT guy was the one who...

The only way to dummy-proof SSMS is, well to keep the dummies away from it. There are lots of scarier things that SQL profiler in SSMS (like all of...

Well then, at very least - set down and have the HR folks give you the rule on what you should do. Again - let them MAKE the rules,...

UDT support in 2000 was very limited. Nothing I can recall about it allowed to do anything with changing the precision in any way, since that was tied directly...

K - I could see the financial records history as a problem.

hmm... I think you're trying to solve a human problem with automation, which will lead to more problems....

Hmm... sounds to me that you have a much bigger issue than a design disagreement.

A natural key that will end up with duplicates is no longer a natural key....

Have you considered removing the deduction records as soon as you know John Doe has been terminated?

Mike Levan (6/26/2008)

---

Steve Jones - Editor (6/26/2008)

---

What are you trying to do? You can create a temp table and assign the output of the proc to it.

Can you not perform...

DDL = data definition language. i.e. the CREATE TABLE statement(s) that would allow us to easily recreate your table structures for testing.

Easiest way to do that is...

Go for it! :hehe:

In my mind, the bigger problem isn't that bad code occurs, or that sloppy developers put it out; the bigger problem is that it's allowed to continue to occur, over...

goodguy (6/26/2008)

---

[Quote]CHAR((2*Count(*)) + (CASE Sex When 'M' Then 0 Else 1 End)[/Quote]

Returns the ASCII character for the numeric value returned by double the count for MALE and double the count...

It's ultimately going to depend on what the function is and how it does it. Yes, inlining a function can yield some interesting perf gains, but again, they tend...

Jim Russell (6/25/2008)

---

Jeff Moden (6/24/2008)

---

The major point has been missed... Andras explained it. You need a date column or an IDENTITY column to figure out what the last row...