Search results for query: *

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

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

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.

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

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

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

I have the following query, but I need to change the bathcid's each week. Is there a way to select the MAX batchid and the MAX batchid minus 1? select distinct pin from IN_Carolina_834Elig where convert (datetime,dob) = convert(datetime, '<<bthdat>>') and SSN = '<<Calc_MemberID>>' and...

The e.calc_mostrecenthiredate is stored as a varchar. I have the following as part as my Where statement: IsNull(convert(datetime,e.calc_mostrecenthiredate,1),'') >= '12/1/2005 00:00:01' but get the following error: Syntax error converting datetime from character string. Warning: Null value is...

I would like to create a random 6 character field that contains but numeric and alpha characters. How can this be done? i.e. 2TRE3GFH Thanks!

Using CR 10.0 Want to show the week to date from Sun function in my report header. Below is what I have but it isn't working. Any ideas "Hours worked for" & " " & GroupName ({tblProjectsLog.User}) & " Period of" & totext(WeekToDateFromSun) Would like it to show: Hours worked for Joe Smith...

Using CR 10.0 Have the following formula. The hmsend field can have nulls in it. How do I account for the nulls in the formula? {tblBatchMaster.RecCnt}/datediff("s",{tblBatchLog.HMSStart},{tblBatchLog.HMSEnd}) Thanks in advance for you time and help, I really appreciate it!

Using SQL2000 I was running an update with a Tran Rollback in Query Analyzer. Someone cancelled the run and now when I try to close QA, I get the following: There are uncommited transactions Do you wish to commit these transaction before closing the window? Options are Yes No Cancel What's...

Using SQL2000. I can not for the life of me figure out why the first query won't work properly, but the second does. Can someone please explain?? Thanks in advance!! This query that drops 10 recs when you add the left outer join: SELECT dbo.tblProgram.CliProdID, dbo.tblProgram.PIN...

Have a field - enddate that's a varchar and looks like 08122005. There are also blanks in the enddate field. I need to get only those records where enddate < getdate, I do not want the blanks either in my results. How is this done? Thanks in advance for your time and help!

I'm new to creating stored procedure and in need of help. I have the following code so far, but, need additional data. In the FILE HEADER RECORD, I need to count the number of detail records and put it in the place of the 9 zeros. I then need to create a trailer record that would count the...

Have SSN and StartDate fields. I need to pull only the 4th record when the count of records per SSN >= 4. Example: SSN StartDate 123456789 7/1/05 7/2/05 7/3/05 7/4/05 7/5/05 I only want to show the 7/4/05. Some SSN's have...

Using CR v.10 Have SSN and StartDate fields. I need to pull only the 4th record when the count of records per SSN > 4. I group on SSN, then set up a formula FOO- count({StartDate}, {SSN}) then in the Select Expert I made FOO > 4 Example: SSN StartDate 123456789 7/1/05...