I suspect if you replace the word JOIN with a comma, that problem may go away.

On the LIKE operator, the expression 'abcde' LIKE '%b%' is TRUE, while the expression 'abcde'...

There's going to be a problem here. If there's no place to reference a date associated with the goods being received, you're in trouble, as TOP n queries...

Well... I just realized that your last example data breaks my query's sort mechanism, and also doesn't have the 2nd occurrence of 4 in the list show up in the...

Looks like an auxiliary table of numbers might do the trick, and I'm assuming that every possible value in the list for the Emp_cat field is numeric. Try...

INSERT statements that have a SELECT can't transform rows into columns, so the error you're getting is exactly what's wrong. Your SELECT statement that follows the INSERT statement...

I'm thinking along the lines of the following:

UPDATE projects_table

SET END_DATE = A.END_DATE

FROM projects_table AS A LEFT OUTER JOIN projects_table AS B

ON B.project LIKE A.project+'%' AND

...

If I understood you correctly, you may need to take the record in your caracter table that has the ? in it and delete it. I think a...

Hi all,

I have a partial solution that should be able to be extended into a complete one. I just don't have the time right now to finish it. ...

Ok, but how about an example of the nature of the relationships? There are far too many ways to put together many-to-many relationships to know what's going to...

I'm getting bug-eyed just trying to interpret the statement with the huge number of quote marks. Is there a reason to have 5 quote marks in a...

On the assumption that your date field is of the DateTime data type, AND that the time portion is always midnight, you could do as follows:

DECLARE @START_DATE DateTime, @END_DATE DateTime

SET...

I can't quite see what you're looking to accomplish. "N to N relationship" could mean a lot of different things to different people. Can you provide...

I'm going to have to SLAP myself... My brain apparently had a senior moment and thought it saw ROW_NUMBER when what it actually saw was an Identity...

EDIT: PLEASE IGNORE THIS...

I'm glad you were able to get a solution, but given that this post is in the SQL Server 7, 2000 portion of the forum, and your...

I'd like to see a financial application do any sizable report without performance issues where a web API provides the connectivity before concluding that anything less than VPN is sufficient...