Re: Eliminate records
From: CC&JM (anonymous_at_discussions.microsoft.com)
Date: 06/04/04
- Next message: EricK: "Mail syntax interpreted by sp_processmail"
- Previous message: Niles: "DB Size"
- In reply to: Vinodk: "Re: Eliminate records"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Jun 2004 08:33:14 -0700
Thanks Vinod
>-----Original Message-----
>Did you try using:
>
>Select DISTINCT Derived.* into DestinationT FROM
>( select EvClassDesc,
> STime,
> substring(Textdata,patindex('%
exec%',Textdata),217) as [TextData],
> objid
> from OriginalT
> where objid = 1111111 and EvClassDesc = 'SP:Star')
Derived
>.... (untested)
>
>WIll this help?
>
>--
>HTH,
>Vinod Kumar
>MCSE, DBA, MCAD, MCSD
>http://www.extremeexperts.com
>
>Books Online for SQL Server SP3 at
>http://www.microsoft.com/sql/techinfo/productdoc/2000/book
s.asp
>
>
>"CC&JM" <anonymous@discussions.microsoft.com> wrote in
message
>news:17fe001c44a19$f48dfb80$a301280a@phx.gbl...
>> Hello,
>>
>> The output of the following query returns two identical
>> records, i need to eliminate all records that are
>> identical but if i use the "distinct" before the
substring
>> function its returned one error.
>>
>> This is the query that i'm using:
>>
>> select EvClassDesc,
>> STime,
>> substring(Textdata,patindex('%
exec%',Textdata),217)
>> as [TextData],
>> objid
>> into DestinationT
>> from OriginalT
>> where objid = 1111111 and EvClassDesc = 'SP:Star'
>>
>> Thanks,
>> Best regards
>
>
>.
>
- Next message: EricK: "Mail syntax interpreted by sp_processmail"
- Previous message: Niles: "DB Size"
- In reply to: Vinodk: "Re: Eliminate records"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
