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

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

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

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

IN and Exists in SQL?
What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.

Answer Question   |  November 26, 2010  7:18 AM
Oracle 10g Express, Oracle SQL, SQL, SQL commands, SQL Server

Microsoft SQL Server BCP Utility password
I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the ‘in’ argument, a format file and an error file.  I have ‘hard coded’ the user name and password in the command line using the ‘U’ and ‘P’ arguments. I am looking for a [...]

Answer Question   |  November 23, 2010  7:42 PM
BCP Utility, BCP Utility password, SQL Jobs, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server Enterprise Edition

Union operator in SQL server 2000
How to give where condition to the result of the query using Union operator?

Answer Question   |  November 23, 2010  7:27 AM
SQL Query, SQL Server, SQL Server 2000, SQL Server Query

SSRS Report Export to Excel
When exported to Excel, some data is hidden from view by the row heigth. Rows must be expanded to view. Please suggest me a nice solution so that if the data is more than the single line, it has to expand the row height.

Answer Question   |  November 22, 2010  7:14 AM
excel, SQL Server, SQL Server Reporting Services, SSRS, SSRS 2005

How to write text into word doc using SQL 2000 query analyzer
how to write text into word doc using sql 2000 query analyzer. Thanks in advance.

Answer Question   |  November 19, 2010  7:02 AM
SQL 2000, SQL Query, SQL Query Analyzer, SQL Server 2000, SQL Server 2000 queries

SQL Server 2005 License
This question is not about doing something illegal toward the SQL Server Licensing; on the other hand it is about knowing relationship between Licensing and hardware. Question: I have SQL Server 2005 licensed for 2 physical CPUs. Recently, I bought a system with 4 CPUs to replace the old machine. I know that I must [...]

Answer Question   |  November 20, 2010  8:55 PM
CAL, CPU, SQL 2005, SQL Server 2005 License, SQL Server licensing, Windows Server 2003

Tomorrow at 4PM ET: ITKE Rolls Out New Badge System
Badges are almost here and we could use your help. Friday at 4pm ET, we will be launching the new badge system so we need you to stay vigilant and let us know if you notice anything odd with your badges, your profile, or the site. Be aware that [strong]we are planning to experience some [...]

Answer Question   |  May 26, 2011  6:55 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server 2003

Can I direct query the Oracle database with SQL Plus?
I am about to start work on a SAP system which has an underlying Oracle(version 10) database. I would like to know if it straightforward to query the Oracle database directly iusing SQL*Plus for example ?

Answer Question   |  November 18, 2010  8:23 AM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix

null v/s ” “(empty string) in Java
what is the difference between null string and emty string(” ” ) in java? String name; if(name == null || name == “”) { } wat is the meaning of the abouve if statement?

Answer Question   |  November 22, 2010  5:11 AM
Java, Java code, Java developers, NULL, String name

Copy BLOB to BLOB using TSQL
Is there a way I can copy a BLOB from one column to another using TSQL ?

Answer Question   |  November 19, 2010  1:37 AM
BLOB, BLOB TSQL, SQL Server 2008, SQL Server 2008 R2

Is it safe to delete SQL Server Transaction Log?
In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but [...]

Answer Question   |  November 18, 2010  11:59 PM
Delete Transaction Log, SQL 2005, SQL Server 2005, SQL Server logs, SQL Server transaction logs, SQL transaction logs, Windows Server 2003

Check IF Field is Numeric in AS/400 SQL
is there a function to check if field is numeric (like ISNUMERIC in standard SQL)?

Answer Question   |  March 12, 2011  11:04 PM
AS/400 numeric fields, AS/400 SQL, SQL, SQL Server

Help running a CmdEXEC from the SQL Server
I am trying to run a CmdEXEC from the SQL Server- script c:userspublicdocuments The process could not be created for step 1 of job 0xAA781DCB64C4D84392B6730923A77C3D (reason: The system cannot find the file specified). The step failed any help?

Answer Question   |  November 17, 2010  6:36 PM
CMD, SQL Server, VB script, Visual Basic Script

How to write text into textfile using SQL 2000
can I use exec sp_OAMethod ‘c:osqloutput.txt’, ‘WriteLine’, Null, ‘hello’ to write something on file using sql2000

Answer Question   |  November 16, 2010  11:54 AM
SQL, SQL 2000, SQL Server 2000, textfile

What is a good book for SQL?
which is the Good book for SQL?

Answer Question   |  December 5, 2010  4:52 AM
IT Books, Oracle, Oracle Books, SQL, SQL Server