To be more specific, I am trying to obtain the total of questionnaires in the query per "WSI" as opposed to the percentage from the whole. In other words: Number of questionnaires per WSI Number of questionnaires per WSI where SumDefects > 0 Sum of SumDefects field per WSI This select statement is being called […]
2003-06-18
1 reads
In your last query, your are not grouping by the same number of columns you are trying to aggregate, so my guess is you are receiving an error saying "is invalid in the select list because it is not contained in either an aggregate..." and so on. Howerver, you have attempted to include a subselected […]
2003-06-18
1 reads
2003-06-13
Can only give you the pass mark for 070-228, can't remember how many questions there were for sure, but the pass mark is 755 (out of 1000). Hope this helps.
2003-06-13
check out http://www.cramsession.com/ also check out an earlier thread on this forum ... "Need helpful advice"
2003-06-12
Hi eily, quote: i want to know is it possible when using a parameter in a stored proc that when i go to execute the proc that instead of entering the values one by one that i could enter "ALL" and get all possible values returned something like SELECT * FROM table WHERE field LIKE […]
2003-06-12
1 reads
Thanks for suggestions New server as follows: Compaq ML370G3 1 x 2.4Ghz Xeon 2.5Gb RAM Disks—RAID5 (hardware RAID) about 70 gb available Running Win 2000 with SQL Server 7 Old server as follows: x86 family 6 model 5 stepping 2 AT/AT compatible 320 mb memory (may be inc page file) Disks- Raid 5, about 20 […]
2003-05-30
The example I gave was not the best in that it immediate brought up questions of why I was trying to generate the key in that way in the first place. The situation is more one of coming into a place where they keys are generated in this way, but for each table and I […]
2003-05-22
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers