AS400 – SQL
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

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 [...]

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?
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

sql query
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

On the as/400 i series can one use SQL querys to update file
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

Can somebody provide me SQL questions based on various situation?
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

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—— [...]

Answer Question   |  October 30, 2009  1:24 PM
SQL, SQL queries, SQL Query

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?

Answer Question   |  July 21, 2009  6:11 PM
SQL queries, SQL Query, SQL query optimization

SQL Server 2005 Query Very Slow in the first run
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

select parent where more than one child
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

Slow SQL Query
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

Update DateStructure Field through SQL Query
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

pasting a database query into crystal
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

CallManager and 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

SQL Server query
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

Querying database tables with their descriptions
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

Execute command in SQL
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 Jan to Dec using SQL query
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

log 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

Multiple Join Update
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