... "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their documentation include it?
Workaround (applies for any dll)
You right-click on the "references" folder, ...
... AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender
FROM
[dbo].[XML_EVENTS]
-- Returns column GENDER for every record/row (eg. "Male")
Or
-- Using .value()
SELECT
CAST(Event_XML ...
... (GUI based for non-technical staff. Web-based for remote working.)
JoelLipman.Com will create 2 development sites ("play" sites) which the project manager and his/her team can use to experiment and ...
What?
We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, ...
... be a breeze, but that's because I don't implement group policies at home.
Why?
We get problems with this because none of our staff are full administrators of their local workstation. As IT staff ...
... s, ssf, sst
FROM `Session` s
LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId
LEFT OUTER JOIN `SessionStudent` sst ON sst.sessionId=s.sessionId
WHERE s.dateTime >= '2013-02-01 00:00:00'
-- ...
What?
We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers.
Why?
The aim of this article ...
... this week, 1 for the week before, 2 for the week before that...
$timesheet_query_per_user="
SELECT DISTINCT
s.StaffUserID AS 'UserID',
(
SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) ...
... row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have:
Monday 03/10/2011 Main ...
... only authorised personnel could refresh the data on the Excel spreadsheet and they would then save as PDF and send to appropriate staff.
Other Issues
I usually felt that CHAR(13) goes hand in hand ...
... summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a ...
The situation is that we are replacing a website-application with a single SQL Server Reporting Services (SSRS 2008 R2) report. We're using Business Intelligence Development Studio (BIDS VS2008) with ...
... to them...???
Staff member requiring access to a secure application
"So that's all installed for you. I just need you to restart your computer now and tell me when that's done.".
"I've done what ...
Situation:
I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different ...
... It was a custom-built 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 ...
... 5 columns:
MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user.
SELECT
CONCAT(MONTHNAME(t2.Date), ' ', ...
...
Some articles are available for public, some are restricted to staff and different localgroups.
When users click on the 'Login' link, we want the system to automatically prompt them for their username/password. ...
MyALN is a web-project where the original developer ended their support for the site. I was called in to fix several underlying issues and integrate it into the university systems. The Additional ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.