I want to use Functions in Update Queries Set operation Update File Set FName = Substring(Name,1,10) Where EmpNo = 99 How to perform this one using SQL Queries
Answer Question | March 15, 2011 6:47 AM
AS/400 SQL, AS400 - SQL Queries, SQL queries, SQL Query
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 [...]
Answer Question | September 15, 2010 7:40 AM
SQL Express 2005, SQL queries, SQL Server, SQL Server performance, SQL Server Query
Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?
Answer Question | September 17, 2010 3:13 PM
i5, SQL performance, SQL queries, SQL Query, V6R1
I have stored A value in a string , when I try to use the STRING VARIABLE IN SQL QUERY DOESN’T NOT RESPOND??
Answer Question | September 2, 2011 9:33 AM
SQL queries, SQL Query
Cobol uses some kind od IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the [...]
Answer Question | January 20, 2010 9:55 PM
AS/400, RPGLE, SQL, SQL queries
I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for practice .
Answer Question | May 10, 2013 10:15 AM
SQL, SQL Database, SQL queries
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—— [...]
Answer Question | October 30, 2009 1:24 PM
SQL, SQL queries, 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?
Answer Question | July 21, 2009 6:11 PM
SQL queries, SQL Query, SQL query optimization
Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select [...]
Answer Question | July 24, 2009 10:15 AM
SQL queries, SQL query optimization, SQL Server 2005
I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?
Answer Question | September 2, 2011 1:01 AM
SELECT statement, SQL, SQL queries
when i run below all SQL Query simulataneously against 1500000 Rows its take 10 minutes i put the non-clustered index on the columns TATCallType ,CallTo the data type of both columns is varchar select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType is null and substring(AuditData.CallTo,1,convert(int,0))=” and len(AuditData.CallTo)=10 select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType [...]
Answer Question | July 14, 2009 10:00 AM
Slow SQL Query, SQL queries, SQL query optimization
I wanna update a field in the table(which is a Data Structure) through Sql Query.. Can anyone help in this regard>>
Answer Question | June 26, 2009 6:44 AM
Data structures, SQL, SQL queries
I am creating reports in Crystal 8.5 because it is required for the CRM system we use. I am having trouble pasting the SQL query that I need into the report. It will populate but it is not updating the contents of the report. Can anyone hel with this?
Answer Question | June 19, 2009 4:37 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Database, SQL queries
I need to gather some data from our call manager and the reporting tool that comes packaged with the server is horrible! We have Call Manager version 6.1. Is there anyway query the call detail records other then using the reporting tool? If so, please advise me. Thanks
Answer Question | June 4, 2009 2:09 PM
CallManager, Cisco CallManager, Cisco CallManager 6.1, SQL queries
how would I write an SQL statement to view the number of purchases for each month in the year of 2008..?
Answer Question | May 27, 2009 6:24 AM
SQL queries, SQL Server administration
I want to query an SQL server database for specific tables and their descriptions. How do I do that? Is there a special tool needed to do this?
Answer Question | May 11, 2009 10:01 AM
SQL, SQL queries, SQL Server Query
can someone tell me the error in this statement declare @cmd nvarchar(4000) declare @PatNo bigint set @PatNo=123 set @cmd= N’insert into TmpDues ( PatNo, BillDate, ReceiptNo, PayMode Amt) select ReceiptTable.PatNo,ReceiptTable.BillDate,ReceiptTable.ReceiptNO,’+ ”’Cash”’+’ as PayMode,CashAmount From ‘ + @databasename + ‘.dbo.ReceiptTable where PAtNo=’ + cast(@PAtNo as nvarchar) exec @Cmd
Answer Question | May 16, 2009 6:26 AM
SQL, SQL error messages, SQL queries
I want to select months from January to December using SQL query. I will use this for list item note:- without using PL/SQL and less union.
Answer Question | April 19, 2013 9:04 AM
SQL development, SQL queries
queries seem get mangled by our report writer middleware; I’d like to see the actual SQL received by Oracle9i from a particular user. how?
Answer Question | April 17, 2009 5:14 PM
Oracle 9i, SQL queries, SQL Server logs
Hi, my need is to update a table with a join of 2 other tables. The first table (a) has 5 columns (product_id number, ist number, plan number, plan_w number, ist_w number) The second table (b) has 2 columns (prod_group_id number, percent number) The third table (c) has 2 columns (product_id number, prod_group_id number) My [...]
Answer Question | April 24, 2009 11:47 AM
JOIN statement, SQL, SQL queries, UPDATE statement