10 pts.
sql update command to change text
I need to modify all characters within a text field. Some of the fields will contain 2-5 characters, others will contain 20-200 or more. The field is defined as Text 4000. I want to replace every letter with "K" We have a Select statement: select...
I need to modify all characters within a text field. Some of the fields will contain 2-5 characters, others will contain 20-200 or more. The field is defined as Text 4000. I want to replace every letter with "K" We have a Select statement: select...
Page at a time subfile
I want to code loading a single page subfile in SQLRPGLE. How do I handle the page up and page down key, posotion to in that program? thanks, NG Software/Hardware used: SQLRPGLE
I want to code loading a single page subfile in SQLRPGLE. How do I handle the page up and page down key, posotion to in that program? thanks, NG Software/Hardware used: SQLRPGLE
How to remove duplicate row in multi joined table?
My qurey is below. SELECT [5000Phantoms79w/VNos&othersFromAna].ID, [5000Phantoms79w/VNos&othersFromAna].PhtomNo, [5000Phantoms79w/VNos&othersFromAna].[New No], [5000Phantoms79w/VNos&othersFromAna].[dB OE tied to Phantom], [5000Phantoms79w/VNos&othersFromAna].dB2ndSetNewNo,...
My qurey is below. SELECT [5000Phantoms79w/VNos&othersFromAna].ID, [5000Phantoms79w/VNos&othersFromAna].PhtomNo, [5000Phantoms79w/VNos&othersFromAna].[New No], [5000Phantoms79w/VNos&othersFromAna].[dB OE tied to Phantom], [5000Phantoms79w/VNos&othersFromAna].dB2ndSetNewNo,...
SQL join two counts on same table
I have two different SQL statements that each is a count on the same table, but a count of different columns. I'm trying to combine them into a single statement, but am having trouble doing so. The two statements are: SELECT photoIDWinner as photoID, count(primaryID) as countWin FROM...
I have two different SQL statements that each is a count on the same table, but a count of different columns. I'm trying to combine them into a single statement, but am having trouble doing so. The two statements are: SELECT photoIDWinner as photoID, count(primaryID) as countWin FROM...
SQL Mismatch in From Statement
What need to be done if an error message mentions "Mismatch in From Statesmen"? It seems like I have not done any different then what I have done over the last numerous of queries that I have done. I started with an excel spreadsheet. I had to do some concatenation of the some columns. I then...
What need to be done if an error message mentions "Mismatch in From Statesmen"? It seems like I have not done any different then what I have done over the last numerous of queries that I have done. I started with an excel spreadsheet. I had to do some concatenation of the some columns. I then...
Export Oracle data to Excel
Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks Software/Hardware used: Oracle, Excel
Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks Software/Hardware used: Oracle, Excel
SQL Database User
Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql...
Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql...
SSRS - SQL runs in 1 minute but Reporting Services tuns for 30 minutes
I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run...
I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run...
Working with SQL: Extracting Data or Text within a Query, adding new column for extracted data
I have created a passthrough query in access to draw information from an AS400 system. I have also created some tables in excel and copied and pasted them into access to link them to the AS 400 query via access. So as of now I have three files in one access passthrough query. The one file is "...
I have created a passthrough query in access to draw information from an AS400 system. I have also created some tables in excel and copied and pasted them into access to link them to the AS 400 query via access. So as of now I have three files in one access passthrough query. The one file is "...
Need to know the date and time a particular sql command was fired through an interactive session
Is it possible to find the date and time a particular sql command was entered. Iam able to view the commands entered in an sql session but not able to find the date and time the commands where fired.
Is it possible to find the date and time a particular sql command was entered. Iam able to view the commands entered in an sql session but not able to find the date and time the commands where fired.
SQL convert numeric to date format
How can I convert an 8 digit numeric (format ccyymmdd) into a real datefield to be used in date arithmetics? I need to calculate the number of months between month(current date and a date represented in my DB as an 8 digit numeric with format "ccyymmdd". Therefor (I assume) I need to convert my 8...
How can I convert an 8 digit numeric (format ccyymmdd) into a real datefield to be used in date arithmetics? I need to calculate the number of months between month(current date and a date represented in my DB as an 8 digit numeric with format "ccyymmdd". Therefor (I assume) I need to convert my 8...
SQL dynamic date calc.
How shall the WHERE clause look for this challenge: Pseudocode: select all records from file where datefield (ccyymmdd 8.0) shall be greater than todays month minus 36 months. As you can see this may be expressed as [em]rolling 36 full months plus current month[/em]. Any help will be...
How shall the WHERE clause look for this challenge: Pseudocode: select all records from file where datefield (ccyymmdd 8.0) shall be greater than todays month minus 36 months. As you can see this may be expressed as [em]rolling 36 full months plus current month[/em]. Any help will be...
Defining a sort variable (ORDER by) in RPG SQL
I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the ORDER by a variable in RPG...
I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the ORDER by a variable in RPG...
speed up selection in SQL Query
I am using a database,which is mainly using for Data retrieving purpose.What all are the tricks to increase the speed of select query from that database?
I am using a database,which is mainly using for Data retrieving purpose.What all are the tricks to increase the speed of select query from that database?
SQL Help needed
In what way, using SQL could a statement be written in that it would not allow any duplications of a particular text in a column? How would it be set up? Also if you have three different tables, lets call them A, B, and C., and there may be multiple matches in each of the tables. I need to...
In what way, using SQL could a statement be written in that it would not allow any duplications of a particular text in a column? How would it be set up? Also if you have three different tables, lets call them A, B, and C., and there may be multiple matches in each of the tables. I need to...
CLR Assembly in MS SQL 2008
I have a problem with COM-objects which i create in CLR-assembly in VB.NET via CreateObject. When I compile this assembly as console project and run loging under any account on server, it works ok. But when i run this file from MS SQL, it can not create object. What may be reason for this?
I have a problem with COM-objects which i create in CLR-assembly in VB.NET via CreateObject. When I compile this assembly as console project and run loging under any account on server, it works ok. But when i run this file from MS SQL, it can not create object. What may be reason for this?
Date problem with Delphi 7
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...
UPDATE a year from an ISO date field using SQL
Dear Sir/Madam, How can I update the year from a date field. For example the date file contains '2008-12-31' and I would like to use I-Series navigator's SQL to update the date field above with '2007-11-31'.But my intention for the update here is to decrease/deduct the year by 1 year and the month...
Dear Sir/Madam, How can I update the year from a date field. For example the date file contains '2008-12-31' and I would like to use I-Series navigator's SQL to update the date field above with '2007-11-31'.But my intention for the update here is to decrease/deduct the year by 1 year and the month...
