Summary: I need SQl query to find out the last modfied date of columns in table. there are no date/time related columns in the table. But I what to find when ...
Summary: Hi, I'm designin sort of asset manager software and i'm already stuck with some SQL-querys... :) Tables don't have all the fields yet, because it's ju...
Summary: I have a sql database that I need to monitor with nagios but it will not work with sql 2005. I was wondering if a sql query that can watch the databas...
Summary: Hello! Maybe someone can help me... I want to write procedure containing some queries as SQL query. For example, I have queries "sglstr", "sqlstr1" an...
Summary: without the schema for these tables, it's hard to give you a fixed script, but I've run a few examples here and it looks like you have one of the two ...
Summary: hi, I need help on making a SQL query to find the total processing time of a document by each user by each day. The database is SQL server 2000. The...
Summary: "i want to show the unique record of every separate field" I'm not clear what you mean by this. Do you mean that for each field, you want to show al...
Summary: Could anyone tell me what this query would be like converted to Oracle? Thanks in advance. SELECT tblBlock.* FROM tblBlock INNER JOIN tlkpLocation ON ...
Summary: I don't have anything against doing a temp table, but what SQL query can I use to fill it with the data you specified? That's where I'm getting stuck...
Summary: Hi, SELECT * FROM `Example` WHERE `DateTime` = "2007-08-28 15:24:44" If this entry doesn't exist how so I get the query to find the closest matching ...
Summary: Use ADO and this shouldn't be much of an issue on the programming side. All that will change is the table and related SQL queries. Access is fine fo...
Summary: Hi, I'm trying to spool the output of my query in SQL Plus in Oracle to an output file. But, it includes column names before each row. Is there a way ...
Summary: You're just going to have to learn how to use SQL better and fix your queries. If you want good targeted help, you'll need to explain the layout of th...
Summary: Hi, I have no idea of configuring SQL in Linux. The port number is 3306 and I don't know what should the hostname be? Please help me to know the ...
Summary: hi, I have a column containing dates (date datatype) now a user can select a date via php or whatever, the result the user has to get is the data stor...
Summary: Hi I need a query that will only show dates between the date in the date column and the date exactly a year before it. eg: 30/09/09 and 30/09/08 is ...
Summary: Hi I am trying to spool the output of 3 sql queries into different sheets of the same excel file. Like Query 1 result in sheet 1 of report.xls Quer...
Summary: Hi, How can we save (spool) the output of an SQL query to an external file(.txt) with some specific delimiter ( eg comma or tab etc..) Now, after spoo...
Summary: In my db i have a colummn fname where first names are stored. If the name contains a middle name, i wont see whats after the space. Example: fname ...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
