G'Day All,

Ian: Thank you again for a most interesting problem.

This response is part two of two.  See the post immediately prior

for an explanation of how I arrived at this point.

Wayne

CREATE...

G'Day All,

Ian: Thank you for a most interesting problem.

This response is part one of two.  See the post immediately prior

for an explanation of how I arrived at this point.

I worked...

Hello Sahana,

One possible way to solve the problem to build a table containing the timestamps in the first column, then do a left outer join to the actual data table. ...

Here is a simple example of what you are describing:

CREATE TABLE A_Table (FullName varchar(50),

                      FirstName varchar(25),

                      LastName varchar(25))

INSERT INTO A_Table (FullName) VALUES ('Homer Simpson')

INSERT INTO A_Table (FullName) VALUES ('F Flintstone')

UPDATE...

In my copy of books online (Sql server 2000, not perfectly up to date) I took a look at Contents | SQL Server Architecture | Implementation Details | Maximum Capacity...

Take a look at books on line for BCP with a queryout parameter.  The topic you want is "bcp Utility".

Hope this helps

Wayne

Sushila,

Remi's answer is correct, and may make more sense if you look at when in the execution cycle the where clause is evaluated.  For example, consider the simple query:

select * from...

All,

I would concur with Carl and Bob that if you intend to implement any of the procedural, computationally intensive algorithms directly then you will have an easier go of it...

Well, we have demonstrated that the database behaves as expected when presented with correct code.  Since the database is not changing between test runs, that suggests that the problem lies...

Thanks for the extra info.  I'll play with it in just a bit.

Have you tried running exactly the example from books on line?  From the topic "SET XACT_ABORT"?  What are the...

Can you provide the table definition for "foo"?  I want to ensure that I am exactly duplicating the test case.

Thanks

Wayne

Another note - Kimball has done some fair amount of work in the data warehouse space and discusses the use of "bridge tables" to assist in the fast query and...

G'day all,

Solutions to dijkstra's algorithm and related processes are often seen in the DB as hierarchy traversal routines.  DBs are actually quite good at solving the problem, as it is...

Brendthess: Antares is correct.  Your solution dropped various rows that should have been returned.

Antares: Your assumptions and conclusions are completely correct.  Thank you for the confirmation that I am on the right...

Excellent article Antares,

However there was never a question of why the code behaves the way it does.  I understand the behavior of ANSI_NULLS, = NULL, IS NULL, ISNULL(), and so...