|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 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 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 A Challenge Posted by Mr Tea at 5/26/2007 7:41:31 PM A delivery driver has a truck full of parcels destined for 20 towns and
cities around the UK, He would like to drive the shortest distance possible
assuming this will be based on 'as the crow flies' planning, starting his
journey from any city in the list and ending when he reaches the 20th.
...more >>
raising events Posted by JB at 5/26/2007 5:24:00 PM I am working with a app that uses the client-server model vb.net front end
apps, sql server 2000 backend. Is there some way to raise events in sql
server on all open connections that can be caught by handlers in the front
end app( in the same way that events can be raised in vb.net and then ...more >>
ORDER BY in VIEWS outputs unsorted results - SQL2005 Posted by dumpemails NO[at]SPAM gmail.com at 5/26/2007 9:23:15 AM I know this is by design that if I have a VIEW that has a ORDER BY
then the SELECT on that particular VIEW will not necessarily return
the recordset back in the proper ORDER BY format. For example, if my
vwNames does this:
CREATE VIEW vwName as
SELECT *
FROM tableNames
ORDER BY Name
And ...more >>
Retrieving DISTINCT results based on a single column Posted by dumpemails NO[at]SPAM gmail.com at 5/26/2007 9:15:59 AM This is going to be tough to explain so I will get straight to the
issue. My table looks like:
BookID, StoreID
12 15
12 18
12 18
22 54
22 54
22 11
22 65
Each BookID can have ...more >>
Update Table With Incremental Numeric Values Posted by Ulysses at 5/26/2007 7:05:00 AM I have a calendar table that contains the following columns:
WeekEndingDate char(10), WeekNumber tinyint, MonthNumber tinyint, YearNumber
smallint, MonthName varchar(20).
The data is this table looks like this:
01/06/2007,NULL,1,2007,January;
01/13/2007,NULL,1,2007,January;
01/20/2007,NULL...more >>
Error creating role Posted by Markgoldin at 5/26/2007 6:54:38 AM CREATE ROLE db_executor AUTHORIZATION username
This command generates an error when I execute it on SQL 2005. What am doing
wrong?
Line 1: Incorrect syntax near 'ROLE'.
Thanks
...more >>
Interesting SQL riddle Posted by shlomoid at 5/26/2007 5:45:24 AM Interesting SQL problem I've encountered, that i would like to ask
opinion on, and maybe even a simple solution?
I've extremely simplified it, so that only the core issue remains.
Lets say you have this table:
create table fight(id int, date varchar(20))
insert into fight values (1,'2007')
i...more >>
One query based uppon an other one, with parameters ? Posted by Fred at 5/26/2007 12:00:00 AM Hi,
That might be a very simple thing to do, but as a newbie, i need your
help...
I have a sample table table1 with two fields f1 and f2:
1 A
2 B
3 C
4 D
5 E
6 F
I have a first query, then a second one using the first one :
Query1 : select f1, f2 from table1 where c1<4
Query2 : ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
slow data access from Posted by Alessandro T at 5/26/2007 12:00:00 AM I've migrated a desktop VB6 application from MSDE 2000 to SQL Server 2005
Express. Data access functions work correctly, but terribly slow. Beyond all
adjustements that can be made to the server, I've noticed that all the
queries and commands launched by my app run magically fast when I do the
f...more >>
Union ! Posted by Danny at 5/26/2007 12:00:00 AM Hi,
Is there a way to make one view with these two queries ?
SELECT YEAR(date_sortie) AS Année, MONTH(date_sortie) AS Mois,
COUNT(DATEDIFF(d, date_entree, date_sortie)) AS DureeSejour, SUM(ca2) AS
Perte_CA
FROM s_dossier
WHERE isbinf = 1
GROUP BY YEAR(date_sortie), MONTH(date_sorti...more >>
Ann: GeckoWare SQL Scribe Documetnation Builder version 4.0 Posted by Greg O at 5/26/2007 12:00:00 AM I am please to announce that SQL Scribe Documentation Builder version 4.0
has been release.
This upgrade brings SQL 2005 support, speed and other improvements.
New Features
SQL 2005 support
Table relationship diagrams
View diagram
Stored procedure diagram
Function Diagrams
Foreign key ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |