Duh!!!

Thanks. I am kind of new to this. I didn't realize that the create only 'Creates'.

I get 'Command(s) completed successfully.' It completes right away and does nothing.

That was it Chris. Thanks. This code is actually cleaner than what I was using. Less chance of error.

Thanks so much

I ran with the below script and got an error: Incorrect syntax near the keyword 'where'.

I am loving the change though.

[/quote]

[code="sql"

update ds_CleanNames

set clean_name1 = LEFT(clean_name1, CHARINDEX(' DBA ',...

It is taking the part before the DBA as the first field.

It is taking everything after the DBA and populating another field.

I am cleaning the fields to do a match...

Hello,

Because of the problems with the database compatibility (not having the option of change to 90 or creating other databases), I tried to accomplish this without a cross apply. ...

Along with some other fields from my table, the resulting row will include information derived from parsing a string field. A sample of the string field that needs to...

So are you saying that there is no way of simulating the cross apply logic? I don't really have the option of compatibility 90.

It is taking parameters from an application and getting information to display to an aspx report. The problem is one of the fields (phra_request_querystring) is a string that has...

I am having the same problem. I cannot change the compatibility level on the database because of older applications. I need to simulate the cross apply and probably...

I was actually able to get it to work using cmpshell....

http://sqlserver-qa.net/blogs/t-sql/default.aspx

Thanks so much for all of the responses. We are looking into how we can use this information to accomplish this.

Thanks, I will check that out. I am trying to do as much as I can programmatically.

Thanks for replying. I actually found a simpler answer:

SELECT t.field1,t.field2,LEFT(sl.numlist,LEN(sl.numlist)-1) as newfield

FROM(SELECT DISTINCT field2,field1 FROM tableA) t

CROSS APPLY(SELECT distinct CAST(field3 AS varchar(10)) + ',' AS [text()]

FROM tableB

WHERE field2= t.field2

FOR...