Viewing 15 posts - 496 through 510 (of 2,458 total)
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...
-- Itzik Ben-Gan 2001
August 30, 2016 at 10:54 am
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...
-- Itzik Ben-Gan 2001
August 30, 2016 at 10:00 am
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...
-- Itzik Ben-Gan 2001
August 26, 2016 at 1:27 pm
MMartin1 (8/26/2016)
DECLARE @text VARCHAR(100);
SET @text= ' set
nocounto
n
...
-- Itzik Ben-Gan 2001
August 26, 2016 at 12:16 pm
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...
-- Itzik Ben-Gan 2001
August 26, 2016 at 11:58 am
djj (8/25/2016)
Ed Wagner (8/25/2016)
Y.B. (8/25/2016)
ZZartin (8/25/2016)
Ray K (8/25/2016)
crookj (8/25/2016)
Ed Wagner (8/25/2016)
Alan.B (8/25/2016)
BWFC (8/25/2016)
Prefectday
Night
Stalker
Talker
Dead
Walking
Running
Jogging
blogging
-- Itzik Ben-Gan 2001
August 25, 2016 at 9:51 pm
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...
-- Itzik Ben-Gan 2001
August 25, 2016 at 9:46 pm
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...
-- Itzik Ben-Gan 2001
August 25, 2016 at 9:17 pm
You can download this book for free: Performance Tuning With SQL Server Dynamic Management Views and it has the queries you are looking for.
-- Itzik Ben-Gan 2001
August 25, 2016 at 8:32 pm
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...
-- Itzik Ben-Gan 2001
August 25, 2016 at 8:29 pm
Matt Miller (#4) (8/25/2016)
-- Itzik Ben-Gan 2001
August 25, 2016 at 3:57 pm
Luis Cazares (8/25/2016)
The Dixie Flatline (8/25/2016)
But isn't the problem with just replacing spaces is that it doesn't deal with other special characters?It depends on what you're doing.
My strategy (which varies...
-- Itzik Ben-Gan 2001
August 25, 2016 at 1:30 pm
ScottPletcher (8/25/2016)
/*CREATE FUNCTION ...*/
SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(@Text)),
SPACE(33), ' '),
SPACE(17), ' '),
...
-- Itzik Ben-Gan 2001
August 25, 2016 at 12:25 pm
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...
-- Itzik Ben-Gan 2001
August 25, 2016 at 5:22 am
BWFC (8/25/2016)
Prefect
day
-- Itzik Ben-Gan 2001
August 25, 2016 at 4:55 am
Viewing 15 posts - 496 through 510 (of 2,458 total)