Does anyone know if it is possible to backup a database on a SQL Server 2012 Enterprise Edition and restore it to a SQL Server 2012 Business Intelligence Edition using SQL Server Management Studio? I would like to go the other way as well.
Answer Question | May 23, 2013 10:05 PM
backup database, Business Intelligence, Enterprise, Restore Database, SQL Server 2012
Hi! I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in Application DB, in DataMart I will have only [...]
Answer Question | May 22, 2013 10:06 AM
Application acceleration, Archive, Database, Database archiving, ETL, ILM
How would you write the “Where” clause (sql) for abstracting just the “Year” out of a startdate like 03/12/2013 which would result in an answer of “2013″?
Answer Question | May 21, 2013 2:29 PM
Database Management Systems
Hi Members, I am new to this community.I have done BTech in computer science in 2012 and currently working on Visual Studio 2010 C# Asp.net SQL Server 2010.My interest is in artificial intelligence,Data mining and warehousing,algorithms,pattern Recognition etc.So I choose to make startup in BI and ready to take challenges. So kindly guide, that from [...]
Answer Question | May 20, 2013 6:32 AM
Hello, My company currently has 2 ERP systems: JDE (in Oracle) and another which has 3 of our divisions. The decision has been made to move the remaining 3 divisions to JDE. The other divisions currently push pricing to the 2nd ERP system from home grown Contract Systems on the System i nightly (recently upgraded [...]
Answer Question | May 16, 2013 1:02 PM
DB2, ERP system, JDE, Oracle
Guys, we got a problem here…our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?
Answer Question | May 14, 2013 4:24 AM
AS/400, CLLE, DB2, RPGLE
How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?
Answer Question | May 14, 2013 4:03 AM
AS/400, DB2, RPGLE
Recently, I learned QR Code barcode generation in Java here, could anyone tell me how to generate QR Code barcode in other platforms, like ASP.NET, NET WinForms?
Answer Question | May 10, 2013 11:50 AM
ASP.NET, Barcode, Java
David Loshin has outlined his five steps to an improved data quality assurance plan. Do his five steps cover everything needed? What would be your five (or more) steps?
Answer Question | May 17, 2013 1:19 PM
Data quality, improve, Quality assurance
State the salient differences between data query and knowledge query?
Answer Question | May 1, 2013 10:44 AM
Data Mining, Data warehouse
I’m a newbie to Sequel and I’m trying to recreate some old Crystal Reports using Sequel. My question is: how does the IF, Else statement work in Sequel? This is the statement for Crystal, for a Termination report, we have six companies and if an employee transfers to one of our other companies, we need [...]
Answer Question | April 30, 2013 2:40 PM
AS/400, Crystal Reports
Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as ‘%’ and if Numeric default till the length of the field with -9999. As per now I’m getting two options. 1. Create the [...]
Answer Question | April 26, 2013 4:53 PM
AS/400, DB2, RPG, RPGILE
Hi, I’m using Crystal Reports 9 version and in the database expert, it is not displaying all the schemas of the DB2 database connected. Only fewer are displayed. I’m unable to query it even after I have verified all the options such as tables, views etc in the “Options”. But none of them have worked. [...]
Answer Question | April 22, 2013 2:58 PM
Crystal Reports 9, DB2 server
I have three date fields; approved, countered and denied. I need to have one date field called Decision date. The formula needs to account for the null values and also needs to return the most recent date out of all three of the fields. I know how to do this with two dates but haven’t [...]
Answer Question | April 22, 2013 10:10 PM
Crystal Reports formulas, Crystal Reports XI
I want to know the different types of data, their description and applications.
Answer Question | April 19, 2013 8:59 PM
Data, Data analysis
The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than [...]
Answer Question | April 18, 2013 1:50 PM
DB2, SQL statement
Hello, My name is Aaron and I am a UAT student. A good security hygiene practice is to protect sensitive data, and also protect stored data and encrypt transmissions of sensitive data across open, public networks. It’s good to protect this data both in transit and when it’s at rest. Having protected sensitive data will [...]
Answer Question | April 14, 2013 10:52 AM
Data, Protect, UAT
Is it possible to occasionally run a report based on color coded activity types (such as client meetings, phone calls, etc.)
Answer Question | April 12, 2013 2:42 PM
I use an application which generates Crystal Reports. This application currently uses Crystal Reports 8.5 when I tried to migrate the Crystal Reports to 11.5 and tried generating reports, an error is thrown which says”failed to load database information”.
Answer Question | April 5, 2013 11:46 AM
Crystal Reports 11.5, Crystal Reports 8.5
Greetings, our company owns a string of distribution centers that use optio formatting for labels and packing slips. We have noticed lately a label print job that randomly occurs at different centers and different times of the day. This seems to be a bug of some sort that will just spool rolls and rolls of [...]
Answer Question | April 4, 2013 2:41 PM
Optio, Optio Software