Good point Barry. I really think (s)he does not have a real name. But what about Dobby like in Harry Potter?

:hehe:

LOL. The guy who wanted to be removed IMMEDIATELY is back...

Don't care, usually (s)he removes his own posts after some hours. 😀

Wow! Never saw this syntax. Thanks Barry! 🙂

@mick miller: I think EXECUTE AT should be the most simple solution.

Flo

Remove this line:

order by (case when val1 is not null then 1 else 0 end)+(case when val2 is not null then 1 else 0 end) desc

Flo

Try this

; WITH cte AS

(

SELECT

id,

val1,

...

Try a backslash to mask your expression:

REPLACE(Reference,"Any \"string","Any string")

However the expression seems to have some additional errors:

(LTRIM([drawing e-location])== "Z:\Gis\SCAN DRAWINGS\"

The first brace is not closed.

The expression does no formatting, it...

USE statement only works for local databases. Try callin' like this:

EXECUTE Server1.master.sys.sp_msforeachdb 'PRINT ''?'''

This requires RPC to be enabled.

Another option would be a hack by using OPENQUERY.

Flo

This should not happen. If you post this UPDATE/INSERT part of your procedure, the table DDL and some sample data we could help much better.

Flo

I published a script here some month ago which might help you to join all those blahs :-D:

http://www.sqlservercentral.com/scripts/anywhere/66000/

The created dynamic SQL is for usual (non full-text) search but it should...

@Gail

I really hope you didn't really mean this! You are a huge part of this site, I learned many things from you.

@All

At my first post I just saw the thread...

@Lynn, Jeff, Gail, ...

Your guy from

http://www.sqlservercentral.com/Forums/Topic372527-146-1.aspx

Ended in

http://www.sqlservercentral.com/Forums/Topic734434-146-1.aspx

Maybe send a PM to Steve Jones:

http://www.sqlservercentral.com/Forums/UserInfo4.aspx

[slide in]

Congrats to Ten Centuries, Lutz!

[slide out]

Looks like there is a CHAR(20) instead of a VARCHAR(20) anywhere.

Try this:

SELECT

'KILL ' + CONVERT(VARCHAR(20), session_id) + ' -- This kills "' + ISNULL(program_name, 'Probably a system process') + '"'

...