Importing Excel data into SQL Server and filtering columns of Excel data in SQL
I’m trying to import Excel sheet’s data into SQL server and filter column data.eg: pim ,rib,rpm,rms,ssrs ets sub topics comes under Oracle retail tower. Likewise, I need to filter for 9 other towers. How can I do this? Can anyone please help me?
Answer Question
| March 26, 2013 5:34 AM
Microsoft Excel 2010, SQL Server
I’m trying to import Excel sheet’s data into SQL server and filter column data.eg: pim ,rib,rpm,rms,ssrs ets sub topics comes under Oracle retail tower. Likewise, I need to filter for 9 other towers. How can I do this? Can anyone please help me?
Answer Question
| March 26, 2013 5:34 AM
Microsoft Excel 2010, SQL Server
Outlook web access gives service unavailable error
When we try to access the Exchange server using OWA access, we get the error “service unavailable”, using http://192.168.0.1/exchange. It’s on a member server, previously it was also a DC and Exchange server.
Answer Question
| March 26, 2013 5:30 AM
Microsoft Exchange Server, OWA
When we try to access the Exchange server using OWA access, we get the error “service unavailable”, using http://192.168.0.1/exchange. It’s on a member server, previously it was also a DC and Exchange server.
Answer Question
| March 26, 2013 5:30 AM
Microsoft Exchange Server, OWA
Old texts
Can I retrieve old texts that were saved on the phone without a SIM card?
Answer Question
| March 26, 2013 1:57 AM
Mobile, SIM card
Can I retrieve old texts that were saved on the phone without a SIM card?
Answer Question
| March 26, 2013 1:57 AM
Mobile, SIM card
PFO
I had a folder with password and know the Pismo File Mount Audit Package gave an “error 5″ and won’t let me open it. I uninstalled the program and when I go to install it, I get the same “error 5″. Please help, I need to open that folder.
Answer Question
| March 26, 2013 1:06 AM
PFO, Pismo
I had a folder with password and know the Pismo File Mount Audit Package gave an “error 5″ and won’t let me open it. I uninstalled the program and when I go to install it, I get the same “error 5″. Please help, I need to open that folder.
Answer Question
| March 26, 2013 1:06 AM
PFO, Pismo
Server upgrade 2003 to 2008
I’m upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I’m getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.
Answer Question
| March 26, 2013 10:13 PM
SQL Server 2003, SQL Server 2008 R2
I’m upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I’m getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.
Answer Question
| March 26, 2013 10:13 PM
SQL Server 2003, SQL Server 2008 R2
File server
Hi, can someone help me to get the right configuration for a file server? # of processors, memory, kind of Raid, etc? I need an HP Server with W28R2 or W2012, I also heard something about windows storage server? I have 300 users on this site, need to create public, and private shares, workgroup shares, [...]
Answer Question
| March 26, 2013 6:19 PM
HP Servers, Server administration
Hi, can someone help me to get the right configuration for a file server? # of processors, memory, kind of Raid, etc? I need an HP Server with W28R2 or W2012, I also heard something about windows storage server? I have 300 users on this site, need to create public, and private shares, workgroup shares, [...]
Answer Question
| March 26, 2013 6:19 PM
HP Servers, Server administration
Problem reaching FTP server from Internet (but not from computers on the LAN)
I have set up a FTP server. It is set up on a NAS drive (dlink dns-323), sitting on 192.168.1.103. It works whenever I try to connect to it from computers on my local network. But whenever I try to connect to it from the internet (by trying to connect to the external ip (from [...]
Answer Question
| March 25, 2013 5:33 PM
FTP, FTP Server, NAS
I have set up a FTP server. It is set up on a NAS drive (dlink dns-323), sitting on 192.168.1.103. It works whenever I try to connect to it from computers on my local network. But whenever I try to connect to it from the internet (by trying to connect to the external ip (from [...]
Answer Question
| March 25, 2013 5:33 PM
FTP, FTP Server, NAS
What is the performance parameter for cloud computing?
Could someone tell me what the performance parameter is for cloud computing?
Answer Question
| March 25, 2013 5:14 PM
Cloud Computing, cloud computing management
Could someone tell me what the performance parameter is for cloud computing?
Answer Question
| March 25, 2013 5:14 PM
Cloud Computing, cloud computing management
True type fonts – AS/400 v6r1
which directory do I have to place my true type fonts
Answer Question
| March 25, 2013 4:41 PM
AS/400
which directory do I have to place my true type fonts
Answer Question
| March 25, 2013 4:41 PM
AS/400
Canon ImageRUNNER on iSeries printing to specific mailboxes
We have connected a Canon ImageRUNNER to our iSeries via the network. I have created a Workstation Customization Object to send reports to a specific mailbox and can’t get the PJL code to work. I know the system is recognizing the Workstation Customization Object because I can get it to switch drawers but I can’t [...]
Answer Question
| March 25, 2013 4:07 PM
Canon ImageRUNNER, iSeries
We have connected a Canon ImageRUNNER to our iSeries via the network. I have created a Workstation Customization Object to send reports to a specific mailbox and can’t get the PJL code to work. I know the system is recognizing the Workstation Customization Object because I can get it to switch drawers but I can’t [...]
Answer Question
| March 25, 2013 4:07 PM
Canon ImageRUNNER, iSeries
Which VPN router works with Windows without client software?
I have a couple of WRV54G VPN routers. Windows don’t connect with them, even with QuickVPN software. I’m looking for a new box, which… 1) can accept roaming windows users without client software; and 2) is compatible with WRV54G. Would appreciate your recommendations.
Answer Question
| March 25, 2013 3:53 PM
VPN router, WRV54G
I have a couple of WRV54G VPN routers. Windows don’t connect with them, even with QuickVPN software. I’m looking for a new box, which… 1) can accept roaming windows users without client software; and 2) is compatible with WRV54G. Would appreciate your recommendations.
Answer Question
| March 25, 2013 3:53 PM
VPN router, WRV54G
Unidirectional replication in SQL Server 2008
Can transactional replication be bidirectional?
Answer Question
| March 25, 2013 2:29 PM
SQL Server 2008, SQL Server replication
Can transactional replication be bidirectional?
Answer Question
| March 25, 2013 2:29 PM
SQL Server 2008, SQL Server replication
Are softphones the future of BYOD?
As more enterprises move into the BYOD era, the term ‘softphones’ has become a key trait as it allows IT departments to deliver unified communication systems. According to Diane Meyers, an analyst for Infonetics Research, the relationship between a workplace phone extension and a hard phone will become a thing of the past. Are softphones [...]
Answer Question
| April 2, 2013 1:57 PM
BYOD, Softphone
As more enterprises move into the BYOD era, the term ‘softphones’ has become a key trait as it allows IT departments to deliver unified communication systems. According to Diane Meyers, an analyst for Infonetics Research, the relationship between a workplace phone extension and a hard phone will become a thing of the past. Are softphones [...]
Answer Question
| April 2, 2013 1:57 PM
BYOD, Softphone
cursor disappers
After a couple of miniutes in a dwg the Pick Bos /cross hairs dissapears and I have to end session & restart Acad. Is there any way to make the cursor reappear wotout leaving acad and restarting the program.
Answer Question
| March 25, 2013 12:12 PM
Pick Box
After a couple of miniutes in a dwg the Pick Bos /cross hairs dissapears and I have to end session & restart Acad. Is there any way to make the cursor reappear wotout leaving acad and restarting the program.
Answer Question
| March 25, 2013 12:12 PM
Pick Box
SAP upgrade regression test on year end processes
We have done a stack patch upgrade. Is it possible to do a regression test on my year end transactions like balances roll forward while we are still in period 10 of my fiscal year at the time of the patch upgrade test in QA environment? And if possible, how? This was found to be [...]
Answer Question
| March 25, 2013 11:48 AM
SAP, SAP Upgrade
We have done a stack patch upgrade. Is it possible to do a regression test on my year end transactions like balances roll forward while we are still in period 10 of my fiscal year at the time of the patch upgrade test in QA environment? And if possible, how? This was found to be [...]
Answer Question
| March 25, 2013 11:48 AM
SAP, SAP Upgrade
Password prompt for button click in Outlook 2003
Are there any macros or anyway where, when a button in Outlook 2003 is clicked, a password prompt should appear ?
Answer Question
| March 25, 2013 11:24 AM
Microsoft Outlook 2003, Microsoft Outlook features
Are there any macros or anyway where, when a button in Outlook 2003 is clicked, a password prompt should appear ?
Answer Question
| March 25, 2013 11:24 AM
Microsoft Outlook 2003, Microsoft Outlook features
Floor for data center
We have 3 floored building and required to position data center in one of the floors. Which is the right floor for data center?
Answer Question
| March 25, 2013 5:25 AM
Data Center, Data center design
We have 3 floored building and required to position data center in one of the floors. Which is the right floor for data center?
Answer Question
| March 25, 2013 5:25 AM
Data Center, Data center design
Router setup
Will a Netgear N600 wired to a Mac Desktop permit wireless access to an iPhone 5 and a TV?
Answer Question
| March 25, 2013 8:58 PM
iPhone 5, Netgear router
Will a Netgear N600 wired to a Mac Desktop permit wireless access to an iPhone 5 and a TV?
Answer Question
| March 25, 2013 8:58 PM
iPhone 5, Netgear router
Outlook display
I am using Outlook. My fonts are usually set, for the display, at 10, 11 or 12 pt. However sometimes, right in the middle of writing an e-mail, I do something and the font display gets very very small – about 2pt. Very difficult to read. I’m not sure how this happens or how to [...]
Answer Question
| March 25, 2013 5:28 PM
Microsoft Outlook, Microsoft Outlook features
I am using Outlook. My fonts are usually set, for the display, at 10, 11 or 12 pt. However sometimes, right in the middle of writing an e-mail, I do something and the font display gets very very small – about 2pt. Very difficult to read. I’m not sure how this happens or how to [...]
Answer Question
| March 25, 2013 5:28 PM
Microsoft Outlook, Microsoft Outlook features
I cannot sign in as an administrator on my own computer
How do I accomplish this on a DELL XP computer. I can’t sign in as an administrator and I’m having a lot of problems with my computer. I get an hourglass when I try to sign off my computer.
Answer Question
| March 25, 2013 5:21 PM
computer repair, Dell XP
How do I accomplish this on a DELL XP computer. I can’t sign in as an administrator and I’m having a lot of problems with my computer. I get an hourglass when I try to sign off my computer.
Answer Question
| March 25, 2013 5:21 PM
computer repair, Dell XP
