Here is everything you need, including the DDL, DML, and expected result set. I just combined everything so you don't have to refer to three different posts. You can open...

That's what I get for using Textpad (for the macros) to produce the sample dataset instead of SSMS, lol. Anyways, I PM'd the changes to you.

I'll try to get you a better sample dataset. Working on it now.

Lynn Pettis (4/20/2009)

---

Looking at the code and such, I think I know what is going on. Can you post the actual execution plan for the query? I suspect...

Ah yes, it sure does....

I'll try to get better sample data tomorrow if that's what you require. Also, all the queries and DDL are there (some code is in the very first post). The...

I realize that, but I'd have to modify the queries to...

Lynn Pettis (4/20/2009)

---

Could you post your code as well? I wouldn't be surprised if the problem with performance is actually related to your scalar function for converting the IP...

Lynn Pettis (4/20/2009)

---

Would you please post the DDL for the base tables including indexes, some sample data for both tables (in a readily consumable format that can be cut, paste,...

I believe I finally figured it out. I was able to queue up 7 reports successfully without any errors or 'default' reports being pushed out. It all lies in the...

I am able to run a file share-based subscription successfully. I put the credentials in when I originally created the subscription. The only problem I have now is that unless...

Try this...

Try something like this (untested):

UPDATE tblImage

SET imgData = (SELECT BulkColumn FROM

OPENROWSET(BULK N'F:\MUKESH PERS\Images\200810A0\Image026.jpg', SINGLE_BLOB))

WHERE (imgID = 5)

Of course, replace the imgID = 5 with the correct ID.

makjain (11/29/2008)

---

Below is the query which i know to insert an image but i dont know how can i modify this query and insert at specific row.i.e. with WHERE clause.

In...

No one has any advice on this? Do you require more information?