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...

Sounds more to me like there's a customer here with geographically dispersed offices who doesn't already have connectivity between those offices. Establishing that in such a way...

I would eliminate the dynamic SQL for the primary query, and use a cursor to traverse the primary query, and for each resulting record, use dynamic SQL to query the...

Now I see the difficulty. There's only one scenario where a solution is impossible - that of the end time being MORE than 24 hours beyond the start...

You're quite right! And that's why you're an "Old Hand", and I'm still an "SSC Rookie". I was able to make the same change to my...

Actually, I tried that code and it fails on syntax, due to the ORDER BY clause being present in a subquery. Try the following that uses table variables...