If I were you I would isolate the sub query that's causing the problem, so...

Comment out all sub queries and run.

Introduce them back in one at a time.

As...

David Burrows (5/5/2009)

None. I'm in the UK and did not make it to University (did not even do A Levels). Did attend Technical College for...

I wonder how many people have actually made a choice to be a DBA? - Like 'I want to be a doctor, lawyer etc'

The gist I am getting from...

It's interesting how a lot of people think their degree hasn't played a major part. For me...

1. Without it I wouldn't have got my foot in the door

2. It...

Thanks Flo, just built that into a little stored procedure - should come in handy 🙂

BSc in Economics, A-Levels in IT, Business Studies and Economics.

Joined a small company in a non IT capacity - spent a small amount of time on small problems - as...

Nice - works perfectly! - Thanks GSquared (again!)

This little thing should save me quite a bit of time, pedantic as it may seem!

Thanks GSquared.

In my original function I tried adding the CHAR(10) or CHAR(13) to the end of the string (i.e. after the comma) and set results to text - it...

Thanks Michael, I believe I am registered on SQLTeam too so I shall give those a look.

I seem to be doing lots of date related stuff at the moment, luckily nothing involving dates in such a format, however, I'm sure a time will come - this...

Because I wanted to know how to do it in SQL - it will be a useful thing to know for something else I have coming up, and something else...

Thanks Vijaya Kadiyala, that worked fine. I think my example I posted was essentially the same except the wierd bit:

WHERE (b.Year_of_Purchase <= a.Year_of_Purchase) as Running_Totals

according to the original article:

SELECT a.DayCount,

...

Hmm based on http://www.sqlteam.com/article/calculating-running-totals

this should work, alas, it does not!

SELECT

year(subscription_date) as Year_of_Purchase,

count(sub_id) as Total_Purchases

INTO tmpTest

FROM tblpurchases p

GROUP BY Year(subscription_date)

SELECT a.Year_of_Purchase, a.total_purchases, sum(b.total_purchases)

FROM tmpTest a

CROSS JOIN...

I've started to give this a go this afternoon, however, I've ran into problems creating the data flow diagram.

When I click on the data type box on for one...

:/

Just found out we are on Workgroup edition and this only runs on Enterprise or Developer editions :/

Back to the drawing board I guess.