Search results for query: *

Dear Experts, I am trying to create a column with values through the SELECT statement just adding 21 days: SELECT DISTINCT cde_proc, i.cde_proc_mod, i.num_pa_line_item , i.dte_received stat.dsc_pa_status, i.qty_unt_svc_ath...

Hi Experts, I have to answer certain questions for my VPN Access Request. I am supposed to work from home once in a while using my own PC laptop. One of the question is about Microsoft Patches up to date. How would I know if I do have Patches on my home PC? Could you please tell me how can I...

...then elig.DTE_END=to_date('30JUN2018'); num_days_elig2 = datdif(datepart(dte_effective), datepart(dte_end), 'ACT/ACT') + 1; run; --This is what I am trying to do in SQL CREATE TABLE mytable as SELECT DISTINCT Field 1. Field2, /*case conditions*/ /*calc line*/ FROM have quit;

carp, I tried to do it but get an error ORA-00932: inconsistent datatypes: expected NUMBER got DATE Actually for SYSDATE it is for sure ( 5/7/2018 10:49:07 AM) . As for dte_received it looks like a string 20171213. I tried to convert but failed. This is my problem as I am new in Oracle...

Dear Experts, I want to set the condition where dte_received is between today date and the date 12 months ago.So far I tried the following statement: WHERE dte_received between (sysdate,-12) and sysdate; (at which System generated an error message) I run the following: SELECT SYSDATE FROM...

Sorry, I meant being in Access I imported source file into a table in the current database. Now I tried another option. I link the data source by creating a linked table. There were no error anymore . Now the table looks OK. In this case I am not sure, howeve,r if I would be able to manipulate...

Then I imported the file from MS ACCESS 2010. It was not imported successfully. About 35,000 records were truncated .

I was sent .csv and tried to open it with Excel. System message said, “.csv may contain features that are not compatible with csv(comma delimited). Do you want to keep the work book in this format? -to keep this format which leaves out any incompatible features, click Yes -To preserve the...

SkipVought, Thanks for the prompt response. I have just look at the file which is huge in Excel and used Find and select option to find comma if any. It was not found.... Estersita

Dear Experts, Being in a process of importing Microsoft Excel Comma Separated Values File (.csv)file into MS ACCESS 2010 table I face an obstacle because a certain field was truncated. Then I have configured the table with field Memo type instead of text 255 barrier. However, try as I might...

I am trying to understand the folowing piece of code: data long (keep=icd9 icd10); set cwalk_wide; array _in(*) $ icd10:; i=1; do while (i le dim(_in)); if not missing(_in{i}) then do; icd10=_in(i); output; i+1; end; else i=dim(_in)+1; end; run; Could...

Klaz, Does it mean that I could eliminate the NOT LOGGED INITIALLY statement and et it just slower ? execute( create table &TmpSchema..G (ID CHAR(30) ,tag char (3) ,Mydate date ) in "&twotblspc" )by Mconnect; Thank you! Estersita

...a following statement from somebody code as I do not understand the syntax (never worked with SAS before): proc sql; connect to odbc as ...; * Transient table is created and loaded execute( create table &TmpSchema..G (ID CHAR(30) ,tag char (3) ,Mydate date ) in...

I included both source.id and medclm.id fields into my query and they are all equal. It looks like that happened because there are a lot of duplicate IDs in the bigger table MEDclm which ALL match SOURCE.ID! So, in order to add a couple of fields from MEDCLM one have to have criteria based on...

...records as before. I use Inner join for ID fields but for some reason I got all records from MEDCLM. I opened properties for join and tried all 3 options and still have ALL records from MEDCLM Select * FROM source INNER JOIN MEDCLM ON source.ID = MEDCLM._ID; What I am doing wrong...

Hi, I wonder if I can use a view which was based on the table which was deleted? Thank you in advance Estersita

It works! God bless You!

I have 87 records in my makepart1 table. These both queries return 86 records. I wonder...probably it happens because my table have not just duplicates but also includes singe records (which NEVER had duplicates). That is why I tried the relation which I mentioned above... But it didn't work...

...can get what I need but Just one field. However I need all fields. I made relation between table MAKEPART1 and table NODUPL: Select makepart1.* From makepart1,NODUPL Where makepart1.[MEMBER ID]=nodupl.[MEMBER ID]; …But it give me all records from makepart1… What I am doing wrong? Thank...

Yes, they are Date/Time and I made sure they have short format. The only thing is...I inherited the initial table and it looks like it was created in Access 2000 while I work in Access 2002 xp. Could it affect?