Viewing 15 posts - 16 through 30 (of 167 total)
Do you want the results from both tables or only the results from table1 if they can be linked to table2?
December 9, 2015 at 2:11 pm
select productID, Status
into #tmpTable
from table3
insert #tmpTable
select productid,Status
from table2 t2
where t2.productID not in (select productID from #tmpTable)
insert #tmpTable
select productid,Status
from table1 t1
where t1.productID not in (select productID from #tmpTable)
December 7, 2015 at 3:06 pm
joeroshan (11/18/2015)
Great idea, thanks for taking time to share your work.
+1
November 18, 2015 at 8:41 am
The fact that most people got it wrong speaks for itself.
November 4, 2015 at 12:14 pm
cory.bullard76 (8/26/2015)
August 27, 2015 at 1:17 pm
Thanks for getting this going, Grant. It is one of the best and most entertaining threads I've seen in a while.
My two bits:
-- Desperately trying to find a foreign...
August 27, 2015 at 12:55 pm
Alvin Ramard (8/13/2015)
Lynn Pettis (8/12/2015)
I don't know about others but I am really tired of people thinking that using vulgarity is appropriate in a professional environment and this...
August 13, 2015 at 3:51 pm
I used SPSS for a couple years and got somewhat grounded in stats. Near my elbow I have a copy of "Statistics For Dummies" that I keep (in addition...
July 30, 2015 at 3:09 pm
pietlinden (7/2/2015)
Regarding teaching caution: Some people might say we go overboard. The attendees must have their manager sign and return a document that says they understand that they are responsible...
July 2, 2015 at 4:13 pm
One other point: Invariably the part of the class that newbies struggle with the most is joins, primary vs foreign keys and table aliases. Regarding the joins, one of...
July 2, 2015 at 3:05 pm
I teach a three day “SQL Boot Camp” class (that I developed) about twice a year for our customers and internal staff. The goal is to teach beginners how...
July 2, 2015 at 2:59 pm
With the resources we have available to us today (including the wonderful forums at SSC), all you need to succeed in this business is aptitude and desire. There are...
July 1, 2015 at 10:23 am
Give them the url to this thread...
June 24, 2015 at 4:08 pm
Steve Jones - SSC Editor (6/23/2015)
I loved Netware's performance on IPX v Windows early stuff, but certainly Netware was slow to move to IP based work. That was an issue,...
June 23, 2015 at 10:54 am
I’m sure many of you are old enough to remember when Novell Netware was king and “poor” Windows NT was dismissed out of hand (some said that NT stood for...
June 22, 2015 at 1:23 pm
Viewing 15 posts - 16 through 30 (of 167 total)