I would start by adding some code to log the start time and end time of your jobs in a table somewhere. Then you can query that for "normal"/average...

one thing that Eirikur left out was the fact that you can grant rights to stored procedures to individual groups/users and save yourself a lot of hassle that way too....

Why not just create a Calendar table with all the dates you want (no gaps!) and then just outer join the other tables to it? Then you can do totals...

maybe something like this?

What are you trying to get in your report? That part's not totally clear. What does the second number mean?

There's some pretty good stuff on YouTube by WiseOwl. A few of those helped me a lot.

depends on what version of SQL Server you're using. In 2012, it's easy:

SELECT personID

, Name

, COUNT(*) OVER (PARTITION BY Name ORDER BY personID ROWS UNBOUNDED PRECEDING) AS NameCount

FROM Person

ORDER...

You have to modify the connection to the database.

How to use a stored procedure for the source of a table in PowerPivot.

1. Go to the DATA tab.

2. Go to From...

Are you using PowerPivot? Sounds like a homework assignment... what have you tried?

Best way? Honestly, I would split off the date to a separate column, and then maybe index it. Then you can just use regular date math. The problem...

The easiest way would probably be to use a calendar table and mark each holiday. Then you could just exclude those from your MAX query. Lynn Pettis posted a...

Here's a grid showing the differences... well, some of them:

http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/express/index.html

So it kind of depends on what you need SQL Server to do. The free versions are okay if you're just...

If you're using the database primarily for storage, you could probably get by with SQL Server Express, which is free. I would suggest downloading Ola Hallengren's scripts to manage...

If you are lucky and have 2012, then you can use LAG, something like this:

SELECT Client_ID

, EFF_FR

, EFF_To

, LAG(EFF_To,1) OVER (PARTITION BY Client_ID ORDER BY Eff_Fr) AS Prev

FROM (

SELECT 1001...

This should work for SQL2008.

Note: I cheated and created a table of dates, so that I could force the existence of every date in the range, regardless of whether there...