sql-server - List Questions - Page 2

EN VI

Posts (0)

Questions (19)

Best Solution Bot

Sql - Group by where at least one group meets condition?

You can use a windowed sum function for this: with cte as ( select * , sum(convert(int, IsReleased) + convert(int, IsRequired)) over (partition by id) IsIncluded from testt...

Tags: sql, sql-server

Best Solution Bot

Sql-server - Filter the results based on substring in SQL Server?

The real solution is to fix your design. Storing delimited data in your database is bad design, and the problems it causes are many; that you've encountered one today just tells you further to fix you...

Tags: sql-server

Best Solution Bot

Sql-server - How do I list the months for the last 10 years starting from the current month in SQL Server?

Just one option using a ad-hoc tally/numbers table Select N ,YrMth = format(dateadd(month,-N,getdate()),'yyyyMM') From ( Select Top (121) N=-1+Row_Number() Over (Order By (Select NULL)...

Tags: sql-server

Best Solution Bot

Sql-server - How to set up Server for Microsoft 365 Admin Center Search & Intelligence?

Regarding the tricky part of connecting your SQL Server as a data source in the Microsoft 365 Admin Center, it's a bit finicky, isn't it? The format you use for the Server field when adding your Azure...

Tags: sql-server, azure, virtual-machine

Best Solution Bot

C# - SQL Server insert trigger not firing using EF Core?

I'm going to bang the drum again: This idea is a bad idea. Giving the impression to an application/user that things "worked" when they didn't is not a good idea. In this case you say it's "not a probl...

Tags: c#, sql-server, entity-framework-core

Best Solution Bot

Sql-server - Converting numbers with letters into negatives SSIS?

I see you have 80 columns to apply this too. I would seriously consider a script component with your translation done in a method. private static int ConvertToInt(string val) { //split...

Tags: sql-server, ssis

Best Solution Bot

Sql - Stored procedures common sense pattern for dynamic query situation?

Is my thing a regular way of doing these dynamic operations? Yes, this is the recommended way. This type of query is called a Kitchen Sink Query, and your solution is actually a very good one. The i...

Tags: sql, sql-server, t-sql

Best Solution Bot

SQL Server query: match a pattern that does not contain a specific subpattern?

You can use something like: REPLACE(x, 'Page ' + CAST(PageId as varchar(8)) + ' contains', '') LIKE '%Page%contains%' to try to match the odd strings. Note that this will match too much on string con...

Tags: sql, sql-server, sql-like

Best Solution Bot

Node.js - Prisma Client returning an empty array on query?

I was confused with what you wanted, so I'll answer to two questions. If your problem is that the empty arrays are going to the route with status 200, you just need to change the if(!scales) to if(sc...

Tags: node.js, sql-server, express

Pinned Posts

Top 5 Best High CPM Ads Networks For Publishers In 2023

Tags: ads, Publishers, Ads Networks

HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day

Tags: Server, host, cloud