Madhu-207721 (7/21/2011)

---

Dear,

Is there a database which supports richtext features ?

Scenario: I have a word template document with bookmarks.

I have database which stores the data for the bookmarks and other...

ananda.murugesan (7/21/2011)

---

Mr.Lowell,

thanks for reply..

In SQL server 2008 server machine Not available Ingress ODBC driver 3.0 or 9.2 etc.. I think Ingress odbc driver required in Ingress machine only. Not in...

yes exactly. DTS (well...

Procedures and functions(and triggers, if they exist) will have to be hand edited; there is no process that i've ever heard of that can convert procs and functions form...

from a post by Jeff Moden, where he showed the sneaky way to get rid of multiple repeating chars in a single pass;

this is replacing pound signs, but it should...

allamiro (7/20/2011)

---

OK great thanks for the script it diffidently great

However when you said the default is a so does that mean I will have 2 traces running ...

do you mean the default trace? for that, you can't, it's a black box...but you can script a copy of that same trace definition, modify THAT, and create a new...

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