|
|
|
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 |
Filter by week: 1 2 3 4 5 different order in a union all clause Posted by Willo at 3/30/2007 9:54:35 AM Hi:
i have this query, and i need to specify an order for each SELECT... is
there a way to do it?
Note:
On MySQL, all i need to do is to use parentheses to enclose each select...
(SELECT a FROM t1 WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
UNION
(SELECT a FROM t2 WHERE a=11 AND B=2 ORDER BY...more >>
import question Posted by HX at 3/30/2007 9:42:41 AM I have to import a particular spreadsheet monthly (sql 2000, using
enterprise manager). The key field can have a value like 89976, which
appears to be just a number, though it is not calculated, OR it can have a
value like 5X6D4.
I have tried importing to a new table, importing to an exist...more >>
Return 10 records with Select Posted by Gabriel at 3/30/2007 7:07:57 AM Hello,
Is there a way with SQLServer Express to return only 10 rows, the 10 first
when I make a select, this select is orderd on the id.
Thanks,
Regards,
...more >>
Stored Procedure Problem (Maybe) Posted by Light at 3/30/2007 6:34:00 AM Hi all,
Because I am not sure what forums to post my question, so I put it here as I
am a new sql user as well.
I inherited some legacy ASP codes in my office. The original code's backend
is using the SQL Server 2000 and I am testing to use it on the Express
edition.
And I run into th...more >>
SQL2005 and user/device licsensing Posted by Jason Blake at 3/30/2007 4:06:01 AM If I purchase sql 2005 server standard edition with 10 user/device cals does
this allow up to 10 users or devices to be able to access the SQL server at
once ? IF an 11th user/device tries to connect do they get refused. ?
If i have 20 devices/users that may want to use the SQL Server but on...more >>
Operand type clash: text is incompatible with float Posted by Nancy at 3/29/2007 10:35:09 PM I have an error here I have never seen before. I am inserting probably
about 350 fields in a form and a similar form with about the same number
fields works just fine . .but this one throws the error in the subject line.
Of course the error line is on the command itself .. where should I sta...more >>
Attach database problem Posted by Gabriel at 3/29/2007 9:03:37 PM Hello,
I create a database on my development PC. I copy the 2 files on the computer
production, I'm trying to attach the database but I receive an error
......"can't be attach because the database is read-only"
DB created with SQLServer Express and the production is SQLServer Express
too...more >>
Help with Trigger Posted by Nirmal Singh at 3/29/2007 12:00:00 AM I have two tables called Managers and Employees.
The Managers table is (partially) structured as follows:
LineManager VarChar(10) Not Null
SummaryDate DateTime Null
This has a one-to-many relationship with the Employees table which is
(partially) structured as follows:
LineMan...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |