SQL QUERY VIEW - HELP REQUIRED !
I have an sql : [strong]select customer invoice_no invoice_amount due_date from Table[/strong] This gives a list of all details in rows 99999 1234 12.50 21/11/09 99999 1235 13.55 22/11/09 99998 7899 12.20 21/12/09 99998 7900 12.75 22/12/09 99998 7901 11.11 23/12/09 I want a line...
I have an sql : [strong]select customer invoice_no invoice_amount due_date from Table[/strong] This gives a list of all details in rows 99999 1234 12.50 21/11/09 99999 1235 13.55 22/11/09 99998 7899 12.20 21/12/09 99998 7900 12.75 22/12/09 99998 7901 11.11 23/12/09 I want a line...
145 pts.
sql query
i am working on a project. If i enter the a/c no and i found correct then the companies name and their share values are provided to me.. After that when i buy a no of shares i get the Transaction amount(no of shares*share value),broker value(1.5% of transaction amount),total amount (transaction...
i am working on a project. If i enter the a/c no and i found correct then the companies name and their share values are provided to me.. After that when i buy a no of shares i get the Transaction amount(no of shares*share value),broker value(1.5% of transaction amount),total amount (transaction...
SQL query help
Below is a list of the query that I am working on. There are part numbers that may be match to more than one module number. What I need is to show only the part numbers for the list. These part numbers I need a list of only one part number for each group. PartNo------ Module------ Numbers...
Below is a list of the query that I am working on. There are part numbers that may be match to more than one module number. What I need is to show only the part numbers for the list. These part numbers I need a list of only one part number for each group. PartNo------ Module------ Numbers...
SQL Query Issues with date math
Table with partial sample data would appear as follows: EQUIPNO ASSEMBLY START_TIME END_TIME 150 0 24-MAY-09 25-MAY-09 150 0 25-MAY-09 25-MAY-09 150 0 ...
Table with partial sample data would appear as follows: EQUIPNO ASSEMBLY START_TIME END_TIME 150 0 24-MAY-09 25-MAY-09 150 0 25-MAY-09 25-MAY-09 150 0 ...
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?
Improving the initial speed of a SQL query
I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?
I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?
Sql Query in AS400
I am trying to execute a Query String but I receive following error Query exceeded the specified time limit or storage limit however my query length is normal, nevertheless i have executed larger query too. How to solve this problem.
I am trying to execute a Query String but I receive following error Query exceeded the specified time limit or storage limit however my query length is normal, nevertheless i have executed larger query too. How to solve this problem.
Help Refactoring SQL Query
Dear Friend Below is my SQL Query select DISTINCT Auditdata.ID,ns.ProviderMaster_ID as CDRComment from Auditdata AuditData inner join AuditMaster am on am.ID=AuditData.AuditMaster_ID inner join HomeCircleMaster hcm on ...
Dear Friend Below is my SQL Query select DISTINCT Auditdata.ID,ns.ProviderMaster_ID as CDRComment from Auditdata AuditData inner join AuditMaster am on am.ID=AuditData.AuditMaster_ID inner join HomeCircleMaster hcm on ...
slow update Query(Primary Key)
dear Friends when i run below query its take more than 10 minutes and still running.... update auditdata set TATCallType='12',TATCallUnit='1' from auditdata auditdata inner join Auditdata_sms_12 a_sns on auditdata.ID = a_sns.id auditdata is my original table in above table ID is primary key ...
dear Friends when i run below query its take more than 10 minutes and still running.... update auditdata set TATCallType='12',TATCallUnit='1' from auditdata auditdata inner join Auditdata_sms_12 a_sns on auditdata.ID = a_sns.id auditdata is my original table in above table ID is primary key ...
Using sql code to read a filename
Can you write sql query that will read pdf filename from a dir and then match the filename to a data element in a table having the same name? For instance, the filename is 12345.pdf where 12345 is actually an invoice number. Can the query read the filename and then locate the same invoice number...
Can you write sql query that will read pdf filename from a dir and then match the filename to a data element in a table having the same name? For instance, the filename is 12345.pdf where 12345 is actually an invoice number. Can the query read the filename and then locate the same invoice number...
SQL: comparing rows and give the change
saving greetings to everyone! i m receiving a dump data at day 1, inserting all that data into a database. this database has about 30 above tables, each and every table has about 100 above rows. every table has a column name cell id. on 2nd day i again receive the dump which also has to be...
saving greetings to everyone! i m receiving a dump data at day 1, inserting all that data into a database. this database has about 30 above tables, each and every table has about 100 above rows. every table has a column name cell id. on 2nd day i again receive the dump which also has to be...
Query showing vbCRLF in string data
Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I'm trying to list records where the user input 2 or more lines of data in a simple text field. E.g., "John Q. vbCRLFSmith" as opposed to just "John Q....
Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I'm trying to list records where the user input 2 or more lines of data in a simple text field. E.g., "John Q. vbCRLFSmith" as opposed to just "John Q....
Concatenation
I am using "substring(concat('00'...." within my SQL select for a date query. However, the date 10 and higher is being overridden with "0". How do I prevent this from happening?
I am using "substring(concat('00'...." within my SQL select for a date query. However, the date 10 and higher is being overridden with "0". How do I prevent this from happening?
empty fields in a query
I have a column with answers that people responded to different questions about themseleves. I have another column with the question id that the answer corresponds to. i want to display the answers in separate columns based on which question it corresponds to. Each column should be filled with the...
I have a column with answers that people responded to different questions about themseleves. I have another column with the question id that the answer corresponds to. i want to display the answers in separate columns based on which question it corresponds to. Each column should be filled with the...
Viewing distinct records in a SQL query result
I have a set of records in a SQL query result. I only want to see one record, per the data field "ID". I am getting 2 records for some ID's, as there is one field that is different in the 2 records. This happens even if I start the query out with SELECT, DISTINCT, and then all of the fields I...
I have a set of records in a SQL query result. I only want to see one record, per the data field "ID". I am getting 2 records for some ID's, as there is one field that is different in the 2 records. This happens even if I start the query out with SELECT, DISTINCT, and then all of the fields I...
How do I limit my SQL output to one record per student?
Current resuls: Student ID: Guardian 2 Joe 2 Mary 3 Goldie 4 JIm Needed results: Student ID: Guardian 2 Joe 3 Goldie 4 Jim
Current resuls: Student ID: Guardian 2 Joe 2 Mary 3 Goldie 4 JIm Needed results: Student ID: Guardian 2 Joe 3 Goldie 4 Jim
SQL query for obtaining answers
Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is...
Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is...
Connectionstring for paradox db password protected
Hello everybody, Searching for answers I've found this insteresting page!! I've created a SQL query to a paradox database, it works fine with a non- password protected table: Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended...
Hello everybody, Searching for answers I've found this insteresting page!! I've created a SQL query to a paradox database, it works fine with a non- password protected table: Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended...
Subtracting two numbers
Hi Using SQL, how can I subtract two values for the same parameter received at different times say 1am and 1:30am so sql to do value(1:30am)-value(1am)=? Regards
Hi Using SQL, how can I subtract two values for the same parameter received at different times say 1am and 1:30am so sql to do value(1:30am)-value(1am)=? Regards
SQL query for same phone number
I have 3 columns phone number, users and locations I would like to see only the name and phone numbers of the users that are calling the same phone number Not quite sure how to represent this in a SQL Statement Thank you very much for your assistance
I have 3 columns phone number, users and locations I would like to see only the name and phone numbers of the users that are calling the same phone number Not quite sure how to represent this in a SQL Statement Thank you very much for your assistance
