check out Cast and Convert in Books online:

http://msdn.microsoft.com/en-us/library/ms187928.aspx

if your original datatype is money, then one of the overloaded parameters of the CONVERT function is to insert the commas like you...

first guess:

Create Table #MySampleData

(record_id int,

ptno int,

Account varchar(30),

hosp int,

batchid varchar(30),

v1 varchar(30),

v2 varchar(30),

v3 varchar(30),

v4 varchar(30), )

INSERT INTO #MySampleData

SELECT '22170260687','2217026','AB0706851265','39','G001OSX1','NULL','NULL','NULL','NULL' UNION ALL

SELECT '22170261747','2217026','AB0706851265','39','G001OSX2','NULL','NULL','NULL','NULL' UNION...

Ninja's_RGR'us (7/20/2011)

---

What happens if the text outside the tags containt < or > ?

I never fully tackled this problem, but I know it's far from simple.

Moreover I think that RBARing...

ok here's a tested working example...that i reworked quickly because you changed the datatype tyo TEXT.

i'm assuming this'll be a one time update, so it might be slow on a...

i have this saved in my snippets for stripping out HTML tags. note this assumes that well formed html is in palce...so % lt ; should be there for <...

glad it helped a bit;

i think of joins a stree branches...they can join on the trunk (base table) or join on a branch-of-a-branche that is attached to the trunk...however...

maybe an example might help?

in my example below, i'm joining a bunch of two tables and a view agaisnt another table to get the desired data.

my primary key columns, instead...

Your questions' a little unclear...do you not know how to create a maintenance plan, or are unsure of wether you can use a mapped drive?

Your best bet is to simply...

Stamey (7/20/2011)

---

I already have code that searches for the column in procs, indexes, and UDFs. My concern is for other objects, such as constraints and primary keys, or rather any...

test this:

SELECT DATALENGTH(new_col) AS TOTALLENGTH,

DATALENGTH(col1) + DATALENGTH(col2) +DATALENGTH(col3) + DATALENGTH(col4) As ShouldBeEqual

FROM table

I think you'll find that the data in the table is the right size and is correct; it's...

check the datalength() of your results instead of viewing the column;

I believe for performance sake, no matter what you set the results setting to in SSMS , it displays(at max)...

maybe you are referring to checksum or binary_checksum,

that method can provide a unique value based on one or more columns of data, but I cannot think anything that does...

my mistake, the default trace does not capture the textdata, it seems; I assumed it did.

i created a new database, ran a script that added a table and a suite...

maybe, but doubtful, the default trace might contain the textdata for the ALTER PROCEDURE command the other developer originally did...

but since the default trace rolls over so quickly, it probably...

The only way i can think of to make that work is to use a Calendar table, and also require a table scan because you'd have to check each datetime...