Viewing 15 posts - 991 through 1,005 (of 3,221 total)
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...
September 8, 2011 at 5:25 pm
SQLRNNR (9/7/2011)
Nice question. Thanks to DBCC Timewarp we were able to answer the Oct 14 question over a month early. :-D:-D:-D:-D
[? ? ?
September 7, 2011 at 10:17 pm
Nice question ... I learned something from it so THANK YOU
September 7, 2011 at 7:56 pm
I believe that you might find your solution using code developed by Jeff Moden .... Read this article:
September 7, 2011 at 12:32 pm
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...
September 5, 2011 at 9:48 pm
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...
September 5, 2011 at 9:42 pm
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...
September 5, 2011 at 3:39 pm
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...
September 5, 2011 at 12:09 pm
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...
September 5, 2011 at 10:49 am
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...
September 5, 2011 at 9:58 am
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...
September 5, 2011 at 7:57 am
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.
September 4, 2011 at 8:20 am
Welsh Corgi (9/3/2011)
bitbucket-25253 (9/3/2011)
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
I got "Page Not Found" on the first and third link.
From Chad...
September 3, 2011 at 8:34 pm
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
September 3, 2011 at 6:55 pm
I can not believe that people are answering INCORRECTLY ..
September 3, 2011 at 4:55 pm
Viewing 15 posts - 991 through 1,005 (of 3,221 total)