How To Let Result Data Place At Temptable Temperary For Other Mapping? Should I Create Temptable Firstly?

Hi!
I have several problems of my coding, please give me some advice.


1. How to let result data place at temptable temperary for other mapping? should i create temptable first ?

2. When I got the duplicated record result, I require to map with the main tables (tblROrder & tblSOrder)to find out the record reference no. Please advice how to handle this issue with reference no. at the outcome.

Many thanks,
New Learner


***Coding as following

SELECT code, SMSNo, holderNo, count(*) From tblROrder

WHERE Day = @Day

GROUP BY code, SMSNo, SholderNo

HAVING COUNT(*) > 1<=====result will be found, but since i didn't get the RefNo at the listing, please advise how to let the outcome with RefNo

INTO #tmpOne (code, SMSNo, holderNo) <====error found




SELECT code, SMSNo, holderNo, GrossAmt, count(*) From tblSOrder

WHERE Day = @prmDay between D1 AND D14

GROUP BY code, SMSNo, holderNo, GrossAmt

HAVING COUNT(*) > 1<=====result will be found, but since i didn't get the RefNo at the listing, please advise how to let the outcome with RefNo

INTO #tmpTwo (code, SMSNo, holderNo) <====error found