Sean Lange (12/7/2015)

---

As of today I have only taken 4 days of PTO this year. REALLY looking forward to taking the family to Disney world later this week. My wife's...

DECLARE @TableA TABLE (ProbID int, Describe varchar(100), TableAID int);

INSERT @TableA VALUES (1,'Describe Test the theory',1);

SELECT * FROM @TableA;

UPDATE @TableA

SET TableAID = TableAID+1;

SELECT * FROM @TableA;

Use print preview while developing and make adjustments accordingly. Print Preview will show you exactly what your PDF is going to look like.

This is a little more BI-centric but The Microsoft Data Warehouse Toolkit, 2nd Edition[/url] had a few good chapters to help get you started. There's a good amount in there...

Can you post some DDL and sample data? It would be helpful to understand, too, where the dates in your second result set are coming from.

Just ran across this. Good, good stuff.

That's not T-SQL.

It is MDX? If it is, you'll need to look up the MDX date manipulation functions, they're not going to be the same as the T-SQL ones....

<removed>... somehow duplicated my post when editing it.

Aditya Daruka (12/3/2015)

---

Recursive Solution

-- sample date

DECLARE @rng-2 TABLE (Id INT, RangeStart BIGINT, RangeEnd BIGINT, Category INT, NumberCount INT)

INSERT INTO @rng-2

SELECT 123, 120000006660, 120000006690, 5, 31 UNION ALL

SELECT 123, 120000011660, 120000011670,...

+1000

When I first got into technology/programming in 1996 I was reading "DOS for Dummys" and remember the author...

Luis Cazares (12/3/2015)

---

To always return a row, either with a value or a null. I might have done...

I usually do that to get a single value but don't have a clue why I did that....

First, I don't know if you noticed or understood the motivation by Luis' comment in his code about why he changed it to varchar(8000) from varchar(max). You only want to...

It is worth noting that you will need an ORDER BY in your OVER clause for this to work.

I terminate all my SQL statements with a semicolon because, apparently, you are supposed to. If anyone is interested in an intellectually stimulating article on the subject see Itzik Ben-Gan's...