Passing an array parameter from crystal reports to a sql stored procedure
Hi All, I am having a problem in Crystal Reports with an array parameter. The user can select one warehouse code or multiple warehouse codes. I just need to display the detail from each warehouse selected (one, multiple or ALL). Right now I’m getting duplicates. I’m not sure how to set this up in SQL [...]

Answer Question   |  February 22, 2011  10:56 PM
Array Parameters, Crystal Reports, Crystal Reports 10, SQL, SQL Server

SQL concatenate results
Hi Need help here:-  I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS, FDDWHD20.DCOTD1, FDDWHD20.DCOTD2, FDDWHD20.DCOTD3, FDDWHD20.DCOUT3, FDDWHD20.DCOUT2, [...]

Answer Question   |  February 23, 2011  11:31 AM
Concatenate, SQL, SQL Server

Would like to learn SQL. Which vendor should I go for and what certification should I get?
Hi All, I would like to learn SQL but was wondering shich SQL package should I go for? I am looking for emplyment in the finance industry as an analyst and thus looking for the right SQL package to learn and get the right certification. Could somone please advise me accordingly. cheers! Jeevan

Answer Question   |  February 14, 2011  2:29 AM
SQL, SQL certifications, SQL Server, SQL Server certifications

CPF8361 Error after V6R1 Upgrade
After upgrading from V5R4 to V6R1 we have begun to encounter CPF8361 errors related to Committment Control running embeded SQL.    Transactions get hung up in RDB and then processes get stuck.   Is this specifically related to the upgrade and is there a simple process to correct the issue. 

Answer Question   |  March 1, 2011  4:58 PM
iSeries Upgrades, RPG, SQL, V6R1

un-format object viewer sql tab
Hi experts, Can someone tell me, how can I turn off automatic code formating on the Object viewer’s SQL tab (i.e. the sql code in the SQL tab of an opened view is automatically formated compared to the code I used to create it) Thnx in advance for yr answers

Answer Question   |  February 11, 2011  8:13 AM
Oracle SQL, Oracle SQL Developer, SQL, SQL Server

Oracle opportunities
I completed my B.E in 2009, so I want interested to go to oracle side, so I know the concept of sql and pl/sql. Relating to this I dont have a project of this. So please give me some titles of project atleast I can go through this.. regard@sadashiv

Answer Question   |  January 28, 2011  5:25 AM
Oracle, Oracle PL/SQL, Oracle projects, SQL

VIEW_TABLE_USAGE SQL 2005
In MS SQL 2005, when I select * from VIEW_TABLE_USAGE, I get incomplete results. At least one object that is used in at least one of the views is not listed. View “PTP__MARA_MARC” uses two tables and one view, but VIEW_TABLE_USAGE only lists one table and one view.  Can you please help?

Answer Question   |  January 26, 2011  2:53 PM
SQL, SQL 2005, VIEW_TABLE_USAGE

SQL and Dates
Can someone date a look at this SQL and recommend a cleaner way to go about this? [BMDTOR is a date field in the file stored as CCYYMMDD] SELECT (DAYS(CURRENT DATE)-DAYS(SUBSTR(BMDTOR,5,2)||’/'||SUBSTR(BMDTOR,7,2)||’/'||SUBSTR(BMDTOR,3,2)))/30 AGE, SUBSTR(BMDTOR,5,2)||’/'||SUBSTR(BMDTOR,7,2)||’/'||SUBSTR(BMDTOR,3,2), (CURRENT DATE) FROM XXXXDATA/FILEXX

Answer Question   |  January 25, 2011  5:31 PM
SQL, SQL Query, SQL Server

Recursive Association with compound primary key in SQL database
Hello, I’m afraid I’m very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a ‘Lead Client’ column to represent a recursive relationship where one attendee can be nominated to lead others attending [...]

Answer Question   |  January 3, 2011  11:53 PM
Database issues, Design principles, SQL, SQL Database, SQL Server database, SQL Server errors

SQL Server Plan Cache
There is a bucket in plan cache with 75 objects in it and it is the same sql statement. Other than using DBCC FREEPROCCACHE what will clear out the cache? Restarting SQL SERVER Service? I use the code below to look up how many plans are in a bucket. SELECT   bucketid,   entries_in_bucket = [...]

Answer Question   |  December 29, 2010  11:30 PM
Cache, Cache Mode, SQL, SQL 2005, SQL performance, SQL Server

Is it possible on iSeries that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used.
Is it possible on i series that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used. We had an issue wherein an entire library had to be cleared and all files from had to be restored from a previous backup, after the [...]

Answer Question   |  December 24, 2010  9:45 AM
Index Performance, iSeries, SQL, SQL Select, V5R4

Letting users upload pictures MYSQL Database
What is the easiest way in DW to allow users to upload a picture to my website. I don’t know much coding so …how can it be done using the functionality of DW. I am using a MYSQL database.

Answer Question   |  January 17, 2012  3:30 PM
MySQL, MySQL Database, SQL

When using IfNull in my SQL, records are ignored
I know my data table has nulls in it. If my select statement doesn’t include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here’s my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,’ ‘) C+ [...]

Answer Question   |  December 24, 2010  12:10 AM
AS/400, AS/400 Records, Data Tables, RPG, SQL

Two SQL server synchronization
How can I merge two SQL Server databases? One sql server is in web  and another in local machine  both sql servers will have daily data transactions entries. how to merge those daily data transactions between the two sql server?  i am new to sql synchronization and merging. could you kind enough to help me?

Answer Question   |  December 20, 2010  3:14 PM
.NET, SQL, SQL Server, SQL Server synchronization, VB.NET

Value of() in SQL Server?
what is the equivalent statement of valueof() of oracle in sql server?

Answer Question   |  December 16, 2010  12:22 PM
Oracle Statements, SQL, SQL Server, SQL Server 2005

How do I retrieve data from Visual Basic 6.0 with SQL?
how can i rertieve data in vb6.0 from sql?

Answer Question   |  December 13, 2010  4:58 AM
Retrieve Data Area, SQL, SQL Server, VB 6.0, Visual Basic 6.0

Using a variable in the LABEL ON SQL statement
Is it possible to use a variable in the label-string of the LABEL ON sql statement so that the variable can be changed dynamically in an SQLRPGLE program ?

Answer Question   |  December 14, 2010  7:26 PM
AS/400 SQL, RPGLE, SQL, SQL Server

Find missing numbers with SQL
In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

Answer Question   |  December 14, 2010  2:35 PM
AS/400 SQL, SQL, SQL Server, V6R1

Crystal Reports 8.5 compatibility with SQL 2005
Is crystal 8.5 compatible with SQL Server 2005?

Answer Question   |  December 10, 2010  4:45 PM
Crystal Reports 8.5, SQL, SQL Server, SQL Server 2005

Create trigger using iSeries Navigator
I am trying to ceate a simple trigger to a table to update a history file with the old rate when the rate changes in the master table. I have gone as far as creating the sql statement, but I am not able to make it to work (my sql is very limitted). Would it [...]

Answer Question   |  December 2, 2010  2:28 AM
AS/400 triggers, iSeries Navigator, SQL, Triggers