Saturday, June 1, 2013

[SQL 2012] Cumulative update package 4 for SQL Server 2012 SP1

[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]

Simple Doubles Query

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

No comments:

Post a Comment

Search This Blog