Concentrate more than two fields together into one field in SQL
SQL Server doesn’t have the STRIP and CONCATINATION functions which were mentioned in the prior version of the answer. You use the + sign to join the strings together, something like this. <pre>SELECT FirstName + ', ' + CASE WHEN MiddleName IS NULL THEN '' ELSE MiddleName + ', ' END + LastName FROM YourTable</pre> [...]
View Answer
| April 19, 2013 9:06 AM
Concatenate, CSV, SQL, SQL Server
SQL Server doesn’t have the STRIP and CONCATINATION functions which were mentioned in the prior version of the answer. You use the + sign to join the strings together, something like this. <pre>SELECT FirstName + ', ' + CASE WHEN MiddleName IS NULL THEN '' ELSE MiddleName + ', ' END + LastName FROM YourTable</pre> [...]
View Answer
| April 19, 2013 9:06 AM
Concatenate, CSV, SQL, SQL Server
Ideal temperature and humidity for server room (not data center)
Ideal is about 68 Degrees Fahrenheit and between 40% – 60% humidity. ********************** There is a very useful page that discusses this very subject. The numbers on the page support the answers given so far. There is also information on that page about how to maintain that temp. Good Luck! -Flame ********************** It is more [...]
View Answer
| April 19, 2013 2:57 AM
Server room, Server room cooling, Server room design, Server room humidity control
Ideal is about 68 Degrees Fahrenheit and between 40% – 60% humidity. ********************** There is a very useful page that discusses this very subject. The numbers on the page support the answers given so far. There is also information on that page about how to maintain that temp. Good Luck! -Flame ********************** It is more [...]
View Answer
| April 19, 2013 2:57 AM
Server room, Server room cooling, Server room design, Server room humidity control
VB.NET code to search if a record already exists or not
If you are getting errors with the code you posted, please provide the exact error messages or tell us what the problem with that code is. If this code is working but you want to add the necessary logic to check if the record already exists before inserting it, you could put the insert into [...]
View Answer
| April 19, 2013 2:28 PM
Database programming, Search string, SQL Database, VB .NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005
If you are getting errors with the code you posted, please provide the exact error messages or tell us what the problem with that code is. If this code is working but you want to add the necessary logic to check if the record already exists before inserting it, you could put the insert into [...]
View Answer
| April 19, 2013 2:28 PM
Database programming, Search string, SQL Database, VB .NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005
How to backup Lotus Notes mail
The easier approach is to move your old mail in an archive database. Notes will create it automatically (from the mailbox model) when you will archive your first message. It will move all the mail you select (or older than…) from one database (with quota) to an other (archive, without quota, that you could burn [...]
View Answer
| April 19, 2013 1:04 PM
Lotus Notes, Lotus Notes backup, Lotus Notes Mail Backup
The easier approach is to move your old mail in an archive database. Notes will create it automatically (from the mailbox model) when you will archive your first message. It will move all the mail you select (or older than…) from one database (with quota) to an other (archive, without quota, that you could burn [...]
View Answer
| April 19, 2013 1:04 PM
Lotus Notes, Lotus Notes backup, Lotus Notes Mail Backup
Connecting two Windows 7 machines via WiFi?
Yes you can You dont need a router to create an Adhoc connection between the two computers for file transfer. 1. make sure the wireless is switched on in both machines 2. on computer 1 click start>ctrl panel>network & Sharing. then click setup a new connection or network 3. after you click “setup a new [...]
View Answer
| April 19, 2013 8:37 AM
802.11n, Network connectivity, Wifi, Windows 7, Windows 7 in 2010, Wireless in 2010
Yes you can You dont need a router to create an Adhoc connection between the two computers for file transfer. 1. make sure the wireless is switched on in both machines 2. on computer 1 click start>ctrl panel>network & Sharing. then click setup a new connection or network 3. after you click “setup a new [...]
View Answer
| April 19, 2013 8:37 AM
802.11n, Network connectivity, Wifi, Windows 7, Windows 7 in 2010, Wireless in 2010
How to copy or move Active Directory to new server
Hi you can do this my seizing the FSMO roles; briefly you make the new server a member of the AD and then transfer all roles and the DSN zones to the new one. For more information read this article and the next one. ———————————— Not much to it. All you need to do is [...]
View Answer
| April 19, 2013 8:23 PM
Active Directory, Active Directory migration, Windows Server 2003
Hi you can do this my seizing the FSMO roles; briefly you make the new server a member of the AD and then transfer all roles and the DSN zones to the new one. For more information read this article and the next one. ———————————— Not much to it. All you need to do is [...]
View Answer
| April 19, 2013 8:23 PM
Active Directory, Active Directory migration, Windows Server 2003
Net meeting in Windows 7?
NetMeeting isn’t included in Windows 7; it’s now called Microsoft SharedView. There is a small download that needs to be installed on each machine wanting to join the meeting. Up to 15 participants are allowed, and this program works on Windows 7, Vista, XP, Windows Server 2003 machines also. The link is : www.microsoft.com/downloads/details.aspx?familyid=95af94ba-755e-4039-9038-63005ee9d33a&displaylang=en The [...]
View Answer
| April 19, 2013 8:58 AM
Netmeeting, Windows 7, Windows networking, Windows Server 2003, Windows XP
NetMeeting isn’t included in Windows 7; it’s now called Microsoft SharedView. There is a small download that needs to be installed on each machine wanting to join the meeting. Up to 15 participants are allowed, and this program works on Windows 7, Vista, XP, Windows Server 2003 machines also. The link is : www.microsoft.com/downloads/details.aspx?familyid=95af94ba-755e-4039-9038-63005ee9d33a&displaylang=en The [...]
View Answer
| April 19, 2013 8:58 AM
Netmeeting, Windows 7, Windows networking, Windows Server 2003, Windows XP
USB External Hard drive and Windows XP
You might want to check in disk management and see if the system is seeing the drive and what drive letter is assigned – Windows tries to assign the next drive letter – even if it’s already assigned to something. If you see the drive in Disk Management – then just assign it a different [...]
View Answer
| April 19, 2013 8:28 AM
Adapters/Interfaces, Billing and customer care, Billing Support Systems, Desktops, Development, Disk drives, Fibre channel, Hardware, Management, Microsoft Windows, OS, Security, Servers, SQL Server
You might want to check in disk management and see if the system is seeing the drive and what drive letter is assigned – Windows tries to assign the next drive letter – even if it’s already assigned to something. If you see the drive in Disk Management – then just assign it a different [...]
View Answer
| April 19, 2013 8:28 AM
Adapters/Interfaces, Billing and customer care, Billing Support Systems, Desktops, Development, Disk drives, Fibre channel, Hardware, Management, Microsoft Windows, OS, Security, Servers, SQL Server
How to create our own set up file in VB 6.0
Your best bet and easiest method if you have the complete visual studio installed would be to download the visual studio installer from the Microsoft site. It builds MSI packages and allows a decent range of modifications that you can make to the setup. Other than this, you would have to get some different kind [...]
View Answer
| April 19, 2013 10:46 AM
Career development, Data analysis, Development, Lifecycle development, Project management, Training, Visual Basic
Your best bet and easiest method if you have the complete visual studio installed would be to download the visual studio installer from the Microsoft site. It builds MSI packages and allows a decent range of modifications that you can make to the setup. Other than this, you would have to get some different kind [...]
View Answer
| April 19, 2013 10:46 AM
Career development, Data analysis, Development, Lifecycle development, Project management, Training, Visual Basic
Major differences between Outlook 2007 and 2010?
Try this…It’s the Wikipage, but it includes a section on added features (this would let you know how 2010 has changed from 2007. Hope this helps! -Schmidtw Here’s another comparison: Office 2007 and 2010 comparison.
View Answer
| April 19, 2013 2:02 PM
Outlook, Outlook 2007, Outlook 2010, Outlook Upgrade, Windows 7, Windows 7 in 2010
Try this…It’s the Wikipage, but it includes a section on added features (this would let you know how 2010 has changed from 2007. Hope this helps! -Schmidtw Here’s another comparison: Office 2007 and 2010 comparison.
View Answer
| April 19, 2013 2:02 PM
Outlook, Outlook 2007, Outlook 2010, Outlook Upgrade, Windows 7, Windows 7 in 2010
How to delete Outlook meetings when Originator has left the organization.
When you open the recurring meetings, it should tell you who the organizer was. If it shows the organizer to be the exec who has not left yet, he will have the option to send out cancellations. If he simply deletes instead of sending the cancellation he may need to recover them from his deleted [...]
View Answer
| April 19, 2013 2:14 PM
Calendar, Exchange 2003, Outlook 2003, Outlook calendar, Outlook meetings
When you open the recurring meetings, it should tell you who the organizer was. If it shows the organizer to be the exec who has not left yet, he will have the option to send out cancellations. If he simply deletes instead of sending the cancellation he may need to recover them from his deleted [...]
View Answer
| April 19, 2013 2:14 PM
Calendar, Exchange 2003, Outlook 2003, Outlook calendar, Outlook meetings
How do I forward a meeting invitation
In your calendar, highlight/pick the meeting you want to forward then go to the top menu pick ACTIONS and then select FORWARD from the pick list.
View Answer
| April 19, 2013 6:17 PM
Lotus Notes, Lotus Notes 8.x, Lotus Notes Meeting, Lotus Notes Meeting Invitations
In your calendar, highlight/pick the meeting you want to forward then go to the top menu pick ACTIONS and then select FORWARD from the pick list.
View Answer
| April 19, 2013 6:17 PM
Lotus Notes, Lotus Notes 8.x, Lotus Notes Meeting, Lotus Notes Meeting Invitations
DB2 Unload and Load JCL using IBM utility
The first place you should look at the manuals and your coworkers. You need some education. You cannot be expected to know how to use DB2 just off the street. DB2 on z/OS is about the best there is, but it is complicated. Go to your boss and explain that you do not know DB2. [...]
View Answer
| April 19, 2013 5:55 PM
DB2, IBM Mainframe, JCL
The first place you should look at the manuals and your coworkers. You need some education. You cannot be expected to know how to use DB2 just off the street. DB2 on z/OS is about the best there is, but it is complicated. Go to your boss and explain that you do not know DB2. [...]
View Answer
| April 19, 2013 5:55 PM
DB2, IBM Mainframe, JCL
How can I use mscal.ocx on a Windows 7 64-bit machine?
Actually, a bit more info. I was running regsvr32 straight from the “run” command line. If I run it from C:windowssyswow64 I get a different error: “The module c:windowssystem32mscal.ocx failed to load. Make sure the binary is stored at the specified path or debug it to check for problems with the binary or dependent .DLL [...]
View Answer
| April 19, 2013 3:35 PM
Excel 2003, Visual Basic Script, Windows 7, Windows 7 64-bit
Actually, a bit more info. I was running regsvr32 straight from the “run” command line. If I run it from C:windowssyswow64 I get a different error: “The module c:windowssystem32mscal.ocx failed to load. Make sure the binary is stored at the specified path or debug it to check for problems with the binary or dependent .DLL [...]
View Answer
| April 19, 2013 3:35 PM
Excel 2003, Visual Basic Script, Windows 7, Windows 7 64-bit
Steps to connect Printer in LAN
Simply connect an ethernet cable from any available port around your house to your printer and when it is on you should be able to print from anywhere on the same LAN.
View Answer
| April 19, 2013 8:57 PM
ATM, Networking, Networking Equipment, TCP
Simply connect an ethernet cable from any available port around your house to your printer and when it is on you should be able to print from anywhere on the same LAN.
View Answer
| April 19, 2013 8:57 PM
ATM, Networking, Networking Equipment, TCP
Changing user profiles in a CL program
use command wrkusrprf
View Answer
| April 18, 2013 7:04 PM
CL Program, JOBD, QGPL
use command wrkusrprf
View Answer
| April 18, 2013 7:04 PM
CL Program, JOBD, QGPL
How to find a specific word in a SQL table
You would have to search for the word with spaces on one side, as well as on other sides. As a second option you could use full text indexing to search for the word bob, but if you are searching for words such as “and” you’ll have to do some additional configuration to be able [...]
View Answer
| April 18, 2013 4:42 AM
SELECT statement, SQL, SQL Query, WHERE statement
You would have to search for the word with spaces on one side, as well as on other sides. As a second option you could use full text indexing to search for the word bob, but if you are searching for words such as “and” you’ll have to do some additional configuration to be able [...]
View Answer
| April 18, 2013 4:42 AM
SELECT statement, SQL, SQL Query, WHERE statement
Where do I download IBM iSeries ACCESS 6.1 x32 bit for Windows 7
To download the software from IBM site, you need an IBM Id and password. You can register the same on following website for free. http://www-03.ibm.com/systems/i/software/access/index.html
View Answer
| April 18, 2013 2:59 AM
AS/400, iSeries Access
To download the software from IBM site, you need an IBM Id and password. You can register the same on following website for free. http://www-03.ibm.com/systems/i/software/access/index.html
View Answer
| April 18, 2013 2:59 AM
AS/400, iSeries Access
RAID to HP ProLiant DL360 G5 server
The HP Server should have come with a SmartStart CD/DVD that you can boot the server off of and configure the RAID controller. If it didn’t, you can download it from the HP support site. (Thanks Jmm-irl for reminding me of the SmartStart name. I couldn’t remember it for the life of me.) on boot [...]
View Answer
| April 18, 2013 12:03 AM
HP ProLiant DL360 G5, RAID, RAID configuration
The HP Server should have come with a SmartStart CD/DVD that you can boot the server off of and configure the RAID controller. If it didn’t, you can download it from the HP support site. (Thanks Jmm-irl for reminding me of the SmartStart name. I couldn’t remember it for the life of me.) on boot [...]
View Answer
| April 18, 2013 12:03 AM
HP ProLiant DL360 G5, RAID, RAID configuration
Crystal Reports – How to force page break
Here is the information I’ve found on several sites. 1. You *must* put the cross-tab itself in Group Header #1 (pre-req). 2. The GH1 field would be the field you want to break on, in your case, “department” (via right-click. “Change Group”, selecting department rom the first dropdown on the “Common” tab). 3. Right-click on [...]
View Answer
| April 18, 2013 3:08 PM
Crystal Reports
Here is the information I’ve found on several sites. 1. You *must* put the cross-tab itself in Group Header #1 (pre-req). 2. The GH1 field would be the field you want to break on, in your case, “department” (via right-click. “Change Group”, selecting department rom the first dropdown on the “Common” tab). 3. Right-click on [...]
View Answer
| April 18, 2013 3:08 PM
Crystal Reports
