Hi, we are about to begin using Angular and some people would like to use Visual Studio 2022 whereas others favour Visual Studio Code. I assumed Visual Code to be the standard and hasn't realised it was possible to develop Angular sites using Visual Studio 2022. Are there any clear advantages of using either? Thanks.

Hi, I'd like to update an item from my collection. I used the code below but this calls the Dispose event which I'd like to avoid. this.CurrentUser.Companies[idx] = comp; So instead I'd like to use something like below which works and doesn't trigger the Dispose but seems inefficient with 4 calls made. Does that make sense? Can anybody please recommend a more efficient approach? private void UpdateCompanyFields(int idx, Company comp) { this.CurrentUser.Companies[idx].BusinessName = comp.BusinessName; this.CurrentUser.Companies[idx].Address.AddressOne = comp.Address.AddressOne; this.CurrentUser.Companies[idx].Address.AddressTwo = comp.Address.AddressTwo; this.CurrentUser.Companies[idx].Address.City = comp.Address.City; }

Thanks for your help and reply but I think the solution isn't to change the security setting on the email group - it is to ensure that the user authentication is completing successfully. This is what I have no idea about how to check. A reboot of the node may resolve it but I'd like to think it may be caused by a SQL Server user configuration setting that I can test/change and resolve without the need for a reboot. I'd like to understand more about the problem as I don't have much knowledge of diagnosing this user configuration/authentication.

Hi I have a SQL Agent task which sends an email to all staff. The email is different because it sends it to a group which has "require that all senders are authenticated" ticked in their settings. This task works fine from one node in our availability group. I've copied the job to a secondary node and it says successful but no email is sent. We've investigated and can see a blocked email with the error: "Your message can't be delivered because delivery to this address is restricted". I have restarted the SQL Agent service which didn't make any difference. The database mail looks to be configured in exactly the same way it is on the other node where it works fine. Any ideas why it is not authenticating properly please? A reboot is an option but we'd rather not do this.

Hi, we have a standard SharePoint 2007 Intranet. I would like some users to be able to edit a document however they cannot see the Site Actions -> View All Site Content. I'd rather they don't have access to edit pages, what is the best way of providing this? I've given them access on the file itself however when they open the document and edit and save it, a message appears saying the file is read-only. Can anybody please advise/help? Thanks

Hi, I have a report which will produce different numbers of columns depending on the client that is selected. There may be a dozen clients and the columns might be named differently so it's all completely dynamic. I'm not quite sure how to arrange this in an SSRS report or even if it is possible. Can anybody please shed light on how I can do this? Thanks

I achieved this in the end by dynamically creating strings to pass in to a SQL statement I was building up. I used MAX and Case statements to achieve this. I finished it an EXEC (@MyString). Thanks for the advice!

Wow, looks a great article. Thanks, will take a look at this and reply once I have.

Thanks CHill60, yes I will need to use dynamic SQL. I've seen various articles using cursors, XML, etc. I just wondered which was the best approach to take.

You're quite right sorry, I've amended the data. Thanks!

Hi, I have a problem generating SQL to return a single row for a client. My table structure is the following... Clients - ClientID, ClientName Statuses - StatusID, StatusDescription, ClientID StatusMappings - StatusID, ClientID The statuses can be different depending on the client, so for example, clients table: 1, Barclays 2, Halifax Statuses table: 1, Draft Letter, 1 2, Complete, 1 3, Draft Letter, 2 4, Awaiting Response, 2 5, Complete, 2 StatusMappings table: 1, 1 (Draft Letter for Barclays) 3, 2 (Draft Letter for Halifax) 4, 2 (Awaiting Response for Halifax) How I want to display the data in a report (based on client selected), for example : Client | Draft Letter | Awaiting Response | Complete | ------------------------------------------------------------- Halifax Y Y I'm not sure how I would best write the SQL for this. Also I would like to produce SSRS reports based on it. Can anybody please advise? Thanks

Hi, I'm looking for a classic and simple N-Tier design using earlier .NET architecture rather than MVC. I haven't done this for years. I was thinking of having a class with my table structure in terms of the properties/fields. Then maybe having a separate DAL class for the methods such as Read, Save, Update and Delete. In terms of the class design, if I have several tables using the same methods, is there a particular design I should follow. I realise there are many ways of achieving this but I'm looking for something simple that junior developers can follow easily. Can somebody please recommend or maybe offer a link to a good article for this? Thanks

Hi, on my SharePoint 2013 site I wish to change an image on the mouse hover over it to a completely different image. I can do this fine in ASP.NET with JavaScript but SharePoint strips out the onmouseover and onmouseout text from my controls. How can I do this otherwise? I've not installed/setup jQuery and would need instructions on how to do that please if that is an offered solution.

Will have a go, thanks!

That's great, thanks very much!

Hi, we have around 15 .NET 2.0 and .NET 3.5 applications and I've created a new .NET 4.0 app. I would like to put this with the others on our new web server however when deploying I get an error about duplicate entries in the web.config. I think it specifically relates to tags like System.Web.Extensions and clashes with the machine.config on the server. If I remove these tags then I'm sure the error will go away. My question is...what's the best approach here? Surely removing these tags every time I deploy is not the solution. Should I upgrade all the applications to .NET 4.0? If so, what then? Would I simply remove the duplicate entries from the machine.config rather than the web.config for each deployment? Can somebody please advise on the best solution moving forward for this problem? Thank you!

That's perfect and brilliant, thank you very much!

Hi, I would like to add a link from the browser which opens a video in the VLC application that everybody has installed here. Is there a way of doing this in HTML or JavaScript?

Sorry my data was bad. Hopefully this makes more sense: 1. The time a job takes for a person to close is the difference between when a job is assigned to a user and when that user closes the job. 2. A job can be re-opened which I guess means I need to use MIN and MAX for a given job. Here's better data: JobID User TaskID Task AuditDatetime 17 Bob 2 Opens job 1/8/2014 11:14:29 17 Bob 5 Closes job 2/8/2014 10:12:26 22 Joe 2 Opens job 2/8/2014 11:01:45 22 Bob 5 Closes job 3/8/2014 11:44:22 25 Bob 1 Opens job 4/8/2014 11:40:22 25 Joe 3 Assigned job 5/8/2014 11:47:22 25 Joe 5 Closes job 5/8/2014 11:49:22 The jobID is a request made to the service desk. The TaskID can be opens, assigns, closes. I'll only be able to report on jobs closed too I suppose rather than open jobs too I guess? This is actually pretty complicated as there's also on hold items but I will forget about these for now.

Hi, I've been asked to write a report which lists the average time it takes for a helpdesk job to be closed. There isn't a closed date as such, the table column is simply an audit date/time which can be for various tasks. I need to use this column along with another which is an ID of the action. For example: User TaskID Task AuditDatetime Bob 2 Opens job 1/8/2014 11:14:29 Bob 5 Closes job 2/8/2014 10:12:26 Joe 2 Opens job 2/8/2014 11:01:45 Bob 5 Closes job 3/8/2014 11:44:22 My SQL is very rusty, I'm sure the report is technically possible but I can't for the life of me figure out what the SQL is. Can anybody please help? I'm aware of the SQL AVG function and also know I may need to GROUP BY the user. I'm thinking some kind of CASE statement perhaps but again I can't think of the SQL to achieve this...