Re: Eliminate records
From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 06/04/04
- Next message: Sven Aeyels: "Re: Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 5(Access is denied.)."
- Previous message: CC&JM: "Eliminate records"
- In reply to: CC&JM: "Eliminate records"
- Next in thread: CC&JM: "Re: Eliminate records"
- Reply: CC&JM: "Re: Eliminate records"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Jun 2004 15:34:04 +0530
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/books.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: Sven Aeyels: "Re: Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 5(Access is denied.)."
- Previous message: CC&JM: "Eliminate records"
- In reply to: CC&JM: "Eliminate records"
- Next in thread: CC&JM: "Re: Eliminate records"
- Reply: CC&JM: "Re: Eliminate records"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
