Sql Server – Finding next gap in a numeric column
by Rahul Singla | Mar 13, 2024 | Programming Techniques, Sql Server, Sql Server 2005, Sql Server 2008
I was recently tasked with improving the performance of one of our Sql Server Stored Procedures which found and returned next available Profile Number for new Profiles to be created in the application. Although the actual circumstances were considerably more complex,...Recent Posts
- Isolating Bootstrap 5.3.3 or later for avoiding conflicts
- Ext JS – Resolving [ERR] Cannot satisfy requirements for “modern”! when building packages
- Sql Server – Finding next gap in a numeric column
- Git – Recovering from bare Remote Repository corruptions
- Git – Fixing a botched commit / push to a bare repository
Archives
- September 2024
- March 2024
- January 2024
- May 2023
- January 2023
- July 2021
- June 2021
- September 2020
- August 2020
- April 2020
- March 2020
- May 2019
- October 2015
- October 2014
- September 2014
- November 2013
- March 2013
- September 2012
- August 2012
- June 2012
- May 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
Categories
- .NET 2.0+
- .NET 4.0+
- .NET 4.5+
- AS 3
- ASP.NET
- ASP.NET 4.0
- ASP.NET MVC
- Blog
- Bootstrap
- Bootstrap 5.x
- C#
- Coolite
- Crystal Reports
- Custom Controls
- Desktop App
- DNN 5.x
- DNN 6.x
- DNN 7.x
- DotNetNuke
- DotNetNuke 4.x
- DotNetNuke 5.x
- DotNetNuke 6.x
- DotNetNuke 7.x
- Drupal
- Drupal 6.x
- Drupal 7.x
- Drupal 8.x
- Drupal 9.x
- Encryption
- EWS Managed API
- Exchange
- Exchange 2007
- Exchange 2010
- Ext.Net
- Ext.Net 1.x
- Ext.Net 2.x
- ExtJs
- ExtJs 3.x
- ExtJs 4.x
- ExtJs 6.x
- ExtJs 7.x
- ExtJs Classic
- ExtJs Modern
- ExtNuke
- Flash
- Git
- HighCharts
- IIS
- IIS 7
- Javascript
- JME
- jQuery
- jQuery UI
- Office
- Open Xml Power tools
- Open Xml SDK
- PHP
- PHP 5.x
- PHP 7.x
- PowerShell
- PowerShell 2
- Programming Techniques
- Sencha Touch
- SMTP
- Software
- Sql Server
- Sql Server 2005
- Sql Server 2008
- Swing App
- TC/TC++
- TeamCity
- TeamCity 8.x
- Touch 2.x
- VB.NET
- Views
- Views 3.x
- Visual Studio
- Voip Drupal
- Web App
- Windows
- Windows 7
- Windows Server
- Windows Server 2003
- Windows Server 2008
- Windows Server 2012
- Word
Recent Comments