Application/database design and development is an iterative process. Don't expect to get each piece 100% complete or 100% correct on the first pass...it is generally not realistic. As...

Adam Angelini (3/7/2008)

---

Since the syscomments table can only hold 4000 characters, some stored procedures will be split into multiple records. if this split happens to fall in the middle of...

Rick Harker (3/7/2008)

---

Everyone saying the third option is correct if the case is switched needs to look at what is being checked.

What does the current day of the month have...

Hugo Kornelis (3/7/2008)

---

I picked an answer on each QotD from the very first that was available on the site when I first got here, on to the last. Except...

But you have to test birthdates that are today, tomorrow, yesterday, January 1, April 21, February 29, November 3, etc...

...because your code has to work 100% of the time!

I got it to work, but had to move the condition to the 'FROM'

SELECT a.return_indic,

COALESCE (b.rate_quote_id, '0') AS rate_quote_id

FROM Customer_rate_quote_account_test a

LEFT OUTER JOIN Customer_rate_quote_return_test b

ON (a.cust_id = b.cust_id)

AND...

Hugo Kornelis (3/7/2008)

---

...

I couldn't get any of answers to work 100% of the time...

Here is what I came up with...

declare @dateofbirth datetime

select @dateofbirth = '03/08/1962'

select DATEDIFF(yy, @dateofbirth, GETDATE())

-...

I love this line...note the 'now'...

...it is an advantage NOW because the last guy who had NO knowledge...

sampathsoft (3/6/2008)

---

I dont clear with this answer. So if there are more than two criterias to search, is that theory applicable or not.

ex-

SELECT RefNumber, ProjectName, Type,...

John Rowan (3/6/2008)

---

SELECT a.return_indic,

COALESCE (r.rate_quote_id, '0') AS rate_quote_id

FROM Customer_rate_quote_account a

LEFT OUTER JOIN Customer_rate_quote_return r

...

Have you tried to run the SQL (should be the output of your print statement above) directly in the database, not...

Try checking the joined table value for...

In your SELECT, try this...

select 'href' + columnname

from sometable

Why not hire some poor slob who knows little about SQL Server (as opposed to a SQL Server Guru)...

...that way they won't have to worry about any 'best practices' or...