DELETE t

FROM candidateTenant t

WHERE EXISTS(SELECT * FROM waitList w WHERE w.candidate_no = t.candidate_no)

I did :blush:

bugger! :crazy:

Need to to know key relationships between tables, please post table DDL, sample data and expected results.

When inserting into a table you can select new rows by excluding any already...

yeah, Jeff is a real passionate guy :w00t:

Need more information. I am not an ORACLE user but I believe the sql is similar.

You can do 50 individual SELECT's (one per table) to get 50 result sets

You can...

where the heck did the "x", "y", and "z" come from

Probably from the aforementioned 'some grouping and calculation...

That's nothing  

It's all the same to a blind man

For single row insert

INSERT INTO (othercolumn) VALUES (0)

UPDATE SET [othercolumn] = [identitycolumn] WHERE [identitycolumn] = SCOPE_IDENTITY()

wrap in transaction if preferred

this will not handle multiple inserts ie...

A permanant table containing numbers, I create my like this

CREATE TABLE dbo.Numbers

([Number] int NOT NULL,

CONSTRAINT PK_Numbers PRIMARY KEY CLUSTERED (Number))

GO

SET NOCOUNT ON

DECLARE @n int

SET @n...

Nasty solution but....

SELECT SUBSTRING(col004,n.Number,CHARINDEX(',',a.col004,CHARINDEX(',',a.col004,CHARINDEX(',',a.col004,n.Number)+1)+1) - n.Number + 1)

FROM a

INNER JOIN Numbers n 

ON n.Number > 0

AND n.Number < LEN(col004)...

Notwithstanding the above, never tried this but...

1. Create linked server to LIVE on DEV

2. Create procedure on LIVE to execute sp_start_job

3. Add step to job on DEV to execute above...

First create a temp table

CREATE TABLE #temp ([ID] int ,colname varchar(255),colvalue varchar(255))

and fill it

INSERT INTO #temp select 0,LEFT(ResubmitDetails,CHARINDEX(':',ResubmitDetails)),LTRIM(SUBSTRING(ResubmitDetails,CHARINDEX(':',ResubmitDetails)+1,255)) from

Assign an ID to each block of data...

...notice that I hate loops and cursors so much that I even avoided them...

But still using non ANSI-92...

There must be a smart way of doing this but I just cannot think of it

I tried this

SELECT A,MIN(B) AS FROM (

SELECT a.[ID] AS [A],b.[ID] AS

FROM...