Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed last year. Improve this question There are two tables in 2 different databases one table consists of Salutations example Mr, Mi…
Tag: tsql
Why Row_Number in a view gives a nullable column
I have a view using a CTE and I want use a row number to simulate a key for my edmx in Visual Studio When I look in properties of column I see Id bigint … NULL And my edmx exclude this view cause don’t find a column can be used to key When I execute my view ID have
How to calculate rows count in where statement in sql?
I have two tables in SQL Server: order (columns: order_id, payment_id) payment (columns: payment_id, is_pay) I want to get all orders with two more properties: How many rows where is_pay is 1: And the count of the rows (without the first filter) So I wrote this query: The problem is how to calculate the rows …
TSQL to perform aggregation with Exists
My sample data source is following I want SQL to check if there exists any row with cond=X or cond=Y by site and if yes, don’t perform any aggregation; if no, perform a sum of val. I am currently achieving it by following Method1 Method 2 I was wondering if there is any better way of achieving this. Edi…
Adding x work days onto a date in SQL Server?
I’m a bit confused if there is a simple way to do this. I have a field called receipt_date in my data table and I wish to add 10 working days to this (with bank holidays). I’m not sure if there is any sort of query I could use to join onto this table from my original to calculate 10
Extract data from a historical table keeps only data with changes
I have a table like this and here is the log table So as you understood, my main table contains data from a source every day. But keeps only those with changes. Thus if everyday if 100k records comming normally, but very few (<100) are really has some changes. Thus my table tracks all the records using the…
Trying to exclude certain users
New to SQL but I’m trying to find titles wherein the words “blue” and “black” are present. However, they cannot be from users who have ids of 1 and 5. This is what I did: However, when I add that id 1 and id 5 shouldn’t be in the query, it shows me something like this: Blog…
Select data based on certain set frequency
I have the following table settings What I need is to select the entry based on whether it is allowed to trigger on date that or not. So lets say for example for the following entry id:xxx, trigger_metric: MONTHS, trigger_frequency:1 , trigger_start_date:’2021-09-01′ the row should be selected on …
Two intervals coincide at some point in SQL-Server
How to know if two intervals coincide at some point? I have two tables that store two intervals where the values mean meters. The first interval corresponds to geological codes (VBv, P4, etc). The second interval corresponds to samples. They are connected through a field called Hole ID. I need all the sampl…
How to parse comma delimited list and join those values on another table and reconcatenate? [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed last year. The community reviewed whether to reopen this question last year and left it closed: Original close reason(s) were n…