Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by clanguage1
-
Join of 3 tables
Try this select id from c where id not in (select id from a) and id not in ( select id from b) That should get you what you are looking for . Good luck clanguage I count my blessings, daily. CJM.- clanguage1
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Break in Sequence
Hello Alexcuse I have a sequence like 150 151 152 153 155 156 157 30001 30002 30003 30002 30003 30004 The difficulty lies in that there can be duplicate numbers. Of course I have another piece of information. The product mcq44 starting at 150, dmr26 starting at 30001 and dmz55 starting at 300002.- clanguage1
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Break in Sequence
Hello, does anyone knows of a way to group a set of records everytime a break in a sequence occurs. Let me explain. I have a sequence of numbers like 1,2,3,4,5,7,8,9 when I reach the break (6) I need to group 1,2,3,4, and 5 together and 7,8, and 9 next and so on. I have it working with a cursor...- clanguage1
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
