I have this data:
id             GroupId             DDate                   Value
1                        1            7/31/2008                     5
2                        1            7/31/2008                     6

** Apologies for cross-postings. Please send to interested colleagues
and students.**
-- CALL FOR PAPERS - Deadline for submissions (2nd call): 1 September
2008 --

I read the following in a book
1) we can have several non clustered indexes on a table , but we can
have only one clustered index per table
2) index on the primary key can be clustered or non clustered

the following is the algorithm which i saw in schaum series
book(fundamentals of relational databases)
satisfies algorithm
this algorithm shown below can be used to determine if a relation r

I recently read the following in a book(oracle 9i for dummies by
Carol McCullough Dieter)
The fastest way to retrieve rows from a table is to access the row
with exact row id. An

Does anyone else find LIMIT statements particularly irritating? I
mean, as far as I know it has no basis in relational algebra, and yet
I find myself using it constantly. (In Oracle 11g I am still forced to
use the hideous ROWNUM which is even more irritating, and yet there I

i have a question about two parallel transactions which insert the
same key.
Assume that key A does not yet exist.
T1 Begin

I am designing a database for my charity (we are a local special needs
charity) to replace our existing one, and my main goals are to make
the database accurate, easy to use, and able to expand (the current
database is not!).

We have a client that has the typical online quote generator but is
looking to revamp that process and tie it in with other services he
can sell to other insurance clients. The application is still in its
infancy but could have the potential of blowing up in our face if we

I'm trying to create pivot, my data are area, sub area, member code.
On Pivot/Crosstab data area i want to calculate how many member that
access in sub area, and how many member that access in area, where as
on the raw data it self my member has many record on each area and sub

Find the latest updates in SQL server tools and techniques. More
details on database management, software testing, flow chart
prepartation and many more
http://www.sqlserversoftware.blogspot.com

In the following I’m using the definitions of value, variable and type
described by C.Date.   Values are eternal and immutable.  Variables
are holders for values that exist in some context.  Values and
variables are both typed.

Before I waste a big chunk of next week, does anyone know of any docs on the
web that attempt to gather together examples of anomolous behaviour in
standard SQL?  I am thinking particularly of things like inconsistent
treatment of nulls.  I've got a couple of (to me) very obvious ...

I'e been tring to develop a workable implementation of nested interval tree
encoding using continued fractions:
http://arxiv.org/ftp/cs/papers/0402/0402051.pdf
However, I'm running into a snag when I try to decode the materialzed path