|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Date Range Posted by Daniell at 2/28/2006 12:41:27 PM I have a query that I have to place a beginning and ending date to select the
information needed. The date is always 30 days for the current date. Is
there a way to set up a query to select current date minus 30 days that I
will not have to change the date each time?
Thanks in advance f...more >>
support for bind variables? Posted by G_Allen at 2/27/2006 10:15:14 AM I recently did a little development on an Oracle database and utilized bind
variables in a script like this:
SELECT first_name, last_name, zip FROM customers WHERE id = :cust_no
and simply defined ":cust_no" as a parameter through my application code. I
found this statement in an Oracle d...more >>
SELECT ~~ OVER(PARTITION BY ~~) in SQL Server 2005? Posted by Ed White at 2/24/2006 11:45:30 AM I'm using VS 2005 with SQL Server 2005 (all are release versions). I read
about the new Windows Functions SQL commands in a book, and, using the Query
Designer, created a SQL Query against my database that included
SELECT COUNT(field1) OVER (partition BY field1) AS Num
First, I type the ...more >>
Eliminating Duplicated Posted by venkataramarao at 2/21/2006 9:27:26 PM I have 3 tables Employee (empno,name,city) , Emp-Pl (empno,noofleaves) , and
Emp-Cl (empno,noofleaves). Now i require the report in the following format
Sample Data
employee
1 ravi kumar rajahmundry
2 ravindra kakinada
emp-pl ...more >>
question on date (or string after using convert function) comparis Posted by kei at 2/13/2006 7:05:26 PM select case when '02/12/2005' >= '01/02/2006' then 'T' else 'F' end
the result return is 'T' why?? (2005 should be < 2006)...more >>
select field contain chr(10) (Line Feed character) usng T-SQL Posted by kei at 2/9/2006 11:03:27 PM How to retrieve all record which has chr(10) in the value of a specific column?
select column1 from table1 where............? (how to write the where
statement)?
Thx!!...more >>
Datetime Selection II Posted by Stan at 2/6/2006 2:46:25 PM I posted this earlier and got an unusable answer, so I'm trying again...
I have a table with a transaction date of datatype datetime. I need to
select all where where the transaction date is 2 days ago. If I use
"where transaction date = (getdate( ) -2)" the selection fails because of, I
th...more >>
Date Selection Posted by Stan at 2/6/2006 6:52:43 AM I thought this was simple but...
I have a table with a transdate of data type datetime and I want to select
all transactions either for today or for getdate() minus some value. Looks
to me like the time portion is getting in the way of "where transdate =
(getdate() - 3)". How do I deal with...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Selecting data from one table based on conditions in another table Posted by John Steen at 2/2/2006 11:50:40 AM I'm used to doing simple queries from individual tables, so I hope someone
can help with this.
I need to select unique data from a column in table1 based on the value of a
column in table2. The data in the column of table1 is not all unique, so I
also need to filter out extra occurrances o...more >>
Changing Ordering Posted by Sian at 2/2/2006 2:11:27 AM
Not quite sure how to word this.
Is there any way to change the ordering of SQL Server
I need it to order
ABC2 then ABC12 then ABC110 (this is by entire string, rather than
individual characters)
currently it orders it ABC110, ABC12, ABC2
is there anyway we can change this?...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |