Lynn,

Well put. I couldn't have said it better myself.

(I considered doing a quoted reply, but I wasn't sure whether or not we get points for acreage.)

😀

How much is SQL Server Developer Edition? $150.00? Something like that. Doesn't have to run...

Why not just throw it on to a Developer instance?

I suppose we could probably put our subscription fees to better use.

:smooooth:

Steve must be off for a couple of days. The newsletter was published today, but I didn't get it by email. The editorial was by Tony. After he sees this...

All you really need to know is how to open a command window and type "HELP".

It does require an understanding of the Command language (formerly DOS). Do they even teach that any more?

Perhaps they figured out how much fun we have reviewing them ourselves.

:hehe:

elmerbotha (6/23/2008)

---

Thanks a lot! I will see how I can implement all that you've given me. Regarding throwing away useless values and replacing them: The store procedure returning the result...

sl.sajeev (6/23/2008)

---

Yes you are correct. Actually i posted it as a...

smunson (6/23/2008)

---

This is despicable - a QOTD where the supposedly correct answer is quite clearly incorrect, unless you happen to take an extraordinarily ODD interpretation of the question and assume...

evifra (6/23/2008)

---

"You have a table with EmpName and DateOfLeaving columns. The EmpName column is mandatory, but DateOfleaving will have null value for those employees who have not left the company....

That's just wrong. :hehe:

DECLARE @Employees table (

EmpName varchar(5),

DateOfLeaving datetime

)

insert into @Employees select 'Abc', '10 Oct 1999'

insert into...

After losing a 10 minute reply to some kind of session timeout :w00t:, I'm going to just brief it now.

Great, true, and positive stuff has already been posted.

I'm a .NET...

paulhunter (6/21/2008)

---

What a let down. I was expecting an article on good database design practices. Instead we're treated to another diatribe on naming conventions. About the only...