not enough info, khushbu ; the pseudo code you posted....is that an UPDATE? a SELECT? what is the question?

it almost looks like an attempt at an UPDATE to me, but...

don't convert the varchar, as you'll get truncation issues if you don't say how large to convert to;

the rest is just syntax; you need to escape the single quote to...

well the implementation is the same, it's just the specifics; the remote server is on a network that has access to the internet, that's a basic assumption.

that network has a...

mark you did not try my case statement; it does produces the desired results; maybe with the switch from pseudo/sample to your real code something got lost;

here's a full example,...

the case statement i posted had the priority you stated, so do you mean the "priority" may be dynamic and passed as a parameter or something?

sounds like a networking issue;

by remote, you mean over the internet, right? not on the same LAN/network?

if it's over the internet, you'd need to make sure the remote server...

it's been a while since i had to do this;

youy can do it with a case statement, comparing multiple value pairs:

select

[Column A],

[Column B],

[Column C],

[Column D],

[Column E],

case

when [Column C]...

it's not clear what you are after; if you run the code, it's going to produce results like this:

<li>Bob Smith</li><li>Bill Smith</li><li>Bill Jones</li><li>Bob Jones</li>

you did run the code, right? you know...

well too bad about no date so we can't keep the last x months of data; but assuming we can delete all but one(the highest ImageID) for each customer, here's...

pretty sure it's simply changing the one parameter to true:

@useself=N'True',...

in that case, the logged in users credentials would be passe dot the linked server, and it would work/fail if they...

no...i really need you to actually script out the table; pseudocode doesn't help...for example there is no "blob" data type in SQL ...it could be TEXT/IMAGE/varbinary(max), for example;

Also I ...

can you show us the table definition that contains the blobs? ie CREATE TABLE....

if there is a column in the table that has the date in it, you should be...

ok how about this:

first that other cursor has a logic hole; don't loop thru databaszes, loop thru connections.

i adapted my sp_kill function, which is database specific, to do the whole...

it's this part:

select

@msg = @msg + 'New Item ....FROM INSERTED

if inserted has 10 rows, @msg is going to have 10 "lines", one for each...

aww, you didn't answer any of my questions....

well, i'm expecting the followup post that says "help i deleted 2000 jobs and now i need some of them back"

did you backup...