• Translate Ruby Script to SQL Query?

    I need help translating a ruby script to SQL query. I'm a SQL noob. Help please. [em]here is the script.[/em] require "rubygems" require "ruport" SQL = <<-EOS SELECT     tv.ApptDate, tv.PatName, tv.PatFirst, tv.PatLast, tv.Phone, tv.ApptTime, tv.Provlast, tv.ProvFirst, tv.ProvTitle,...

    Transom3245 pointsBadges:
  • Excel date format

    I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.

    Tamara5 pointsBadges:
  • ID Theft and National Security

    If it turns out, as I believe, that enemies of the United States are behind a lot of the major ID thefts in the US, that would mean that a lot of money is going to our enemies. Can we therefore surmise that those who mishandle our identity information, by means of their poor stewardship of our...

    InfoSafety75 pointsBadges:
  • Visual Basic Email Script

    I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?

    Dragione5 pointsBadges:
  • Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables?

    Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables? This would likely be done via a web browser interface such as Joomlah.

    Restart15 pointsBadges:
  • Database Issues – Trying to prove that something has to be done

    Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major...

    Dcantwell470 pointsBadges:
  • Will the SQL performance improvements in V6R1 affect QUERY?

    Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

    Fw15 pointsBadges:
  • How to update a row in grid view?

    how to update a row in grid view when changes made to database..

    Santu1015255 pointsBadges:
  • Basic Access Database query question

    I have an "Early voter list" table that I queried for matches against a "Dem Voters" table with the results generating a new "Identified Early Dems" table.   I would now like to query the "Identified Early Dems" table against the original "Early voter" table and be left with a table of "Early...

    Sharx2th5 pointsBadges:
  • Replicating a partitioned table to a secondary server

    I have a rather large table of approximately 3 billion records. The table is partitioned into 24 monthly file groups, each with its own data file. I use a sliding window archiving solution to switch out data to our staging table, where it is then loaded onto an archiving database. The switch out is...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Express 2005 query times lagging

    I execute some simple queries on my own system's sql server express 2005, the executions time is under 1 second but when I execut the same queries on our server's sql server express 2005, the queries execution time is about 3 seconds or more and I don't know why. both of the systems have the same...

    Reza838325 pointsBadges:
  • crystal reports and access 2002 issue

    can Crystal Reports 9 access data originally created with MS Access 2000 (successfully), be used in MS Access 2002. Getting error code 0xc28, no read permission. MS Access application had been recently updated.  Read permissions on access data file are correct, and have not been changed since...

    Catcher5 pointsBadges:
  • SQL Server 2005 database design

    What is 1*,o* 1..1,1..*,0..*,1..* in databse design,i have no exact idea about this,need help. 

    Shamu75 pointsBadges:
  • Getting password when we know Product Code and Serial in Pl/SQL Developer

    Can any one please tell me how to know the current password of my pl/sql developer which i am using currently? I know my product code and serial Send me the procedure Thanks in advance PSR.COM

    PSRDOTCOM5 pointsBadges:
  • Data Extract

    What is the easiest way to extract data from a pipe-delimited text file?

    farmgirl165 pointsBadges:
  • Deduplication Backup strategy

    I'm looking for a hardware base dedupe backup solution that does not require additional licensing. 

    Mgtow5 pointsBadges:
  • Outlook 2007 templates in Access

    I am trying to call an Outlook email template from Access app. and I am not sure what I am doing wrong. I can get an email to come up with TO, CC, Subject, and Message text variables when using the DoCmd.SendObject. However, I can not get the Outlook template to come up that I want to use. I have a...

    Rdd111115 pointsBadges:
  • Crystal Report Writer DB Connector error

    What does this error mean? Database Connector Error: '42S02:[DataDirect][ODBC XML driver][XML][Closed Integrator Base] A provider error occurred while calling the underlying provider. IOpenRowset::OpenRowset[Closed XML ADO Provider] returned 80040E37[The table...

    Splows5 pointsBadges:
  • PHP functions

    how do multiple functions work

    SGB35 pointsBadges:
  • tutorials

    hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

    Mmm5550 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