aw come on, you know what i mean...Dev is limited to a max of 10 connections, instead of limited only by memory in the full version, a couple of...

the portion you pasted has a trailing slash and closing bracket for your CS2 connection...was that just a copy/paste error, or could it be the issue??

Password=xxxx"/>

compatiblility in that case means it won't fail on install...it'll install the tools no problem.

but as you've noticed it will not install everything. That is by design.

People are a bit...

you have to check the 2 digit months first, because months 10,11, and 12 all match the january single digit criteria!!

[font="Courier New"]

SELECT yearmonth,

CASE

WHEN (SUBSTRING (   [YearMonth] ,5,2)='10' )  THEN  (SUBSTRING ( [YearMonth]...

in my case RB_TABLE has two indexes; that table has a clustered index one column, and a non-clustered on the exact same column for some reason; but looking at all...

OK Gail put your thinking hat on, because you've got to double check my work.

I'm combining a couple of scripts i had laying around to try and find statistics that...

i know what you mean;

I wrote this neat function that returns the DDL of a table, along with it's indexes....you know, CREATE TABLE.....

works fine in any database, but of...

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,'')