This worked for me: Install SSDT-BI for Visual Studio 2013. Open your solution in Visual Studio 2015. Select your SSIS Project in the Solution Explorer. In the Project menu select Properties. In the Property Pages dialog select Configuration Properties -> General Under Deployment Target Version change the Target Server Version to “SQL Server 2014.” Clean … Read more
If you do not maintain a counter table, there are two options. Within a transaction, first select the MAX(seq_id) with one of the following table hints: WITH(TABLOCKX, HOLDLOCK) WITH(ROWLOCK, XLOCK, HOLDLOCK) TABLOCKX + HOLDLOCK is a bit overkill. It blocks regular select statements, which can be considered heavy even though the transaction is small. A … Read more
SELECT MIN(MinuteBar) AS MinuteBar5, Opening, MAX(High) AS High, MIN(Low) AS Low, Closing, Interval FROM ( SELECT FIRST_VALUE([Open]) OVER (PARTITION BY DATEDIFF(MINUTE, ‘2015-01-01 00:00:00’, MinuteBar) / 5 ORDER BY MinuteBar) AS Opening, FIRST_VALUE([Close]) OVER (PARTITION BY DATEDIFF(MINUTE, ‘2015-01-01 00:00:00’, MinuteBar) / 5 ORDER BY MinuteBar DESC) AS Closing, DATEDIFF(MINUTE, ‘2015-01-01 00:00:00’, MinuteBar) / 5 AS Interval, … Read more
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.