RE: Combining Two Grouping Select Statements
jpipes - I understand the issue - I just disagreed about what was being asked for.
2003-06-19
RE: Combining Two Grouping Select Statements
stax68, the problem is that your code will aggregate the COUNT(DataID) will not return a count of all questionnaire records, but just the count of the questionnaires in the group keyed on UDL4. What drewid is asking for is to include not only this grouped count, but also a count of the entire number of […]
2003-06-19
RE: Combining Two Grouping Select Statements
David, That last query did it! You rock :). I was trying to get the total for the WSI as a whole as well as the total that were defects and that did it. It now makes a very nice recordset which can be used in the page (all in one trip)! A big thanks […]
2003-06-19
RE: installing sql
I'm not sure I completely understand you, so... Are you saying you already have SQL Server databases and that you just want to be able to connect to them? If so, you should ONLY be installing the CLIENT TOOLS. During the install you will be asked what you want to install and that will be […]
2003-06-18
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers