Hi,
I need to separate certain data in a large text field into distinct columns,
however I need to use regular expression to extract the data, as it is field
delimited, as below:
"Value=123|Description=hello, world!|Data=123456ABCDE|"
"Description=goodbye, world!|Value=345|MoreData=ABCDE123...
more >>
We recently migrated an application that had run for years on a
WinNT4/SQL 7.0 system to a Win2K/SQL 2000 system, and have a query
that simply will not run. The SQL 2000 system is running Win2K SP 3,
and sQL 2000 SP 2 with the security update of 10/16/02 (SQL Slammer
security patch).
If you ...
more >>