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...

If this is beginner homework (which I doubt!), then someone is really yanking your chain.

I would probably write a stored procedure to link up the Login to the Logout times......

Just wondering, who is putting you up to something like this? I can see this going sideways very fast. Without understanding what you're really trying to achieve, I'm hesitant...

could you post the structure of the table and some sample data? Should be fairly easy. You might have to do a summary query to do the counts and then...

Use a TRY/CATCH block and return the message in the CATCH block?

Here's another option... use the OUTPUT clause to insert some/all of the records inserted in your stored procedure to another table:

http://www.databasejournal.com/features/mssql/tsql-understanding-how-to-use-the-insert-statement-to-populate-your-database-tables.html

Basically imitates a trigger without all the nasty side effects.

How are you doing the insert into the first table? Is it a bulk insert or one at a time? You might be able to create a variable...

Did you look in the Articles section for Calendar tables?

Todd Fifield's articles

http://www.sqlservercentral.com/articles/70482/%5B/url%5D

http://www.sqlservercentral.com/articles/T-SQL/70743/%5B/url%5D

http://www.sqlservercentral.com/articles/T-SQL/72345/%5B/url%5D

Then you'd just add your rule(s) to the Calendar table so that you could roll up your data any...