Recent content by thorny00

Hi Simi, Yes, I am using SSIS to move the data. I'm using a date to pull the records - i.e. DOS between 2018-08-01 and 2018-08-31 The ID won't work great. I may be using this process over. Thanks! Bob

I have been tasked with extracting data from an outside SQL server. The problem is that I am hitting their "live" database. They only want me to pull 15k records at a time. The connection is set up and working fine. I want to use a date, i.e. service_date to pull the records, WHERE...

Here is the worst part- the data is coming from a view which is gigantic to say the least. So, the view does NOT have an index on it.

Thanks in advance for all of your time and help. It is greatly appreciated!! First, I need to find the record where - METRIC_INTERNAL_NAME = 'LOGIN' AND DATA_MNEMONIC_ID = 'DEP' Then collect all records until METRIC_INTERNAL_NAME = 'LOGOUT' AND DATA_MNEMONIC_ID = 'TIMEOUT' then loop...

Yes, I am updating the table based on the cursor results. I looked and only some of the fields being used in the cursor are indexed. Would indexing all of the fields in the cursor increase performance?

We have a cursor to check for reversal claims. The main table being used has 50 fields but only 7 fields are being used in the cursor. Would it increase speed of the cursor to create a "Working" table based on only those fields being used by the cursor? Thanks for your time and help.

How many records are you talking? Are the dashes in the data? Could a CSV file be created then loaded into SQL?

Thank you in advance for your time and help and sorry if this has been posted before. I have one table - tbl_Members with 2 fields that need to be updated. The c_MemberID field is coming from RAW_Data. Is this even possible to do? UPDATE tbl_Members SET OLD_MemberId = MemberID, MemberID =...

Very green to SSIS so please bear with me. Trying to set up a package to automate ETL. All of the processes happen on one server. Using VS 2008. 1) check to see if database exists - if it does, load file(s) into a specific table in that database. 2) if the database does not exist, have some...

Sorry bborissov that is not what I need. The example I gave is just one record out of thousands. I need to look at each members memberid in tbl_Claims and see if there dateofservice falls between a gap of their records in tbl_Elig. A member can go out and in eligibility several times.

For simplicity, I have a table – Claims that has memberid and dateof service. My other table – Elig has membered, mineffectivedate and maxeffectivedate. Now a member could have several records in the Elig table. I need to find records where the dateof service is not between any of the Elig...

PHV, yes I was given "A Step-By-Step Approach" book written by Cathy Kipp. I am brand new to Informix and was looking for something that would show me the command in Microsoft SQL and its equivalent in Informix. Example - Microsoft - Length Informix - Len top 10...

I am very familiar with Microsoft 2005 SQL. Now I need to learn Informix. Does anyone know of a "cheat sheet" that shows the microsoft 2005 sql equivalents to informix commands? Thanks in advance for your help and time, it is greatly appreciated.

Using CR v10 I have tables that have the same fields in them that are being used in the report. What I’d like to do is set up a parameter field where when a client is choosen, it points the report to that clients table. Example: Client Table Abc Abc.elig Xyz Xyz.elig Would this be...

I have the following that gives me all the tables that with FOO in the table name. Now I want to list each table that has FOO in the table name and the count of records in each of those tables. I.E. TableName Count FOO1 1000 FOO2 50,000 FOO3 100,000 F004 90...