In SQL Server 2012 and later, you have the luxury of 1) analytic functions, and 2) running totals: declare @t table ( Id int primary key, Value int not null ); insert into @t (Id, Value) values (1, 3), (2, 3), (3, 2), (4, 2), (5, 2), (6, 3), (7, 0), (8, 0); select sq.Id, … Read more
In UI, you can use BindingNavigator. In code, you can use BindingSource.MoveNext() or change this.BindingContext[datasource].Position. OP: Some Data bindingNavigator function I seen somewhere but can’t get it. If this option is good option then please add a link in comment plz… As a quick start to create a data application: Show Data Source Window from … Read more
The (localdb)\ProjectsV12 and (localdb)\ProjectsV13 instances are created by SQL Server Data Tools (SSDT) and should not be used by applications (localdb)\MSSQLLocalDB is the SQL Server Express 2014/2016 LocalDB default instance name and an “automatic instance”. You can use the sqllocaldb.exe command line tool to manage which version (2014 or 2016) owns the MSSqlLocaldb instance And … Read more
Another Option. This function will replace control characters and correct any residual repeating spaces. For example Jane Smith{13}was here will not be returned as Jane Smithwas here, but rather Jane Smith was here CREATE FUNCTION [dbo].[udf-Str-Strip-Control](@S varchar(max)) Returns varchar(max) Begin ;with cte1(N) As (Select 1 From (Values(1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) N(N)), cte2(C) As (Select Top (32) Char(Row_Number() over … Read more
There is a very simple solution using dense_rank() dense_rank() over (partition by [Mth] order by [UserAccountKey]) + dense_rank() over (partition by [Mth] order by [UserAccountKey] desc) – 1 This will give you exactly what you were asking for: The number of distinct UserAccountKeys within each month.