Skip to content

how do i divide and add column

i have a list with peoples id and date, the list say when a person Entered to website (his id and date). how can i show for all the dates how many people enter the site two days in a row? the data ( …

Selecting the union part of an sql query

I have this query SELECT L.Account, L.PaidOffDate FROM MARS.dbo.vw_Loans L WHERE L.isActive = ‘False’ AND L.LoanStatus NOT LIKE ‘%REO%’ AND L.LoanStatus ‘Trailing …

SQL Server : select first occurrence from two columns

(Edit: I am bound to use Visual Studio 19 and have no rights to install any other application) I have a small SQL table with about 150k rows and 20 columns which I need to modify. I need the table to be ordered by date. I need the first occurrence of a value from two columns. Depending on if the

Trying to get a column from a Subquery

I need to extract information out of 2 Tables. I can’t join them because there is a resource limit for SQL Queries, which is very low. So I came up with following query. This works quite well, but I …

Filter msdb.dbo.sysjobsteps.command into seperate columns

I am trying to split the msdb.dbo.sysjobsteps.command column into separate columns to show the following information: folder project dtx package A small sample of my data is below: I have tried to use the substring method, however I cannot seem to get the starting and ending number of the substring. My aim is…