Oh yeah, this is the same Microsoft that recently stated they can't find enough qualified workers in the US, and they say we have to import IT help from other...

dave platt (4/28/2008)

---

Customer:

Ref varchar(10)

Invoice:

InvoiceNumber int, CustomerRef varchar(10)

InvoiceDetails

id int, InvoiceNumber int, CustomerRef varchar(10)

SELECT inv.*, det.*

FROM Invoice AS inv

INNER JOIN

InvoiceDetails AS det

...

I don't volunteer a salary history because I don't want that to be the main consideration before I even get to the interview. I consider my last salary irrelevant...

Remember that 'datetime' stores time out to the milliseconds...

'mm'dd'yyyy hh:mm:ss.###'

Your comparison datetime is only showing seconds...'3/20/2008 9:51:30'.

Check your data to see if your datetime column values have a millisecond component...

Like others have said, if you don't know an answer, be honest about it. Trying to talk your way thru something you don't know undermines your integrity (if you...

Yes, great question, just not implemented properly.

I am curious to how the question author missed the length for the nvarchar columns. Or am I missing something?

Try this...

GROUP BY #tempRespPriceSummary.ID_PRODUCT

Before I used a sub-table for each different product type, I would use a single 'ProductAttributes' table, and an attribute lookup table to hold an instance of each attribute. ...

Ok, here's a replacement question...

Q. What query would return the employees whose 'join_date' (from the employee table)

was in a month that has 28 days in it? (assume 'join_date'...

What is it about the data (records) that are being returned is not correct?

Are you getting too many records, too few records, none at all?

Start with your embedded query (I...

Here are some interesting links...more stuff on SQL than you ever wanted to know.

http://www.sqlservercentral.com/articles/Miscellaneous/abriefhistoryofsql/1125/

http://en.wikipedia.org/wiki/SQL

This was quoted from wiki, but also on the other link.

The acronym SEQUEL...

GSquared (4/4/2008)

---

They may or may not prefer to say it letter-by-letter, they're kind of required to by the fact that Sequel was an IBM trademark (might still be one, but...

I view education of any form, whether formal or informal, as the one thing that can't be taken away from you. It is an investment in yourself, and personally, I...

Sequel for me too...sounds funny when I hear people say 'S-Q-L Server'.

In my experience it has been non-users that say it spelled out. Now you go and tell me...

...you mean like...