Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Desktops, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Excel, Microsoft Exchange, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
I have a database that contains path diagnoses (rows) and stains (columns) used to determine diagnoses. Therefore for any single entry there may be multiple empty columns. When I make a pivot table I want to be able to show only columns with data in them.
Hi, My code is invoking Excel process to generate the report and that is killing once the process is completed. But sometime, couple of Excel.exe process is getting struck even the session is ended. Which is causing NFS memory full. Please advise me of what the the root cause to this issue is. By...
Not all my recipients from my Excel document are in my mail merged document
I am looking for an explanation of how a privilege escalation hack would be able to be inserted with a call to doscreatemutexsem function from a windows service that is running under the local system account. I was unable to find anything on Google and not being a security expert I just don't see...
Looking at migrating a municipality from Windows to Linux on servers and mainframe. Looking for cost effective models eg LAMP on web servers, CentOS or Fedora on mainframe with Oracle or straight to Oracle Linux and Ubuntu on desktop? Need some ideas.
Is anything worst than to deal with HP printers?
How can I count the number of lines of code in c-spec with eliminating d and f-spec?
I'm looking to create a SQL script to see if a sequence exists in my SQL Server 2012 database. I understand the concept of stored procedures but not with sequence.
I have a business client uses Microsoft Hosted Exchange. One of the 15 users is having difficulty creating appointments in shared calendars. On one PC, she uses Office 2007 with Outlook 2013, and on another, Office 2013. In the shared calendars, when this user tries to add an appointment to any...
I have 5 PF. Now I want to select data from my PF and selected data need to convert into XML. Please give me guidelines, how do I do a step-by-step?
What do you understand by loop in flowchart?
I want to write a function that returns a tuple of (start,end) where start is the Monday at 00:00:00:000000 and end is Sunday at 23:59:59:999999. start and end are datetime objects. No other information is given about day, month or year. i tried this functiondef week_start_end(date):start=...
HI ,I'm currently learning Oracle. Is it wise to Take up MCSE :Data platform as well to get a fill for both platforms ?
I'm rewriting an application for my company which requires a database. I will be updating the database using SQL Server 2008 R2. Now, here's my big question: Should I use PostgreSQL 9?Note: I won't be doing any conversions so that's not a problem.
I am trying to count logins by hour, by month, etc., in SQL Server 2008. To do this, I believe I need to create two PIVOTs or an UNPIVOT and then PIVOT? However, I can't seem to make it work. SELECT loginid ,DATEPART(MONTH,logtime) Month , DATEPART(HOUR, logtime) Hour FROM somelog (nolock) ) temp...
I just recently moved my .NET Development over from a Core2Duo to a new Core i7-3820 machine. No changes were made to the project code and both run on SQL Server 2012 Express.For the past week, I've seen a dramatic slowdown with INSERT INTO commands. Can someone tell me why this is happening?...
after a migration from winxp to win7, my encrypted *.enp files cannot be opened. i have sensible data there and cannot open them with any program. i really need some help.many thanksana
I have configured my server with a static IP and installed SQL Server 2008 R2 with ITAPP. The following happens when I use the IP to access SQL Server: Client Machine: sqlcmd -S XXX.XXX.XXX.XXX -U sa -P mypass A successful connection! But when I use: sqlcmd -S XXX.XXX.XXX.XXX\ITAPP -U sa -P mypass...
This is more a general question but a friend of mine is in the business of making websites and applications that aren't mission critical. So with that, is it bad practice to use the NOLOCK hint in SQL Statements? He was told by an SQL administrator that he should use it if he's satisfied with a...
How to give access to the sign off database for user?