i would go with something simple:

Replace(FieldWithCrLf,CHAR(13) + CHAR(10),'')--vbCrLf

imani_technology (5/18/2010)

---

The source column looks something like this:

XYZ12A01[FOUR ODD SQUARES]LP_EXL_ID

Then I use the following REPLACE function within a Derived Column transformation:

LTRIM(RTRIM(REPLACE([Column 0],"LP_EXL_ID","")))

The destination column is varchar(200). The...

enable remote connections on your SQL 2000; i belive by default express versions set remote access as off, and you have to turn it on:

exec sp_configure 'remote access', 1

reconfigure

some great code suggestions

from a similar thread where someone needed to detect if lower case/upper case character exists:

http://www.sqlservercentral.com/Forums/Topic800271-338-1.aspx

this would check if the string is all UPPER:

DECLARE @string VARCHAR(10)

SET @string =...

the SSMS GUI has a built in report that taps the default trace , filtered by database name; it's a bit easier to use that querying the default trace directly:

yeah i'm thinking TSQL/SQL Server might be the wrong tool for the task...you can do it, but it sounds like you just want a keep alive hitting your site...maybe your...

lets just cover all the bases;; you created a connection , correct? then you can expand the conenction to show the tables, multi select and drag and drop:

you VS should...

i think you jsut need to wrap the Tiutle column with the isnull function:

select RIGHT(' '+CONVERT(VARCHAR,ISNULL(Title,'')),40) AS Title

from ADDRESS;

not sure about the error; it's so wierd that it refers to a backup.

whenever i've used sp_msdependencies , i've always used the parameter @intrans = 1 ,

and i'm...

i usually add a blank xsd file to my project, then with server explorer, create a connection to the database.

once that is there, you can drag and drop all 60...

i had done this requirement before, but additionally one of the values had to be populated...i didn't see if both values were allowed to be null or not;

the only way...

ok this was kewl to know;

once you doink up an object name so it has a dot in it, you need your brackets around the object, and it was easier...

{edit after i posted, i saw this is in a SQL 2000 forum, and this requires 2005 and up.

doing this in SQL2000 usually requires asticking the results in a temp...

it's an ugly implementation, but it works.

it's based on the actual contents....if something was defined as a varchar(max), how big is it in a fixed with file?

for me,i'm looping thru...

good job on providing the table structures and the desired output;

if you had posted the INSERT INTO for the data, your question would be perfect!

to convert rows into a comma...