I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on ...
... start time, end time...
Report Specification
PivotTable Report
...resources in row (along the side)...
...staff in columns (along the top)...
...persondays in values (the ...
... mseconds)
I want to total 3 of the columns (which measure in milliseconds) and convert to a time value with milliseconds showing.
Now why don't these match?
Using in an aggregate, how do I get the ...
... you're getting yourself into)
Go to Settings
Select Create View
Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet one)
Give the view a name, select what columns ...
Well I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing ...
... is what I use most frequently].
Additional:
Suppose you have lots of columns, you don't want to have to click on each cell to specify this so just do it to the first column then bring up the properties ...
... -- date used in all calculations for date
d.[Date],
--generates matrix columns
[WeekDay] = DATEPART(WEEKDAY, d.[Date]),
--used to display day of month on calendar
[Day] = DATEPART(DAY,d.[Date]),
...
... produce double the number of columns.
My Solution
SELECT
title,
intro
FROM
(
SELECT
`title`,
`introtext` intro
FROM
`jos_content` a
WHERE
a.state=1
UNION ALL ...
... @GivenCampus = 'Lansdowne Campus'
SET @specifiedDate = (SELECT @GivenDate)
SET @specifiedCampus = (SELECT @GivenCampus)
-- Get columns SetId and WeekNumber from the weekstructure table based ...
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.