change all the snippets like this:

...where codrf = (select ...

--TO

...where codrf IN (select ...

and somewhere in code you did not post, you have something like this:

...AND SOMECOLUMN IN= (select *...

Elliot's Project makes the image insertion really simple;

here's a code example...once you have the CLR in place, it is soooo simple:

CREATE TABLE myImages(id int,filename...

in order to insert into that view then, you would have to put an instead of...

yes, if you have myproc return a table. so much depends on what "my_proc" actually does.

CREATE PROCEDURE MyProc @param int

AS

BEGIN

SET NOCOUNT ON

SELECT ColumnList From SomeTable where...

Evil Kraig F (9/30/2011)

---

Not entirely true, Gianluca. You just can't update more than one table's columns at a time, which from the error message is what he's trying to...

Great job psoting sample Data, Kenneth;

what you are looking for is to use the FOR XML concatination technique.

based on your sample data, this seems to work perfectly;

/*

--Results

Field ...

MyDoggieJessie (9/30/2011)

---

I don't get it...I can't find any errors in the windows event or SQL logs. Everything says successful. Surely there's an error somewhere???

You're certain the only thing...

MyDoggieJessie (9/30/2011)

---

Thanks for the quick reply Lowell...no errors found though...

Had a brain fart there when I posted my comment about the SMTP service...went into look to check on the SMTP...

run this query to check for mail sent but that failed;

there's a description column with any errors returned formt eh mails erver when it was sent; stuff like relaying not...

change the FROM statments to use inner joins and you''l find it a few seconds...

i'm guessing that the table alaised as qp is not mentioned in the where/join criteria.

FROM

...

SSC poster Elliot Whitlow has this CLR project for file manipulation , and includes Blob read write stuff as well;

it took me about three minutes to install, and has worked...

bitmasks are an old school way , from when memory cost dollars per bit, to maximize the amount of data stored in a byte. it had the cost of obfuscating...

rams.prsk (9/30/2011)

---

Thanks a lot Lowell, Can you just guide me how you could do SUM the bitmasks...that could be more great help

For eg : SUM of 1 & 2 =...

i think your issue is the display of a bitmask.

01011001 is a varchar representation of a bitmask.

you need to do all your math as integers, and display it with...

you need exclusive access to the database in order to change the owner...so if someone is in it, the query waits for them.

you'll need to wait till someones not in...