ALTER TABLE Vrhicle

DROP CONSTRAINT fk_PerVrhicle

Greetings

You can try this

Select DISTINCT * into #table from table

GO

truncate table

GO

insert into table select *from #table

If you have the oracle server as a linked server you can use

Select * into #temp from OPENQUERY (YourOracleSvr, 'Select *from yourtable')

hmaharaj (4/28/2008)

---

i am retrieving data from oracle...

declare @a as varchar (8)

set @a = '20080428'

select cast( @a as datetime)

you can create a proc for insert and usea IF exists

Example

CREATE PROC HND_INSEPISODES

@EpisodeID int,

@TVShowID int,

@Episode_Name varchar (100),

@season int,

@Episode_Number int

AS

BEGIN

IF EXISTS (select *from TVShow where ...

Select *from items where SubCategoryId IN (SELECT SubCategoryID from SubCategories SCAT

INNER JOIN Categories CAT on CAT.CategoryId = SCAT.ParenCategoryId

WHERE SCAT.ParentCategoryId = X)

maybe not the best but works 😛

goodyes (4/26/2008)

---

Hello.

I have a...

Th anks