Tag: sql-server

I need to find overlapping dates for a table. So the basic structure is ID, PFX, Start date, and end date. So where the PFX for a given ID is overlapping with another PFX for each ID. I tried this and had no luck. https://www.sqlservercentral.com/forums/topic/how-to-extract-overlapping-date-ranges-from-a-tabl…

so I have SQL table with many lines. It looks like this (just a couple lines from the top): I need to disperse revenue according to project duration equally every 2 months starting first month. So desired result would look like this: What’s the baest way to achieve this? Answer You can use recursive cte…

I have the following code where I’m trying to dynamically Pivot the table. Everything seems to be working the way I want except I want to replace the null with ‘-‘. Any ideas? Answer You need to put the coalesce into the dynamic column list – something like this: The isnull(@Columns1&#…

I wrote a trigger on update on table [CART] to count and insert value to other table [HEADERS] to column [SUM]. It works but only for 1 row where [CART].[NUMBER] = [HEADERS].[NUMBER]. Column [NUMBER] …

I want to store the results into table with same name as per the condition. How to achieve the same ? Following is the code: While executing it throws error that #a already exists. IF @Input =’1′ …

I have an issue where I want to join two tables where there is 1 record on the left and many on the right side but only need information from the right that exists in all of those records – in other words, insist on only getting 1:1 not 1:n in my results. Example, if I run this statement below,