Found an article at SQLAuthority that covers your options:

Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function[/url]

these must be text...

SELECT *

FROM MyTable

WHERE RIGHT(MyColumn,1)='.'

performance is going to be abysmal, because it's a trailing character, so you're going to get a table scan.

I think I got it... and it's not even an April Fool's joke...

I give up (for now)... this is as close as I got. Can't figure out how to do the

Count

Percent

part. The rest works a champ.

Grrr... I hate SSRS... in a minute I'm going to give up and try this in Excel!!! SSRS absolutely BLOWS!!!

Something like...

=Mid(ReportItems!txtNameAddress.Value,InStr(1,ReportItems!txtNameAddress.Value,"(")+1,Len(ReportItems!txtNameAddress.Value)-InStr(1,ReportItems!txtNameAddress.Value,"(")-1)

?

Looks like if you created a subreport for this part:

1--------------------------contacted--------------------2-------------1-------------1-----------0----->

1-------------------------%contacted-----------------66%----------100%---------50%----------0%---->

1--------------------------interviewed------------------1-------------0-------------1------------1----->

1-------------------------%interviewed---------------33%----------0%-----------50%----------100%-->

You could do the % under that, and you'd be good to go, right?

In a word, Normalize your table. Then this is stupid easy. Repeating fields are going to make your life miserable.

Took me a while to find it... and stop sitting on Itzik's book and actually read it. Got any good references for learning the hardert part of T-SQL queries...

"CTEs cannot be nested" Are you sure? http://stackoverflow.com/questions/7306191/how-to-nest-cte-properly

and what's with all those NOLOCK hints?

https://www.simple-talk.com/sql/database-administration/grant-fritcheys-sql-server-howlers/

I had this kind of fun just today on SSRS 2012. I went into the dataset and re-ran the query from within SSRS. that fixed it for some...

I need to change the code so the report selects data 14 days before and 14 days after the selected date.

WHERE [DateColumn] BETWEEN DATEADD(days,-14,@DateParameter) AND DATEADD(days,14,@DateParameter)

not sure about the sequence...

What are you trying to do? (Explain the business part, not the math.)

Can you give a really simple example? Do you have a table you're trying to join...

Short answer - you need to turn this into a totals query and group by everything but the date. Get MAX(Date). Or use a subquery to return only...

Maybe it's the lack of coffee or something, but the basic matrix is simple, but getting the % of Internal at the bottom as a pain. (I'm starting to think...