How to convert XML data into tabular form in SQL Server 2005
Hi, I have a concatenated string of XML data. I need to convert the string into tabular form. Please suggest how it can be done. Thanks in advance!

Answer Question   |  November 29, 2010  12:02 PM
SQL Server, SQL Server 2005, XML, XML development, XML File Creation

Do I need SQL?
DO I need it? I am just a home user anf oerform simole tasks, but have 8 examples of SQL programs in my program list. I have win 7 64 bit O/S

Answer Question   |  November 29, 2010  11:19 AM
SQL, SQL procedure, SQL Server, SQL statements

VB for Excel
I have an Excel Workbook (Template) inkl VB Modules and Forms. I want to export the Modules & Forms so that it can be stored at one place, but accessible from several Workbooks (different Periods etc) of the same type. How do I do this?

Answer Question   |  November 29, 2010  9:09 AM
excel, Excel workbooks, VBE, Visual Basic

Not able to restore Logical File after it was damaged and deleted
We have deleted a Logical File from our system, since it was damaged. But now when we are restoring it from the Entire System using RSTOBJ, the Job is Failing and upon viewing the Joblog below messages are displayed. RSTOBJ OBJ(ZUNS) SAVLIB(PRTDEVDTA) DEV(TAP02) OBJTYPE(*FILE) SEQNBR(344) New format ZUNSREC created for file ZUNS.                                Member ZUNS already [...]

Answer Question   |  November 29, 2010  8:10 AM
AS/400 administration, IBM System i 550, Logical Files, Restore files, RSTOBJ

Downloading driver for Windows 7 Mercury PVM
Hi Guys Please I need this Driver!(Mercury pvm7pro vga diver)i have try this links but that file couldn’t download that driver file!!:(( I thought that was a problem of my internet connection.. But it doesn’t … I tried with different types of net connections but result is same….. (((((>>>>>> http://www.google.com/search?q=pvm7pro&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a   

Answer Question   |  November 29, 2010  5:25 AM
Drivers, Windows 7, Windows 7 Administration, Windows 7 deployment, Windows 7 Professional

How do I keep the original value of a field in Access 2010?
Hello, I have an inventory with varying prices (which may change weekly).  I need to compare the current price with the original price. However, I only want the users to input one price value in a form.  I’ve tried to do this with a datamacro and the “old” command, but every time i update the [...]

Answer Question   |  November 29, 2010  12:28 AM
Access 2010, Access Database, Access forms, Access Forms Database, office 2010

Mac filtering via Windows 2008 RADIUS server
Trying to Configure a RADIUS server 2008 r2 to house a set of Mac addresses that are allowed to connect to the network. I’m using Cisco aironet 1142N. I’m pretty new at this and will need some major help. Thanks to anyone who can help.

Answer Question   |  November 30, 2010  10:46 PM
Aironet, Cisco Aironet, Radius Server, Windows Server 2008, Windows Server 2008 R2

DNS log filling with errors in Windows Server 2003
I have a problem that is really driving me crazy at the school where I provide technical support. I think it is a DNS issue that I can’t seem to resolve. My DNS event log is filling up with errors (well – warnings) but I think that are really causing problems. They are Event ID 3000, [...]

Answer Question   |  November 29, 2010  8:05 PM
DNS, DNS errors, Networking, Windows Server 2003, Windows XP, Wireless

Resetting wireless adapter
Why do I have to reset the wireless adapter on my laptop when the other 3 computers using the same router never do ?

Answer Question   |  February 16, 2011  7:04 PM
Netgear router, wireless adapter, Wireless router interference, Wireless routers

Unopened e-mail reminder in Outlook 2003
I just got a new computer with Windows 7. I still have the same version of Outlook 2003 that I had before, but now when I receive a new e-mail the envelope appears for 10 or 15 seconds then goes away instead of remaining until I open the e-mail. How can I change this?

Answer Question   |  November 29, 2010  6:59 PM
Outlook 2003, Outlook 2003 email, Outlook 2003 Inbox Management Tools, Outlook rules and alerts

Example of Cobol call to an SQL stored procedure
I am new to the iSeries and need to know how to use a Cobol program to call an SQL stored procedure. Someone has already created the stored procedure for me, but I am not sure how to call stored procedures in Cobol on the iSeries. The passed data looks like: FIND_CLIENT ( IN LastName [...]

Answer Question   |  December 3, 2010  6:05 PM
COBOL, iSeries, iSeries Cobol programming, SQL stored procedures, Stored Procedures

Problem Accessing Web Server via HTTP After Changing Wireless router
Hi there, I have query regarding a wireless router. My internet connection setup consists of an ADSL modem (D-link DSL-320T) connected via an Ethernet cable to a wireless router (D-link DIR-615). My network appliances in turn connect to the router wirelessly. Originally, I had the modem connected to the DIR-615 wireless router (***model = H/W [...]

Answer Question   |  February 9, 2011  5:39 PM
D-Link, D-Link routers, HTTP, Network, Web Server, Wireless router

Need project plan for Access 2007 database migration to SQL Server
project plan with steps outlined

Answer Question   |  January 12, 2011  5:36 PM
Access 2007, Access Database, SQL Database, SQL Server, SQL Server database, SQL Server migration

Deleting unmatched records from a file in iseries SQL
I’m trying to delete unmatched records from file A based on file B. The files are matched by ListNo. Code: DELETE FROM DVMURRAY/INSRP100                                   WHERE SHListNo = ALL                                           ( SELECT SHListNo FROM DVMURRAY/INSRP100 Left Outer Join  DVMURRAY/INSRP200                                                       on SHListNo = SDListNo                                       WHERE SDListNo is Null                                )                                                       Row not found for DELETE.                             [...]

Answer Question   |  November 24, 2010  5:31 PM
iSeries SQL, iseries v5r4, RPGSQL, SQL, V5R4

Giving in Date Range in Crystal Reports 8.5
I am trying in Crystal 8.5 to get records for those who did not donate in a given date range, but did give in a different date range (i.e. did not donate 5/1/1985 thru 4/30/2009, but did donate 5/1/2009-4/30/2010). Those who meet the criteria are then marked as “new donor”. I am getting too many [...]

Answer Question   |  November 24, 2010  4:36 PM
Crystal 8.5, Crystal Reports 8.5, Date format, iMIS

Upcoming Live Expert Chat on Monday 11/30
Don’t forget that Monday is the Alcatel Lucent Live Expert Chat at 10am EDT. Transitioning to LTE: Business and Technical Considerations will help you consider what needs to be done as you create and implement a highly adaptive business model with customer-focused strategic planning, service mapping, cost modeling and technical assessment services. Don’t forget to [...]

Answer Question   |  November 24, 2010  3:43 PM
Live Chat, Networking, Telecom 4G LTE, VoIP

RPG /Free Local Data Area definitions
I am trying to define the LDA with an external definition in RPG /free. Any help?

Answer Question   |  December 1, 2010  3:11 PM
ILE RPG, iSeries, RPGLE, V5R4

reformatting a multi-tab spreadsheet and access 2003
Hi,    I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access [...]

Answer Question   |  December 1, 2010  2:41 PM
Access 2003, Excel 2003, Excel worksheets, Record Format Level Identifier

T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)
Hell Kent, I read through “V5R4 SQL Packs a Punch” http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf    I would need the query in figure 20 and the result in figure 21 which do not show up in the article.  I have a query similar to the example (parts of an iSeries Power5 server) that shows all the levels correctly, however, [...]

Answer Question   |  November 29, 2010  1:36 PM
Recursion, SQL Query, T-SQL, V5R4

Exchange 5.5 receiving Exchange 2007 meeting requests
How to setup exchange 5.5 to receive meeting requests from exchange 2007?

Answer Question   |  November 24, 2010  12:03 PM
Exchange 2007, Exchange 5.5, Exchange interoperability, Exchange Meetings