Assuming group is required, the following 57 results were found.
-
to: - Microsoft Windows 7 Enterprise - User with Local Administrator Privileges (required for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 Ultimate (VS2010) and Business Intelligence Development Studio (BIDS),...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
ON Catalog.ItemID = ExecutionLog.ReportID WHERE ExecutionLog.TimeStart BETWEEN @DateFrom AND @DateTo AND Type = 2 ) AS RE GROUP BY Name ORDER BY COUNT(Name) DESC , Name
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
chktbls ON chktbls.Tablename = ST.name JOIN SYS.schemas SCh ON ST.schema_id = SCh.schema_id WHERE ST.name 'SearchTMP' GROUP BY ST.object_id, SCh.name + '.' + ST.NAME ; UPDATE @SQLTbl SET SQLStatement = 'SELECT * INTO SearchTMP FROM ' + Tablename + '...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
= @myCounter + 1; FETCH NEXT FROM Cursor1 INTO @SqlToExecute END CLOSE Cursor1; DEALLOCATE Cursor1; PRINT ' ) AS t1 GROUP BY column_value ORDER BY MIN(column_source)'; END Step 2 of 2 You now have a big SELECT query which you can copy, paste and run...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
+ ''', COUNT(*) AS Count FROM ' + @TableToProcess + ' WHERE ' + @p_Column + ' = ''' + CAST(@p_Value AS VARCHAR) + ''' GROUP BY ' + @p_Column + ''; INSERT #CountRecordsPerTablePerCol EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @TableToProcess END...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
above still produces an error which can only be seen when using more records and more employees. PARTITION BY So a sort of "group" action will allow this if we add "PARTITION BY" to the ROW_NUMBER() statement: SELECT q.Employee AS EmployeeNo,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
are a variety of solutions that will fix this. However we have certain restrictions in my work environment thanks partly to group policies: Need to run with elevated permissions which requires UAC prompt (despite being already logged in, this is the...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
u ON u.UserID=s.StaffUserID INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID INNER JOIN Teams t ON t.TeamID=s.TeamID GROUP BY s.LogID ORDER BY s.TeamID, u.Username, s.DateTimeCreated, Resource Note there is no WHERE clause because we're going to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
on the Thursday. A few things we have to deal with still: We have lost the rows with days that have no events. We need to group by days so that each day only outputs one row (see Thursday). We want the earliest time and the latest time per morning and...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
BY n ) n WHERE n.n 5 AND TRIM(`value`) NOT IN ('Article','This',' ','content','component','applies','because','doesn''t') GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
a support technician to this project (supply Contact details: email/phone) Training / Handover (if handing over to another group / developer) Discuss training rates (same as development - per hour) Documentation: Modes of documentation (forums, word...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
site written from scratch, and it's purpose was to manage Staff and Students within the Additional Learning Needs group. These are staff who take lecture notes for people of all disabilities and assist the students for the duration of their course. It...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
strings: a b The expression does not match the characters: ab c Subexpression You can use the subexpression operator to group characters that you want to find as a string or to create a complex expression. For example, to find the optional string 'abc',...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
first 10 rows of this array (if we are doing a top ten) My new method is: SELECT column1, COUNT(*) AS CountOrder FROM table1 GROUP BY column1 ORDER BY CountOrder DESC LIMIT 0,10 PHP script to loop through the results of the above query Display the value...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
instances of MYDOMAIN, myusername and MY_SHAREPOINT_SITE accordingly). The moon to play with /_layouts/people.aspx?MembershipGroupId=# where # is the ID number of the group (will error on invalid IDs).
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
Version Platform ChangeLog Options 1.0 + Group all the data by a specified column + Generate interactive flash charts - Date Uploaded: Wed, 15th Sep 2010 Download
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *