sql server mseq: Separate values from column -- sql server mseq

Separate values from column

Mile
10/24/2005 9:56:08 AM

sql server mseq: I working with SQL Server 2000 table called dbo.test.
I need to separate value "User Name:xxx" that are in one column named "log"
that are space limited.
For example I have a column called log and the
value = 'domain: User Name:user1 User Name:user2 User Name: User Name:user3'.
I want to write a query so that the results can found just User Name with
actuell user (Ex."User Name:user2") not the User Name without actuell user
(Ex. User Name:).
When the "User Name:xxxx" is separated then the actuell user (xxxx)must be
checked if same name is repeated more than 3 times last 24 hours
then I would like to insert the output in new table caled"Result"
Thanks!

Re: Separate values from column

Hugo Kornelis
10/24/2005 11:05:24 PM

[quoted text, click to view]

Hi Mile,

I'm sorry, but the above description doesn't clarify what you're trying
to achieve. Maybe it would help if you could post:
* Structure of your table (as CREATE TABLE command, including all
constraints and properties; irrelevant columns may be omitted);
* Some well-chosen rows of sample data (as INSERT statements);
* The required results, as based on the given sample data.

Check out www.aspfaq.com/5006 as well.

Best, Hugo
--