Does the user that you're logged in as have permissions to that object?

This doesn't address the filename, but you don't need the Enterprise version...

http://www.sqlservercentral.com/columnists/jselburg/2824.asp

Can you post sample data and table definitions along with an example of what you are trying to do?

If you post the Create scripts and some sample data along with what you expect, I'm sure someone on this site could help you a bit more.

It's rather difficult to...

Sorry, but your question is extremely vague. Can you post the create scripts for the "table #1" and more detail on what you want the output to look like.

No, you can just place one report viewer control on your page, and then through code apply the settings depending on which report you want to run.

Red Gate SQL Compare works wonders!

I think this question and it’s answers bring up a missing job-title “DBevloper”, or the lack of true definition in job roles.

There is definitely a...

-- EDIT -- sorry, I posted to the wrong question and removed it --

I have NO experience with extended stored procedures, but my first thought is ...

Change:

set @FileExists = 'xp_fileexist '''+@PathFileName+''''

To:

set @FileExists = 'master..xp_fileexist '''+@PathFileName+''''

AGAIN, JUST MY 1.5 cents!

ANSWER: Nope, you don't get the job!

REASON: Not enough Posts on this site! [Smile]

The solutions you guys posted update the ORDER's table from the ORDERDETAILS.

What Mark was doing is the opposite, updateing the ORDER DETAILS table from the ORDER's table. this is why...

Sergiy,

Isn't this backwards from what Mark is doing or am I looking at it wrong?

Using your example, He's updating the OrderDetails table from the Orders table. I understand this is...

Longshanks,

We had a similar issue with a site we just built. Our date (when NULL) was changed to ‘1/1/1900’, then in the PreRender of the GRID caught...

OK, I now have egg on my face! 🙁 I was making an assumption, and we all know what that does.

I should have tested this before opening my...