Germany Super Sex Hotline Live FREE!
Fri, 17 Feb 2006 04:59:03 -0800
The latest interactive Sex Hotline! Call +49 4489 5198
Free! Multi-lingual!
...
|
question on date (or string after using convert function) comparis
Mon, 13 Feb 2006 19:05:26 -0800
select case when '02/12/2005' >= '01/02/2006' then 'T' else 'F' end
the result return is 'T' why?? (2005 should be < 2006) ...
|
www.verbatim.wordpress.com
Mon, 13 Feb 2006 16:44:40 +0100
...
|
select field contain chr(10) (Line Feed character) usng T-SQL
Thu, 9 Feb 2006 23:03:27 -0800
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!! ...
|
Datetime Selection II
Mon, 6 Feb 2006 14:46:25 -0800
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
think, the time p ...
|
Date Selection
Mon, 6 Feb 2006 06:52:43 -0800
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 just the date ...
|
(.)(.) Hot...
Fri, 03 Feb 2006 20:15:31 -0800
Call +8613352960090
Free!
Multi-lingual!
...
|
|
|
(.)(.) Hot...
Fri, 03 Feb 2006 20:15:30 -0800
Call +8613352960090
Free!
Multi-lingual!
...
|
www.dvd100.net
Fri, 3 Feb 2006 14:53:30 +0100
www.dvd100.net Comprar verbatim princo traxdata tdk benq , a los mejores precios.
Entregas Seur 24 horas.
Iva incluido * Sin canon
Visitanos no te arrepentiras.!
www.dvd100.net
http://www.dvd100.net
...
|
Selecting data from one table based on conditions in another table
Thu, 2 Feb 2006 11:50:40 -0800
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 of of the data. ...
|
