pcstru

It may be worth saying two things that are not directly helpful : 1. Avoid RAID 5 with large drives (or just avoid it). 2. In the event of a failure of a disc in a RAID 5 array, before sticking in a new disc and initiating the rebuild, backup the data (if you can). There is an implication here that you should never allocate a hot spare in a RAID5 array.

It's the kind of thing that is relatively easy to do in a procedural language but quite difficult to grasp as a relational query. Anyhow a little more on the pivot : Say we have a table which describes holiday spending having two columns, HolCode and Spend. Our HolCode might be seasons "Aut", "Spr" etc and each time we go on holiday and spend some money we just record it : Aut, 2.50 Aut, 1.10 Aut, 34.70 Spr, 10.72 Spr, 3.74 Spr, 8.93 Every year we want a report on the minimum we spent, the maximum, the average and the total for each holiday. We can just create a query for that and pivot the data around the Code : Select HolCode, Max(Spend) MaxSpend, Min(Spend) MinSpend, Avg(spend) AverageSpend, sum(spend) TotalSpend from holiday_spending group by HolCode Which should be about the simplest kind of pivot. But we can also throw some arbitrary processing in there - the kind of thing we like to do procedurally in a loop. So we might like to know how many times we spent over £10. The easy way would be a query just for that but we want it in our report as a column. MySQL allows you to use an IF function within a query (MsSQL would use case, Oracle ISTR was IIF) and we can embed that within a sum. Select HolCode, Max(Spend) MaxSpend, Min(Spend) MinSpend, Avg(spend) AverageSpend, sum(spend) TotalSpend, sum(if(spend > 10.0, 1, 0) ) NoOverTen from holiday_spending group by HolCode (again, I'm doing this from memory - I can't test at the moment so apologies if there are errors but they should be just syntax, the concept is sound ). So you just need to figure what you need to pivot around (what you are grouping by) and what you are looking at to generate the result you want from the source data for each of your MON1, MON2 etc columns. Hopefully that will see you through but if not shout, I'm happy to help.

Sorry to be harsh, but if you are sitting there being proud while customers are actively soliciting for alternative products, then you perhaps should question if pride isn't preceding a fall. Impero have had a succession of issues over the last few years, (including unacceptable support response times), any one of which should have been a wake up call to put things back on track. The fact that Impero have not taken those opportunities and continues to fail to provide an acceptable service to all their customers is a huge worry and your response is not comforting.

To use a view, you can just create view as select * from blah, but the actual query can be as complex as you like. Next time you need the report, just select * from view - job done. It will be up to date because it queries the data. No need to create and drop intermediate tables - hopefully. The complex select is just a pivot - honest guv, but it might be quite a complex query. I don't quite get : If we wanted to enumerate the 'week' data from the Period field, we might : select distinct MIS_Period from tbl_misdata; We could enumerate just part of that Period attribute space, select distinct ( LEFT(MIS_Period,3) ) possible_days from tbl_misdata; (Mon-Fri)? Again, I can't run these queries so they might be broken syntactically - sorry. The point is you can generate result sets (tables (which can be views)) of possible values. Create view possible_sessions as select distinct( right(MIS_Period,1) ) from tbl_misdata; Might work if my assumptions about your data hold. It should be the number of slots you have in the school day? That kind of enumeration might help create the final dataset (table) you want because to pivot on compound attribute (where information is coded into the columns attribute) you occasionally need to sort of generate more rows as an intermediate stage even if the pivot relies on grouping to consolidate some arbitrary criteria to a single row. Anyway if you can elaborate some on the output : You are also either creating a table for each booking room or you are going to a lot of trouble for one room?

Yes it did and there was largely the same arrogant reaction that we have nothing to learn from these people while we ignore that we likely do not actually have the required policy and procedure in place.

Need? It is up to them what they think they need and it is not for me to tell them what they need. If they ask, then IMO we should be willing to inform them. So security by obscurity. Good luck with that.

It is a pretty simple question : do we tell if asked. Your answer seems to be the same as mine, yes we do.

The advantage for the parent is to know you are using a recognised product supplied by a reputable company. Which is?

Right. So you would tell them. No need to keep it secret. I'd think our students could spot we use Impero fairly easily. I don't rely for security on students not searching for exploits. I rely on the product being secure no matter who tries to hack it. The question was should schools be telling parents what they use. The answer should be simply yes. It is software used to impose monitoring on their children. They a) have every right to know and b) could obtain the information via FOI. I can't see what could be gained by not considering the actual product that is used, essentially public information. I appreciate you don't want to swamp people, with information the have not requested, but that is surely not the issue that was in question.

The advantage is that you are being open and transparent about monitoring. If they are parents, I think they have a reasonable right to know. That might also serve us better when they discover that we do not have in place suitable policy and procedure to control monitoring. Or perhaps we are the only school that does not - but I somehow doubt that.

Why wouldn't you tell them? There is no security through obscurity and the law requires us to be open and transparent when it comes to monitoring; we have to tell people we are doing it and how we are doing it (who can monitor whom under what circumstances and what oversight is there).

On a serious note : Which perhaps suggest we are not getting the surrounding policy and procedure correct. We are meeting our obligations in some ways (monitoring) we are not meeting them in others (transparency, openness and appropriate controls).

Did you know that for the fire brigade water isn't actually wet enough. They add wetting agents to make even British water wetter.

I'm a little curious as to why are you trying to copy the data if the data already exists. If you need to make a report - you might consider creating a view. A view looks like a table but always sources from the maintained data. Anyhow ... the solution possibly has the same root; cross tab queries / pivot tables. If we have tables as described but we want to present data that is held vertically (in columns) horizontally as fields, then we can use grouping and aggregate functions to do this. Table1 [b]Period Staff[/b] MonA1 STA MonA3 STA MonA1 STB MonA2 STB MonB1 STA View [b]Staff MonA1 MonA2 MonA3 MonB1[/b] STA Y Y Y STB Y Y (sorry formatting doesn't hold up well but hopefully you can see the intent!) To do this the SQL might look something like : Select unique( staff ) MAX(case when Period = 'MonA1' then "Y" else "" end) MonA1 MAX(case when Period = 'MonA2' then "Y" else "" end) MonA2 MAX(case when Period = 'MonA3' then "Y" else "" end) MonA3 MAX(case when Period = 'MonB1' then "Y" else "" end) MonB1 MAX(case when Period = 'MonB2' then "Y" else "" end) MonB2 group by staff Which will produce one row per member of staff (assuming unique staff codes) with the period data indicated in the appropriate column. (I say something like because I don't have my examples to hand or time to create the tables to test syntax etc, but hopefully this is enough to push you pretty far along in the right direction).

Sharepoint.

Watched 4 episodes of The Crown. Generally very good - if you like a good historical costume drama you will lap it up.

I look to leasing for big ticket items which are prone to be extensive to maintain : so I'd think we are unlikely to ever purchase MFD's and copiers outright. Otherwise I find leasing takes away flexibility especially in an environment where budgets are highly variable from year to year. So sure, I don't want to operate machines over 5 years old, but over the last few years doing that has been critical (and 5 year old processors are generally fine for most current workloads). It's also been highly beneficial to be able to upgrade machines (RAM and SSD's) to extend the life of stock - again the flexibility of ownership has been a boon in the circumstances we have found ourselves in. IMO if leasing is being driven by financial constraints (lack of money) then leasing is actually a poor way to manage the financial risk (you are effectively gambling that you will have that money in future).

Ah (lightbulb moment!). Which is presumably why they have triple glazing rather than just going for a larger gap!

Ex VAT.

I was just going by the blurb on the link you posted. They look like a cheap pick for a window option by the builders. I'd be concerned about proper ventilation given what you said about building certificates when you were buying. PIV might be a very effective counter if the builder has compromised ventilation. Double glazing should alleviate condensation build up on the windows but it may not eliminate it entirely. Get a cheap humidity sensor and start to keep a log of readings. That will give you data against which you can measure anything you try. (I couldn't see that the window in the blurb was double glazed but I didn't think you could fit single glazed windows these days other than special cases (conservation/listed buildings)). Having a replacement fitted is likely to be £300-£500 labour + the cost of the window, but it could even be more. Depends on too many factors to be anything more than a guess.

Right. Dehumidifiers will only deal with the symptom - the actual problem is very likely to be inadequate ventilation. I notice BB's windows do vent but rather than separate vents, it is a stage of the lock (IOW you don't quite shut them but they lock).

There are a few different types of dehumidifier. The cheaper ones using peltier elements can be quite horribly inefficient. A good rule of thumb for cost is 1W Year = £1 (leave a 100W PC on all year and it will cost you ~£100). I'd also be wary of a dehumidifier in a bedroom. They can be quite noisy.

Another option is a vent with a heat exchanger (it takes heat from the air being expelled and uses it to heat up incoming air). You can get these for single rooms or whole house systems. Some are available with humidity sensors so they only cut in when (roughly) needed. In a bedroom, the source of the condensation might well be human...

Is something spamming a log file? Are you generating binary log files from MySQL? This may be useful info to find which process and file is the culprit.

It would be helpful if you posted the files, Output.txt and file.txt then one could test it. Lacking that, I've not even tried to run the following code. I think you may just need to add something to track matched instances and increment array pointer so : $Basename = gci c:\Tools\reg | % {$_.BaseName} #$Output = Set-Content -Value $Basename -Path C:\Tools\Powershell\Output.txt iIdx = 1 (Get-Content C:\Tools\Powershell\file.txt) | Foreach-Object { $_ # send the current line to output if ($_ -match "Insert") { #Add Lines after the selected pattern "$Basename[iIdx]" iIdx++ } } | Set-Content C:\Tools\Powershell\file.txt