I added .mdf and it solved the problem. Another database attached. Thank you so much.

Now I would like to reattach the old 2008 databases, but there is a problem there... if you don't mind saying a few words about it I'd appreciate. The...

OH YOUR BLESSED GOODNESS. My domain account I believe is AKA the Windows account/password I used to log on to my laptop hundreds of times a day.

When...

You were asked what Account are you using for the SQL Server Agent Service? Do you need someone to look at your screen shots to tell you what account you...

Welsh Corgi, I'm not sure why you are alluding to SQL Server Express when I am using 2012. Also, the attached screenshot is of Configuration Manager...

Hellooo Capn Hector to the rescue. Thank you very much.

To answer the first question, I run SSMS as admin by right clicking on the Sql Server Management Studio from start...

This solution works, Thanks Sam.

I have a question about this line:

, startyear = isnull(cast(year(StartDate) AS CHAR(4)), 'All')

I understand ISNULL works because a NULL for startdate is created by the creation...

So, like this? Note the index statement.

select

RANK() over (order by saledate) as rankOrder

, saledate

, saleprice

into #temp

from sales;

select * from #temp;

create index i_saledate on #temp(saledate);

;WITH CTE (rankOrder, SaleDate, [SalePrice],...

Really? That's a compliment that boosts my confidence. Thanks!

Well here's how I solved it.

First, I assigned rank to the saledate so that cumulative totals were not against randomly ordered dates, then I inserted results into temp...

How would you build rCTE when the column against which recursion is done is a SMALLDATETIME column and not SMALLINT?

Do I need to first order the dates using...

Alan aka XMLSQLNinja. Thank you very much for the careful response and particularly for the rCTE. It was what I was after, but I had not felt I had...

when I said thanks to you, Luis, it was for the relationship advice, not the palindrome idea.

OK, so you reverse the expression, find the character you want, perform the operation, and then reverse the expression again to aright it.

I have seen such situations arise, I...

to avoid rollup by empid I used sum functions with each which allowed me to group by with rollup against just yrOrdered and moOrdered.

This query produces the results I wanted:

SELECT...