Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
When I replace s.Description with s.SoftwareID in two places, it runs okay.
SELECT s.Description AS Software , SUM(d.Quantity) AS TotalQuantity FROM tblSoftware s INNER JOIN tblOrderDetails d ON s.SoftwareID = d.SoftwareID GROUP BY s.Description;
|T-SQL: "SELECT TOP 100 PERCENT" is not as easy to use as the books make it out to be!!!||5||22|
|create insert script based on records in a table||4||14|
|ms sql last 8 weeks as columns||5||26|
|Changing the datatype of a column from nvarchar to date||47||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!