CreataObject assumes there is a dll registered for the object in question....the richtext control is typically registered when vb6 gets installed, and you usually don't install that on a server.

it...

In a lame attempt to get this thread back on track, I've used Jeff's Tally table to html encode and decode some text for html and xml outputs:

SELECT dbo.HTMLEncode('é')

SELECT dbo.HTMLEncode('happinéss...

as with any general question , the answer depends on more info;

how much data is being brought in? if it's a suite of small tables, it might not matter; obviously...

can't you just either declare the variables and use them in teh cte query, or throw it into a procedure with your 40 parameters with default values?

here's a very basic...

do not crosspost; asking the same question in 4 different forums splits the answers and wastes many peoples time;

most people go to Recent Posts...Posts Added Today to find everything that...

do not crosspost; asking the same question in 4 different forums splits the answers and wastes many peoples time;

most people go to Recent Posts...Posts Added Today to find everything that...

do not crosspost; asking the same question in 4 different forums splits the answers and wastes many peoples time;

most people go to Recent Posts...Posts Added Today to find everything that...

i tried going down the CLR route to resolve this in SQL 2005...but guess what... a SQL project is not allowed to have access to an rtf richtextbox control....I guess...

i looked at the 4 special RESTORE commands that I know of in BOL:

RESTORE HEADERONLY

RESTORE FILELISTONLY

RESTORE LABELONLY

RESTORE VERIFYONLY

looks like you can find the name of the user that rant...

kewl to get a wierd error....can you paste lines 13,14,15 from your script so we can see what line 14 might be doing to cause the error?

looks like you are trying to do a sum on the web page, which is NOT the same a s a sql statement running on the server.

on the server, the...

in my case, i didn't see any differences:

connecting to either SQL 2000 or SQL 2005 servers, with SSMS,

when running the code, in both situations the error was found, and the...

oops: a PK error is level 14, not 16, so it CAN be managed with @@error:

using the same tablein my first example, here's another example:

--error level 14!!

insert into test(testid,othercol) select...

if @@error ...then...else

will not work, because a PK error is severity 16 or above, so the code execution stops on the error.

i believe if you redo it as a...

you can use the built in functions to get you pretty close:

select getdate(),convert(varchar,getdate(),112)

2008-10-20 22:34:41.680

gets formatted to

20081020

you could then use some string functions to get the dasheted in there

select...