Sergiy (12/7/2015)

---

Alan.B (12/7/2015)

---

I'm with what everyone has said so far. I would add, however, that, if you are doing aggregations, you might want to consider an indexed view with the...

I'm with what everyone has said so far. I would add, however, that, if you are doing aggregations, you might want to consider an indexed view with the aggregations indexed....

This is how you would remove them only at the end:

DECLARE @table TABLE (col1 varchar(100));

INSERT @table VALUES ('address1'),('address2'+char(10)+char(13)),('address3');

SELECT

CASE

WHEN col1 LIKE '%'+char(10)+char(13)

THEN...

Joe Celko has the stable marriage problem (which I believe you are looking for) in his book: SQL Puzzles and Answers 2nd edition.

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...