RUNSQLSTM ALTER TABLE
i’m trying to run SQl statment in batch job to alter Table CCSID to 420 but i have error Reason code 10  Hani 

Answer Question   |  February 27, 2012  10:51 AM
AS/400 V5R3M0, SQL tables, SQL/400

Reading xml url into SQL Server 2008 Table with OpenXML
I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url [...]

Answer Question   |  June 28, 2011  5:21 PM
SQL Server, SQL Server 2008, SQL Server tables, SQL tables, XML, XML development

Problem Querying SQL table from PHP
I recently added a new table to an existing database. Data is entered into the db via a web front end, using PHP 5. I am not a php developer. Our developer is trying to build a search query against the new table (there is data in the table). From the page he is working [...]

Answer Question   |  June 20, 2011  2:50 PM
PHP, SQL 2008, SQL Server 2008, SQL tables

SQL statement needed to remove characters
I have data in one of my columns in a table that I would like to remove via a SQL update statement.  In all cases, the data that I want to remove is the same 3 characters at the end of the varchar field.   How would I structure the SQL statement?

Answer Question   |  May 2, 2011  2:34 AM
SQL Server, SQL Server 2008, SQL statement, SQL tables

Can two separate cursors update the same SQL table when executed together?
I have three tables. Table One is a master table which contains rows which need to be updated with data from the other two tables (I’ll call them Table Two and Table Three). I have created a cursor which updates existing rows in Table One with data from Table Two. This works fine, and following [...]

Answer Question   |  March 23, 2011  10:57 AM
SQL Cursors, SQL Server 2005, SQL Server 2005 administration, SQL tables

Update a subquery with different tables
I am trying to update a table and use a subquery for the argument. I think I have both queries correct but since but since they are from two tables I am not tying together correctly. Can you tell me what I need to do? update MVXJDTA.MITMAS set MMSTAT =’01′ where MVXJDTA.MITMAS.MMITNO = MVXJDTA.MITSTA.MHITNO (Select [...]

Answer Question   |  February 18, 2011  8:04 PM
SQL Query, SQL tables, Subquery

SQL Server 2008 tables
I  have 2 tables, tanle1 and table2 Can someone help for  SQL query  for table3 with 2 colums colum 1  is select number from table1 for colum2 in table3  I need to get the total number of times  each number in colum1 of table1 apears in in colums n1,n2,n3,n4 of all events in table2 as [...]

Answer Question   |  January 31, 2011  1:51 PM
SQL 2008, SQL Query, SQL Server, SQL Server 2008, SQL tables

SQL command question
I have three tables as below: Table 1: attributes fields: attID, att_CategoryID, name Table 2: att_Category fields: att_CategoryID, name Table 3: prodcutAttributes fields: ID, productID, attID, I desigining this tables to be able to add multiple prodcut attributes for ecommerce site. I don’t know how good this design is. Anyways I need to find out [...]

Answer Question   |  January 27, 2011  4:20 PM
SQL commands, SQL Server, SQL Server tables, SQL tables

Access or SQL Server tables
Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more separate tables on the [...]

Answer Question   |  December 16, 2010  4:02 PM
Access Tables, SQL Server administration, SQL Server Table Migration, SQL Server tables, SQL tables

Question on SQL 2005 table
tablename:-software pname             packagename                    cost MARY               README                             1200 ANAND             PARACHUTES                     6000 ANAND             VIDEO TITLING                   16000 JULIANA           INVENTORY                        3500 KAMALA           PAYROLL PKG                    20000 MARY                FINANCIAL ACCT             85000 MARY               CODE GENERATOR          20000 PATTRICK        README                            1200 QADIR               BOMBS AWAY                 3000 QADIR               VACCINES                      3100 RAMESH             HOTEL MGMT                35000 RAMESH               DEAD LEE                    4500 REMITHA              PC UTILITIES                5000 REMITHA               TSR HELP PKG             6000 REVATHI             [...]

Answer Question   |  December 11, 2010  8:39 PM
SQL 2005, SQL Server 2005, SQL Server tables, SQL tables

Delete all tables in SQL Server database?
How to delete all tables of a database in SQL Server?

Answer Question   |  November 16, 2010  8:28 AM
DELETE statement, SQL Database, SQL Server, SQL Server database, SQL tables

Error Message ORA-00903 in SQL table
Here is my query:   select guestid, guestfname, guestlname from guest where tourid = 6; It says tourid is an invalid identifier. TourID is a defined attribute in a table called Tour. I’d be grateful for any help.

Answer Question   |  November 15, 2010  11:53 PM
ORA-00903, SQL, SQL Plus, SQL tables

How to update data for one column in MS SQL?
Hi, I have a table column named “Question” that stores the question without space.For example “Who are you” is stored as “whoareyou”.Now I have modified the code to store the data with spaces in Question column.Problem is newly added data will be stored with space,but I want to change the already existing thousands of records [...]

Answer Question   |  November 16, 2010  3:50 AM
SQL, SQL Database, SQL Server, SQL tables

Copy Table in SQLPLUS
How to copy a table from an access database using sqlplus

Answer Question   |  November 8, 2010  2:18 AM
Access, Access Database, SQL tables, SQLPlus

PL/SQL Query
Create table other_sess( s_name varchar2(10)); insert into other_sess values(‘s2007′); insert into other_sess values(‘s2009′); insert into other_sess values(‘s2009′); commit; now i want to write a PL to retrive data from these sessions (s2007, s2008, s2009). from my current session. declare mold_session varchar2(10); cursor c1 is select s_name from other_sess order by s_name; begin open C1; loop [...]

Answer Question   |  October 25, 2010  5:31 AM
PL/SQL, PL/SQL Multiple Session, SQL Query, SQL tables

How to update one table field with the help of more than one table in SQL Server 2000
How to Update one table field with the help of more than one table

Answer Question   |  October 4, 2010  10:25 AM
SQL Server 2000, SQL Server tables, SQL Server Updates, SQL tables

Without Using Script in SSIS
HI!!! how do I alter data in SQL Server table [select, insert and delete] using SSIS Visual Studio without using a T-SQL Script… please help me T_T…. Thx so much…

Answer Question   |  September 27, 2010  2:05 AM
Scripting, SQL Server tables, SQL tables, SSIS, Visual Studio 2005

How do I use primary keys in SQL server?
I have a table called course,and course_id is primary key in this table. I created another table subject.I mapped these 2 tables by course_id as foreign key,I  created another table teacher,i want to map this with subject, only subject_id to teacher_id mapping is required,how i mapp this,can i use course_id?  

Answer Question   |  September 9, 2010  7:03 AM
Primary keys, SQL, SQL Server, SQL tables

Crystal Reports XI – SQL table fields that fail all compare tests
I have an SQL table with a field that Crystal XI displays as string 300, call it mytable.mystring. If I create a formula field (myformula) such as… if {mytable.mystring} = “test value” then 1 else 2 This is what happens during execution…  when the the preceding test is true, Crystal returns a value of 1 [...]

Answer Question   |  August 26, 2010  3:15 PM
Crystal Reports XI, Crystal XI, SQL, SQL Server, SQL tables, Windows Server

Joining 3 tables in SQL Server 2005
Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.

Answer Question   |  August 12, 2010  12:37 PM
SQL Query, SQL query optimization, SQL Server, SQL Server 2005, SQL Server Query, SQL tables