[SQL 2012] Cumulative update package 4 for SQL Server 2012 SP1 |
| Cumulative update package 4 for SQL Server 2012 SP1 Posted: 31 May 2013 11:09 AM PDT FYI - [url=http://support.microsoft.com/kb/2833645/en-us]http://support.microsoft.com/kb/2833645/en-us[/url]If you are running SP1 you might want to read - An update is available for SQL Server 2012 Memory Management[url=http://support.microsoft.com/kb/2845380]http://support.microsoft.com/kb/2845380[/url] |
| Posted: 31 May 2013 05:29 AM PDT Hello all. I have a simple query question that should be fairly easy to answer for most casual SQL users. Foremost, I would like to thank all those who check and reply to this post. Your help is much appreciated because I am a complete SQL newbie at the moment.My question...I have a large table that houses food POS data for one client with many different 'store' locations. These locations are large centers -- stadiums specifically -- with multiple 'stand' locations at each stadium. My dilemma is that I want to find all the 'stand' IDs that are doubled between stadiums. For example... I do not mind finding StandID#'s that are doubled in the scope of 1 stadium, but I want to find the StandID#'s that are shared between Stadiums, because my ultimate goal is to consolidate all these ID's and have unique ID#'s that are not shared between stadiums. I started out with this query...SELECT Distinct(StandID), Stadium, FileName FROM [dbo].[Table] ORDER BY StandID...which gives me the information I need, but it leaves me going through a result set of millions of rows to find the doubles within.Does anybody have any advice or comments?Thank you very much |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment