Good example of LEAD. As with all things SQL, there are so many approaches to the problem. I do love window functions, and lead/lag are particularly useful. That said, I...

I think this a pretty fantastic vision, really. It's easy to get caught up in the practical challenges of what it would take to even take a meaningful step in...

When I do dynamic grouping, I use a calculated field with a simple switch( Parameters!Parameter1.Value="Text1", Fields.Field1Value ... ) It's easy to read, I can add as many switches as I...

Was this phrased too poorly? Does no one have any idea what the question is?

Surprised to have not had any ideas come up here.

Crickets.

second this.

You guys rock.

Here's an example from a table of appointments that calculates the number of days from the previous appointment for the person:

select

Appt.AppointmentId

, Appt.ScheduledStart

, datediff

(dd,

lag(Appt.scheduledstart) over

(

partition by

Appt.PersonId

,...

that's unfortunate. Thanks for replying. I've been wondering about that for a while, but didn't find any threads anywhere on the shortcuts. cheers

nifty.

Is there any way to structure the shortcut so you don't have to wrap the parameter in ' ', so I could just highlight my database.schema.objectname and execute?