• How to get rid of blank areas

    I have a database that contains path diagnoses (rows) and stains (columns) used to determine diagnoses. Therefore for any single entry there may be multiple empty columns. When I make a pivot table I want to be able to show only columns with data in them.

    mensamedic5 pointsBadges:
  • Loading flat file into a database table with SSIS

    Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process: Get file from local or FTP Delete the old file which doesn't exist anymore in the database Insert only new records in the database Automated Don't overheat SQL...

    ITKE355,460 pointsBadges:
  • SSIS on SQL Server 2012

    We're in the middle of upgrading from SQL Server 2005 to SQL Server 2012. However, there's a good amount of SSIS running on this server. Can we re-deploy these packages on the new SQL instance? Will we have to go through Visual Studio upgrade for each? Thanks!

    ITKE355,460 pointsBadges:
  • Security for SQL Server 2012 SSAS

    So I just installed an instance with SSAS only. Now, I'm curious how security (login) will be maintained. I've created one instance with engine and SSAS (Dimensional) and another instance with just SSAS (Tabular).

    ITKE355,460 pointsBadges:
  • MySQL syntax

    Hi, Have a table budget When I try this: MySQL: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a course no from table course 2 also represents: a course no from table course. It doesn't work. Any suggestions?

    Ak1bo78150 pointsBadges:
  • Data area

    I was used Data structure in my program. I have declared all the possible values but it shows an error. 1. In or out operations not valid for DS 2. Define is not valid So please give some sample code:

    Pansel5 pointsBadges:
  • How to fit a lot of text into a cell in Excel 2007?

    Is there a way to add a large amount of text into a cell in Excel 2007? I need to add 1,941 words (10,460 characters) into a single cell in Excel. The cell is set to the maximums of 255 column width and a row height of 409.5, but I still can’t place all of the text within the cell – this with...

    ITKE355,460 pointsBadges:
  • How to retrieve, add and update data manually using VB.NET 2005

    Hey guys! I'm quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I'm trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is...

    Obhasha0795 pointsBadges:
  • New Member contest: Win a free iPad

    Click here for all the details. Good luck to everyone.

    ITKE355,460 pointsBadges:
  • convert oracle reports to excel

    How do i corvert oracle reports to excel

    DDPORACLECORV5 pointsBadges:
  • New Contest: You Could Win a New Xbox 360

    Now is the time to ask and answer questions on ITKnowledgeExchange.com because you could take home a newly released Xbox 360. From today (June 16th) through July 30th, you have a chance to win 1 of 2 Xbox 360s or 1 of 3 $50 Amazon Gift Cards. The five community members who have the most Knowledge...

    ITKE355,460 pointsBadges:
  • Retain leading zeroes with CPYTOIMPF

    I am copying a PF from the iSeries (V5R3M0) using Cpytoimpf, within the file is an alpha field with leading zeros. When the file is opened in Excel it drops the leading zeros. Assuming it is a numeric field, is there any way to retain the leading zeros?

    AmandaC30 pointsBadges:
  • iCloud data transfer

    How do I transfer music from one iCloud account to another iCloud account?

    dej5 pointsBadges:
  • Difference between DDL and DDS

    What is the difference between DDL and DDS. How to use DDL in AS/400

    rajeshece1,215 pointsBadges:
  • Viewing index data in DDL

    I have created index. It shows Type as *FILE and Attribute as LF. but I'm unable to view the data. How do I view index's data?

    rajeshece1,215 pointsBadges:
  • Seperation of AD and Exchange Organisation

    I am currently working on a project where a company is seperating one of its entities out from all others. Their current structure is all in 1 AD forest and 1 Exchange Organisation. We need to build a whole new forest and Exchange Organisation for this entity. We dont have a problem with creating...

    SssJapp0 pointsBadges:
  • Data Conversion on IBM AS/400

    Hi, We're converting some old master files in to new format files. These master files have around 58 million records each. We wrote COBOL programs to convert the format and write to the new files. In order to speed up the process we are splitting the each master file into 20 parts(i.e., 20 files...

    DataConversion0 pointsBadges:
  • Is collecting social media data the CIOs’ responsibility?

    In SearchCIO's recent social engagement-themed tweet jam, one idea was clear: Incorporating social tools into regular business practices is increasingly vital to organizational success. But left unclear were the CIO's responsibilities for collecting data -- not to mention identifying, analyzing and...

    Chris Leonard4,300 pointsBadges:
  • Do you think you have the right analytics?

    Is your company working on any big data projects? How much confidence do you have that you have the right analytics to derive value from it? How happy are you with the analytics knowledge in your organization?

    Ben Rubenstein9,050 pointsBadges:
  • Monitor Internet bandwidth

    Good day, We are using Windows 2000 Small Business Server in our organization with Exchange, DNS and ISA server configured. 1. I want to monitor the internet usage by the users. 2. I want to take a report on monthly or daily basis how much MB/GB utilized by each user. Thanks for your reply in...

    GiriPrasad0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following