Here's the cool thing with DAX. You don't need a "proper" data warehouse. it works better if you have one, but it's not necessary. There are a...

If you have a copy of Office Professional Plus, then you can do a bunch of stuff with DAX and PowerPivot. Check out Kasper de Jonge and Rob Collie's...

and it takes a fair amount of time to learn... =) Not to be a wet blanket, but you get out what you put in.

I would imagine there is. Kind of depends on how good you are at SSIS, SSAS and sometimes SSRS. Ask Koen... he does it every day.

you're not joining to the Inserted or Deleted virtual tables, so your result set is not getting filtered. Once you do that, only the affected records will be updated.

Sounds like you tried to run an update query without a filter. You shouldn't need one. Something like this should work.

CREATE PROC uspInsertRecord

@ProductCode VARCHAR(10)

AS

BEGIN

INSERT INTO MyTable(ProductCode, SomeDateField)

VALUES (@ProductCode,GETDATE())

END

You need to return just the date portion of the datetime field. After that, it's easy.

You would have to filter the result set...

DECLARE @StartDateTime DATETIME,

@EndDateTime DATETIME;

SELECT top 100 Ltrim([text]),objectid,total_rows,total_logical_reads , execution_count

FROM sys.dm_exec_query_stats...

Alan,

Yup, I noticed that... The link I posted is to an article by Pinal Dave simulating LAG/LEAD in 2008. Otherwise, I would have posted a query.

I guess he could...

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)

?