Can't you do a simple

INSERT INTO DestinationTable(Col1, Col2, Col3...)

SELECT GrpBy1, GrpBy2, SUM(NumericField)

FROM SrcTable

GROUP BY GrpBy1, GrpBy2;

TinDog,

If you haven't done so already, check out PragmaticWorks.com Brian Knight knows SSAS inside and out. There are a bunch of free tutorials on their website. I think...

Read this article[/url]. Note the warning: "Downgrading to a lower edition cannot be done in place. This tip will describe the steps needed to downgrade."

If you can, install a copy...

Welcome to SSC!

Since you're new and haven't quite figured out how to ask a good question, please help us to help you by reading this article[/url] and following the instructions...

If you create a table of dates for the MWF dates, then you can use ROWNUMBER() to assign a sequential value to each date... then you can find a gap...

If you're using 2012 or later, you can use LAG.

SELECT ID

, FLAG

, LAG(DT, 1) OVER (PARTITION BY ID ORDER BY DT) AS EffectiveDate

, DT AS TermDate

FROM ##Test;

Note that I'm assuming...

I guess if you're forced to do something "clever" then you have to document your code inside the code... not in some "book" somewhere that nobody can find. (Yeah, I've...

What's wrong with the INSERT INTO without all the variables?

INSERT INTO DestTable(col1, col2, col3)

SELECT [DISTINCT]...

a tally or numbers table is perfect for this. Jeff Moden has a great article on it here[/url].

Basically, you join your table that has the quantity you want to...

Maybe he wants to see how painfully slow they are?

Full address is in a single field? That might cause you problems.

If you had zip code/postal code in its own field, you could add a trigger on the table's zip...

Could you please read this article[/url] and follow instructions for posting? It's just really hard to help without consumable data. (Don't worry, it's all explained in the article...

I'm NOT an SSRS expert, and I wanted to read up on this because I was curious.... That said, I found some articles that you might find interesting/helpful:

SQLChick on Querying...

Do you understand how windowing functions work? Read up on the LAG function. It will explain it all.

Like this is one way:

-- show number of days between successive visits

SELECT PatientID

,VisitID

,VisitNo

,VisitDate

,DATEDIFF(day,LAG(VisitDate,1) OVER (PARTITION BY PatientID ORDER BY VisitDate),VisitDate) AS Elapsed

FROM

(

SELECT 1 AS VisitID,1 AS PatientID,1 AS VisitNo,'12-Jan-2005' AS...