|
|
|
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 |
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 Need tips and suggestions to my site Posted by Mark C at 6/2/2007 10:07:24 PM Hi
I am in the progress of developing a web site whereby developers can
do free online tests on various programming languages. I would just
like some advice or feedback on ways to improve the site or other
comments of the site
The site is http://www.quiznetonline.com
Thanks in advance
M...more >>
How to know the date of the last update of a table? Posted by newToSql at 6/2/2007 6:41:49 PM Hi,
in sql 2k, one has to add a column to keep this info, But sql 2005 surely
keeps such info (date of the last update of a table) in its catalog.
but where?
Thanks
...more >>
How do I combine results from multiple fields into one? Posted by Sam at 6/2/2007 4:06:00 PM Hi,
We work w/ a call center who has a simple table structure where they capture
product and quantity information. The structure is as such:
Product01 Quantity01 Product02 Quantity02 Product03 Quantity03
123 -- 1 -- 234 -- 3
234 -- 2 -- 123 -- 1
As you can see there are 10 fields to cap...more >>
how to loop throught millions of records and insert into other tables? Posted by kfocus NO[at]SPAM gmail.com at 6/2/2007 2:03:13 PM I have two databases that have different table designs but they are
very similar. The first one has millions of records and I need to
populate the second database with these records though they will go
into different tables with pretty much the same field names and
types. The second db just ha...more >>
trouble removing duplicates Posted by Dan D. at 6/2/2007 11:54:00 AM Using SS2000 SP4. I'm trying to remove dupes from 69M rows. I found this code
on this site to remove dupes.
DELETE FROM YourTable
WHERE EXISTS
(SELECT *
FROM YourTable AS T
WHERE addrkey = YourTable.addrkey
AND row_id < T.row_id)
I'd like to flag the duplicates first so I my qu...more >>
Database design help Posted by koger at 6/2/2007 11:20:12 AM I'm making a small training program, and I have various exercises such
as:
biking, strength training etc. Some of the fields for these different
activities
will be the same, like heart rate, duration, time, but some will not
such as distance.
Since the exercises are different, my first thoug...more >>
Running Difference Query. Posted by Ankith at 6/2/2007 10:58:01 AM Hi Experts,
I am trying to calculate a running difference query for my Activity time and
was wondering if there are better ways and solutions to rewrite my query.
The need is to
return only those rows where the running difference is greater than 5
minutes and the row where the difference i...more >>
Using Select Max or Emulating Oracle Sequences Posted by Fares at 6/2/2007 2:05:01 AM Hi ,
I have a web application (SQL server 2005 database) in which there is a
businees part that requires a sepreate sequences for diffirent locations that
uses the same application. to be more specific suppose a table "Incoming"
which holds incomng mail , letters and soon .. now location 1 us...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Encrypted SPs running slowly? [SQL2K] Posted by Graham Morris at 6/2/2007 12:00:00 AM In our product we ship all our SPs in a separate database. The SPs are
already encrypted, and the database is supplied as a backup file which our
installation procedure loads into the target database.
I've found recently that if I reload one or two SPs in the target (i.e. get
the original ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |