Just looking at this again, it appears (based on your sample data) that you are looking to do a rolling 3 year average. In that case, you want something like...

A couple things.

First, the order by company in your window clause does not make any sense, I think you want it to be sorting by a date. Second, you...

There are some scripts out there for how to add custom code to your report, you can also handle this through doing some SSRS grouping but each of these options...

MMartin1 (8/26/2016)

---

DECLARE @text VARCHAR(100);

SET @text= ' set

nocounto

n

...

The conventional wisdom is to use Linq to stream XML data. Note this article. I have never used Linq and have heard that it's slow for this; nonetheless, that's one...

blogging

I traveled a lot before my daughter was born and loved it. Since my daugther was born, I only travel when then wife and kid can come with. We're all...

We need more info but here's some code that may help:

-- (1) Some sample data, a sample calendar table for a specific year

IF OBJECT_ID('tempdb..#calendar') IS NOT NULL DROP TABLE #calendar;

DECLARE...

You can download this book for free: Performance Tuning With SQL Server Dynamic Management Views and it has the queries you are looking for.

Thx but that is not really the challenge...

What I need is an expression that will give me the 3 letters that follow the nth occurrence of the key word if...

Matt Miller (#4) (8/25/2016)

---

I'm sorry if I am taking the fun out of building a SQL only solution, but there are lots of basic samples of SQLCLR showing how to...

My strategy (which varies...

ScottPletcher (8/25/2016)

---

Rather than literal strings of spaces, I recommend using SPACE(), just for readability:

/*CREATE FUNCTION ...*/

SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(@Text)),

SPACE(33), ' '),

SPACE(17), ' '),

...

Joins are one of the four table operators in MS SQL Server (the others are APPLY, PIVOT and UNPIVOT). Joins are used for joining tables (real or derived).

INTERSECT, EXCEPT, UNION...

day