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
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
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
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
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
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
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
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
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
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 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
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
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
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
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 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
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
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
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
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