Sorry, my question was meant to be funny. I do know what BI is, although I'm...

What's BI?

SELECT

parentName

FROM

tblParent

WHERE

...

Being based in the US I don't know how things work in the U.K., but in the U.S. networking is the best way to get a position. Go to...

If you just want employees that have no hours logged in the time frame then bitbuckets solution will work, but if you want a list of dates when an employee...

When you meet the IF condition you are never returning @VesselInfoReportId. You need to either add:

Select @VesselInfoReportId

in the IF after the

Select @VesselInfoReportId = Scope_Identity()

Or move

Select @VesselInfoReportId

Outside your IF..ELSE...

Here's a quote from BOL about MultiValue paramters:

This is...

What is the data type of the parameter in your stored procedure? Sounds like this is your error.

2. Sure you can just add parameters to the SP, you'll...

I doubt it is a permissions issue as long as the ownership chain on all the objects stays (all objects owned by dbo).

The first thing I would do...

I wish I had an answer for you. If you run the query in SSMS do you get the correct results?

Could you try changing your aliases to use "acceptable"...

Can you use IIS Admin to connect to the web server and verify that you have a reportserver virtual directory?

Have you installed reporting services on the other machine? Has the report been deployed to the new machine? Have permissions been granted on the new machine?

I'm pretty sure it can.

You can zip it or rename the file to .txt and attach it to the forum.

Lookup Bulk Insert an bcp in Books On Line.