Click here to Skip to main content
15,867,750 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

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

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900