Need help with View <noobie></noobie>
-
Very new to SQL and I learn by example but cannot find anything like this after tons of searching. I have an Excel workbook of software application names and versions. Many have the same 'root' name but different version number. e.g. root = "McAfee VirusScan" sheet columns... APP NAME -- VERSION # -- MANUF -- INSTALL COUNT I think a View might be best(?) but no idea how to code it. The View needs to SUM the INSTALL COUNTs for all similar APP NAMEs & VERSIONs(similar determined by using first few characters or something - options here?) example: McAfee VirusScan v1.01 21259 McAfee VirusScan v3.20 14234 ... There are thousands of APPs. I will not know all the possible versions. Anyone do this before and have some example code or could help? Thx in advance!
-
Very new to SQL and I learn by example but cannot find anything like this after tons of searching. I have an Excel workbook of software application names and versions. Many have the same 'root' name but different version number. e.g. root = "McAfee VirusScan" sheet columns... APP NAME -- VERSION # -- MANUF -- INSTALL COUNT I think a View might be best(?) but no idea how to code it. The View needs to SUM the INSTALL COUNTs for all similar APP NAMEs & VERSIONs(similar determined by using first few characters or something - options here?) example: McAfee VirusScan v1.01 21259 McAfee VirusScan v3.20 14234 ... There are thousands of APPs. I will not know all the possible versions. Anyone do this before and have some example code or could help? Thx in advance!
How can I understand you your query should be something like this:
Select sum(Installcount) from Tablename group by versionIf this don't help you then post your data how is stored on table and post result which you want to get.
I Love T-SQL "Don't torture yourself,let the life to do it for you."
-
Very new to SQL and I learn by example but cannot find anything like this after tons of searching. I have an Excel workbook of software application names and versions. Many have the same 'root' name but different version number. e.g. root = "McAfee VirusScan" sheet columns... APP NAME -- VERSION # -- MANUF -- INSTALL COUNT I think a View might be best(?) but no idea how to code it. The View needs to SUM the INSTALL COUNTs for all similar APP NAMEs & VERSIONs(similar determined by using first few characters or something - options here?) example: McAfee VirusScan v1.01 21259 McAfee VirusScan v3.20 14234 ... There are thousands of APPs. I will not know all the possible versions. Anyone do this before and have some example code or could help? Thx in advance!