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, tv.Clinic, tv.Age, tv.Notes FROM (  /* SECOND LEVEL, this brings out cliniccode from the main query so we [...]

Answer Question   |  September 22, 2010  2:19 PM
Ruby, SQL Query, SQL Query Parse Data, Sql Script, SQL Server 2000

SQL RPGLE – How to override data set data structure at run time
I currently have an SQL RPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to [...]

Answer Question   |  September 23, 2010  1:43 PM
iSeries, RPGLE, SELECT statement, SQL, SQL Select statement problem, SQLRPGLE

How to implement crosstab query in Access?
How to implement crosstab query

Answer Question   |  September 23, 2010  4:24 AM
Access, CrossTab Query, SQL Server, SQL Server 2000

Limitations of a small business server
What are my limitations for using a small business server as opposed to a standard version? What can I not do from SBS?

Answer Question   |  September 21, 2010  8:10 PM
SBS, Small Business Computing, Small Business Server, Standard Edition

Trying to Design a Split Database Access 2007/SQL Server Express
Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I’ve been researching this for awhile, and [...]

Answer Question   |  September 30, 2010  5:07 PM
Access 2007, Database frontend, SQL Server, SQL Server Express, VB .NET, Visual Basic .NET

Migrate MYSql database to SQL 2005
We are looking to migrate from MySql to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

Answer Question   |  September 21, 2010  3:14 PM
MySQL, MySQL Database, MySQL functions, SQL, SQL 2005, SQL Server 2005, SQL Server migration, Windows

Changed Foxpro 2.6 .dbf file and change doesn’t show up when I run the .exe
Hi, I am hoping I am posting this in the correct forum. I work for a company that is running a simple tickets database program to track who uses what sports tickets. There is a .exe file and a few .dbf files, etc. About 10 files in a folder to run this Tickets program from [...]

Answer Question   |  May 26, 2012  5:56 PM
Database Files, FoxPro, FoxPro 2.6, FoxPro 2.6 for DOS, FoxPro for DOS

Avoid duplicate entry in database through Visual Basic 2005
I have made a program in VB 2005 with SQL2005 as back end. In the data base there are three fields which are unique id of a person. I want to display “Already Exist” message box when i enter an already existing id. matching all three fields and not allow duplicate entry.

Answer Question   |  September 20, 2010  10:29 PM
Software Management, SQL 2005, SQL Server 2005, VB 2005, Visual Basic, Visual Basic 2005

Using SELECT with LIMIT clause on a physical file
Hi – I’m new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.

Answer Question   |  September 24, 2010  1:18 PM
iSeries, MySQL, Oracle SQL Pagination, Pagination, SQL Select

Building a VB application
I’m about to create a project using VB.net and Microsoft SQL Server. It’s not difficult when i’m running it on 1 single computer. The problem is, this application should be located in 1 server and accessible through the network. Is there something different i have to do, or i only need to add the connection [...]

Answer Question   |  September 22, 2010  2:08 AM
Networking in 2010, SQL Server, VB .NET, VB.NET, Visual Basic, Visual Basic .NET

Get data from one MySQL datebase server to another in real time
hi     I am useing mysql database, I want to create one more database which I want to get updated in real time from the remote mysql database server. kindly help me in this. Thanks    

Answer Question   |  September 17, 2010  4:59 PM
MySQL, MySQL 5.0, MySQL Database, MySQL functions

SQL Server 2005 backup server
Is there a way to replicate a SQL server database to another SQL server with the same hardware and software? I want a live copy of the data up to date in case something goes wrong and we need to switch to the backup server.

Answer Question   |  January 30, 2012  8:08 PM
Backup, Backup and Recovery Hardware, SQL 2005, SQL Backup, SQL Server 2005, SQL Server database

Log of stored procedures run on my SQL 2005 box.
How can I tell who ran which stored procedure on our SQL 2005 server and at what time? Can we see if one stored procedure called other stored procedures there as well? Can we enable verbose logging somehow as well for more data?

Answer Question   |  September 15, 2010  5:22 PM
SQL, SQL 2005, SQL Log Files, SQL Server 2005, SQL Server stored procedures, Stored Procedures

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

Answer Question   |  September 13, 2010  8:31 PM
PL/SQL Developer, Security in 2010, SQL Developer, SQL development, SQL passwords, SQL Security, SQL Server

Converting 2008 RDL to 2005 version
Dear All, 2008 RDL can be converted to 2005 version easily through a software. Please visit: applybi.com   Thanks & Regards, Amar Sale

Answer Question   |  October 22, 2012  2:08 PM
Database reporting, Microsoft Business Reporting Service, RDL, Report Server, SSRS 2005, SSRS 2008

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. 

Answer Question   |  September 14, 2010  3:57 AM
Database design, SQL 2005, SQL 2005 Database design, SQL Database, SQL Server, SQL Server 2005

Query Manager Error
Type SQL Statement ************************** Beginning of Data ************************* 0001.00 SET MISC :MISC6 0002.00 SELECT bcbgcd COLHDG(“MISC” “CODE”), 0008.00 &MISC LEN(4,0) COLHDG(“SHARED CONTAINER” “CODE”) NAME(MISC) 0009.00 FROM lmbcrela 0012.00 WHERE bcbgcd=&MISC In checking the SQL syntax it errors: Token MISC was not valid. Valid tokens: :.

Answer Question   |  September 16, 2010  4:42 PM
AS/400, SQL Query, SQL Server, V5R4M0

Process ID 174:102 owns resources that are blocking processes on Scheduler 2.
Looking for solution to Process ID 174:102 owns resources that are blocking processes on Scheduler 2. We recently installed our Lucent Vitalnet app with SQL 2000.  it runs fine for 2-3 days, then the app stops when the above SQL error message occurs.  Rebooting the server temporarily fixes the problem until another 2 days. Also [...]

Answer Question   |  September 10, 2010  4:15 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Server 2005, SQL Server upgrades, Windows, Windows Server, Windows Server 2003, Windows Server 2003 SP2

Trouble installing SQL Server 2005
I have installed SQL2005 as default instance on a server that already has 2000 as the default. how can I remove sql2005 safely and reinstall 2005 as a named server.

Answer Question   |  September 9, 2010  8:06 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Installation, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2005 administration

Can I restore a SQL 2000 backup to a new SQL Server 2005?
Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.

Answer Question   |  September 8, 2010  8:32 PM
SQL 2000, SQL migration, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server migration, Windows Server 2008