Thanks for the reply.

It is not quite that simple. In your scenario, the user would enter a date as the parameter and would get back all records newer that that...

Thanks tp all for your suggestions.

We eventually found a service running in the background for an old data warehouse product (Wherescape Red) that had started up and was trying to...

Take a look at this solution:

http://sqlblogcasts.com/blogs/drjohn/archive/2007/11/04/downloading-excel-files-from-sharepoint-using-ssis.aspx

Sharepoint is not an available data source in SSIS, so you will have to do some scripting.

Yep - that's it. Did you find that somewhere or just figure it out with trial and error. That's probably the only combination I didn't try (= nothing, is nothing,...

This is for Report Builder 1.0 (SQL 2005). It looks like Report Builder 2 uses the same expression syntax as used to build .rdl reports in Visual Studio (which makes...

Me neither - or anywhere else.

Leave it to Microsoft to implement a proprietary expression syntax different from all others in the BI stack (SSRS and SSIS use different expression syntaxes)...

The query is not accessible by the users - it is captured as a named query in the DSV of the Report Model.

The replacement value has to be user configurable,...

This is what I came up with. Client, date and shift for missed logs are returned.

DECLARE @startdate SMALLDATETIME

DECLARE @enddate SMALLDATETIME

DECLARE @date SMALLDATETIME

DECLARE @costcentre int

SET @startdate = '2009-09-01'

SET @enddate = '2009-09-30'

SET...

This is getting close, but there needs to be a way to identify the shift (am or pm) where the log was missed.

I'll post my solution when I have it...

row_number() is not supported either...

That is true. CTE is not supported in SQL 2000

Lowell:

Your logic is going to work I think, but this project is for a SQL 2000 server, so no CTE's, row numbering, etc.

I'm working on a solution using a temporary...

Thanks for the reply. I wish it could be that simple. I need to be able to return clients with no entry on either shift, and I also need to...

I think you have to put your TRY block inside of your transaction. Just switch the order of the BEGIN TRY and BEGIN TRAN statements and try it.

Something like this will give you the result. I would assume your real data includes some determinant for the 'earliest' record in a case where the date is the same...