SQL Query
I created a SQL query to restore several databases from a remote location to a test environment. I would like to add a check in the script so that it will not run if connected to certain servers so production databases are not accidentally overwritten
View Answer
| Jul 9 2008 6:34 PM GMT
| asked by
Asdemers
SQL Query, Scripting, Database backup and recovery
iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd
Hi,I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works)SELECT...
View Answer
| May 30 2008 2:31 PM GMT
| asked by
MarcGreen
DB2/400, SQL Query, SQL Subselect
Return zero when there’s no data
I am trying to write a query that I can use to generate an Excel chart to show activity in our database. I have it returning rows for each minute over the previous two hours (no problem). The problem comes when I plot a line chart. If there's no activity in a given minute, there's no row...
View Answer
| May 20 2008 2:02 AM GMT
| asked by
DanM
SQL, Excel 2003, SQL Query
row_number in sql 2000
how to find out the row_number in sql 2000 like using row_number() function in sql 2005
View Answer
| May 8 2008 10:51 PM GMT
| asked by
Rl
ROW_NUMBER, SQL Query, SQL Server 2000
SQL Query for time data only
I need to query a large remote weather database for events reported within time frames without regard for the day. For instance, I need all data that was reported for the fifteen minute window closest to noon each day for the last twelve years. I don't care about specific dates, just the daily...
View Answer
| Apr 17 2008 7:29 PM GMT
| asked by
C Pete
SQL Query, SQL
MySql Query
Hi Gurusi have a problem in MYSql Query Browwserthere is a table "jiuser" in "jasperserver" database. this table has a column "username". there is another table " jiresourcefolder" in the "jasperserver" database. this table has a column "uri". now i wana find out which user can access which uri....
View Answer
| Apr 7 2008 11:12 AM GMT
| asked by
Abhi Here
Database, SQL, Open source


