ok just to be sure, you did uncomment this line like i said you needed to,right?

--EXEC SP_EXECUTESQL @STR

i didn't want other readers running that on...

here's some code; i...

Norm this is just a guess based on adapting your posted query;

does this get you close to what you were after?

SELECT

c.ClassName,

c.EnrollLimit,

p.RegType,

p.RegStatus,

...

because the underscore has a special meaning in a LIKE statement, i think you need to do something like this instead to find two underscores back to back:

where ...

Bhuvnesh first, create a server side trace; it's actually a very low impact on the server, but can provide you with exactly what you are looking for, as well as...

dang; i followed the fine article cos_ta393 posted; at the very end, i found out only enterprise or developer supports TDE; my 2008 Standard doesn't support that feature.

That's something to...

the devil is in the details: what does "resolve remote server name" mean;

if it's over the internet, is there a DNS of YourRemoteSQLServer.SomeDomainName.Com, or are you talking about a machine...

this is syntactically incorrect, whether a select or an update....paste it in SSMS and see for your self.

Sasidhar Pulivarthi (3/30/2010)

---

if U want to use if statement in the query...

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]...