Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DataNick
  • Content: Threads
  • Order by date
  1. DataNick

    SAS Proc SQL error question

    Hello All! I'm new to SAS and am encountering the following error 52 proc sql; 53 SELECT cd.* 54 FROM HCI_sql.DM_Claim_Diagnosis cd 55 INNER JOIN HCI_sql.DM_Claim c 56 ON cd.strClaim = c.strClaim 57 AND c.datAdmit BETWEEN '20051101' AND '20061231' 58 ORDER BY cd.strClaim...
  2. DataNick

    conversion of a char data type to a datetime data type resulted in an

    To all, I am trying to convert data in a varchar field to a datetime field in a temp table, so that I can perform MIN,MAX operations on the field. I've tried CAST, CONVERT both without success: SELECT DISTINCT strProviderID, CAST(StartDate AS datetime) AS StartDate INTO ##BCR_05_temp2 FROM...
  3. DataNick

    Field Value List

    Hi All! I'm new to SQL Server. Is there anyway to program list values for a field(s) for insert operations a-la MS Access field value lists? Thanks for your help!
  4. DataNick

    Print date entered in Parameter query in the Header of a Report

    Hi All! I've got reports that use Parameter queries as their data source. Is it possible to print in the header of my report, the last date entered as a month/yyyy? I usually use 2 inputs for the date range. So if I enter for example (2/1/04) for the first date, and then (2/28/04) for the second...
  5. DataNick

    VB6 - Crystal Reports Integration into VB6

    Hi All! I'm new to Crystal Reports having just talked my IS department into loading Crystal V.7 on my workstaion. I work as a Data Analyst, and write programs specific to my industry (Healthcare) on an ongoing basis. I've been told, or have read, that Crystal Reports is integrated with VB6. I...

Part and Inventory Search

Back
Top