May 18, 2013 at 1:18 pm
Comments posted to this topic are about the item EXCEPT - 1
May 19, 2013 at 1:10 pm
Easy one, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 19, 2013 at 10:58 pm
Nice question Ron!
Good start for Monday morning 🙂
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
May 19, 2013 at 11:20 pm
Lokesh Vij (5/19/2013)
Nice question Ron!Good start for Monday morning 🙂
+1
Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
May 19, 2013 at 11:23 pm
Easy basic one to start the week 🙂 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 20, 2013 at 2:20 am
Thanks for the question. It might be easy for others, however I learnt something on this. I did not do my research first and thought it would be three.
May 20, 2013 at 3:49 am
This was removed by the editor as SPAM
May 20, 2013 at 8:27 am
Good question to start the week - thanks 😉
MCTS | MCITP | Microsoft SQL Server 2008 Administration & Development
MCSA | MCSE | Business Intelligence SQL Server 2012
May 20, 2013 at 8:52 am
Nice question - thanks, Ron!
May 20, 2013 at 10:07 am
Sweet! +1
Not all gray hairs are Dinosaurs!
May 20, 2013 at 1:22 pm
Nice and easy, thanks!
May 20, 2013 at 10:28 pm
Nice one....
May 22, 2013 at 8:56 am
Nice and interesting one..
--
Dineshbabu
Desire to learn new things..
May 27, 2013 at 4:58 am
EXCEPT returns any distinct values from the left query that are not also found on the right query. The key to this is of course the use of DISTINCT.
Really new thing added into my database
Manik
You cannot get to the top by sitting on your bottom.
May 28, 2013 at 12:58 am
DISTINCT was clearly the key here. Thanks for this basic question. 🙂
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply