The Dixie Flatline (5/17/2010)

---

My wife had an interesting thought about plagiarism, which was that websites should NOT take down those articles. Instead they should keep the title, the...

[CuriousMode]

Care to share this trick with us? Might be able to learn something new...

[/CuriousMode]

oh wait... is it...

LOL! I should have known Paul would show a CROSS APPLY.

I HAVE to start thinking... can this be done with a CROSS APPLY? I just don't consider it.

I also...

Instead of passing all those dates to the database to be added in one at a time, why don't you make a stored procedure and pass just the starting and...

see http://msdn.microsoft.com/en-us/library/ms186734.aspx

and http://www.sqlservercentral.com/articles/T-SQL/69717/

lmu92 (5/14/2010)

---

Ok, the easy stuff first: OP = original poster = the person who started the related thread (in this case: you). That's not a dumb question at all!, since...

krenshau (5/14/2010)

---

Jeff, I have been thinking about whether or not to reply to your post. First, thank you for informing me of the rules. However, I find it interesting that...

Try this link.

Since you're...

elutin (5/14/2010)

---

Try this:

SELECT *

FROM (SELECT ROW_NUMBER() OVER (PARTITION BY PropID

ORDER BY LatestApptDate desc ) AS PARowNumber

,PrevApptID

...

I like Manu's suggestion.

Doing something like this, deleting large # of records without affecting up-time or users, is one of the few things that are best done in a loop,...

I think it was just right, Gail!

Here's two methods to accomplish this:

-- See how you start off by actually creating a table

-- and then inserting the data into it? Doing this really

-- makes things a...

Stefan Krzywicki (5/14/2010)

---

Any new comments on a post still show up on the main page under "Latest Forum Posts", right?

Maybe if there were another page that lists more of the...

Check out ROW_NUMBER().

And read my article[/url] on how to use the row_number ranking function.