You could use something like this CTE

;with numbered as(SELECT rowno=row_number() over

(partition by appt_id, event_id order by appt_id),appt_id, event_id from

appointments)

select * from numbered

Once your sure it...

[? ? ?

Nice question ... I learned something from it so THANK YOU

I believe that you might find your solution using code developed by Jeff Moden .... Read this article:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

I would suggest to get a good answer to your question you post the table definition, and the actual query text AND a copy of the execution plan ... For...

Very nice question ... took a lot of careful reading and thinking ... in fact had to spend more than a few minutes to examine each query and darn...

What bothers me even more are the examples. What is the point of demonstrating tables without keys, with duplicate rows and with every column nullable?? These are not sets at...

Thanks Greg.

Copied and ran all your sample code, conclusion - makes understanding the various operators (EXCEPT, INTERSECT, UNION and UNION ALL ) exceptionally clear.

And the additional tidbits...

Have you considered purchasing a copy of the DEVELOPER edition of SQL Server. Installing it and restoring to it a copy of the production DB. That way the...

In the United States, the National Labor Relations Board sets the rules for union membership. For example:

The majority ruled that workers should generally be deemed supervisors, exempt from union...

Consider utilizing the built in tool available in SQL 2005 and 2008.

Use BOL and search for TABLEDIFF - other than that REDGATE has a tool available for a free 14...

Sha_

Thanks you for replying and posting your modification of the DELETE clause .... now others with a similar problem can learn from what you have done.

From Chad...

These articles by Gail Shaw may assist.

http://www.sqlservercentral.com/articles/64582/

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

And this about what CHECKPOINT can and can not accomplish

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

I can not believe that people are answering INCORRECTLY ..