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 Rhinorhino 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 bbates
-
Select statement problem, help needed.
Thanks for trying guys, but I wanted the actual Product Keys to print out, hence the last line of my question.. "However instead of doing a COUNT I would like to list all of the product keys." Example: Total Installations Unique Product Keys 11111111... -
Select statement problem, help needed.
Table: Software SoftwareID SoftwareName Version ProductKey Alright what I am doing is figuring out the total number of installations of software in the business, and the total number of licenses. I figured out how to do that with this: SELECT Count(Software.ProductKey) AS [Total...
