starting with the basics, to join them, they all have to have something in common...typically it is some ID...we kind of know that the relationship exists, because previous reports were...

I believe in a high traffic environment, update staistics can slow down processing, so some folks like to save it as a nightly maintenance plan, instead of letting it be...

you need to make sure your msForEach has a USE statement:

sp_msforeachdb 'USE ? exec sp__CountTableRows'

Jack's Script needed to explicitly use the ? variable for the dbname"

sp_msforeachdb @command1 = 'Select

...

you have to use a list of columns that does not include the primary key, not SELECT *, because the PK already exists:

insert into vqsmtest.dbo.ithelp_user (COL1,COL2,COL3...)

select COL1,COL2,COL3... from vqsmtest2.dbo.ithelp_user

where...

CONTAINS is really for full text queries; for something like this, just use like:

select * from tblAdd where address LIKE '%"%'

UPDATE tblAdd

address= Replace(address,'",'')

where address LIKE '%"%'

your post is a little thin on details, and hard to follow, so I'll post a best guess of how to do an UPDATE FROM based on your statement:

Update Table1...

this has been the fastest way I've found, because it's using index tables to count rows, rather than actually running a statemtn.

that's important to note, because if you have a...

a calculated field would do the trick: add a column to your table like this:

ALTER TABLE MYTABLE ADD

MYFIELD AS COALESCE(FIELD1,'') + '/'

+ COALESCE(FIELD2,'') + '/'

+ COALESCE(FIELD3,'') + '/'

+ COALESCE(FIELD4,'')

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