Re: Separate values from column
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 24 Oct 2005 23:05:24 +0200
On Mon, 24 Oct 2005 09:56:08 -0700, Mile wrote:
>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!
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
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
.
- Prev by Date: Re: English Query still available in SQL Server 2005?
- Next by Date: Re: Views
- Previous by thread: Re: English Query still available in SQL Server 2005?
- Next by thread: Re: Views
- Index(es):
Relevant Pages
|
|
