Click here to Skip to main content
14,238,485 members
Rate this:
Please Sign up or sign in to vote.
See more:
HELP ME PLZ
I WANT TO SELECT FROM MAIN TABLE WITH CONDITION
THEN COPY TO
T1
&
T2

THEN
DELETE FROM MAIN TABLE

What I have tried:

SELECT [Column Names]
INTO [Table 1]
INTO [Table 2]
FROM Source
WHERE Condition
DELETE FROM SOURCE
Posted
Updated 10-Jun-19 9:47am
Comments
Mohibur Rashid 9-Jun-19 17:06pm
   
This is where we ask, what have you tried?

Additionally, are thet two different database? If not, why are you doing this?

Why screeming?
Why repeating question?
Dominic Burford 10-Jun-19 11:45am
   
There just isn't enough detail here to be of any help. Are you stuck on the SQL syntax? Are you getting an error? Can you post your SQL script and details what you're expecting to swee, and what you're actually seeing? More detail needed. P.S. we're not here to do your job / homework for you.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Once you've selected into T1 or T2, then delete for source where in T1 or T2.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100