Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Query the quantity of records

Author  Topic 

sfjtraps
Yak Posting Veteran

65 Posts

Posted - 2014-11-20 : 10:00:23
I need to query SQL Server Express 2012 records to find 6 serial numbers that are all assigned to one common unique number. Normally in this use case, 12 serial numbers are assigned to one common unique number, so I'm trying to find the odd entry.

Can someone help me build this query please?

sfjtraps
Yak Posting Veteran

65 Posts

Posted - 2014-11-20 : 10:12:46
To clarify, I don't know what that common unique number is. The common unique number is only suppose to have 12 serial numbers assigned to it, but somewhere in a database of about 5000 serial numbers there is a common unique number that has 6 serial numbers assigned to it.
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-20 : 11:26:45
Please post your table definition as DDL (i.e. a CREATE TABLE statement)
Go to Top of Page
   

- Advertisement -