Can someone point me to the download location of the Storefront sample for
the Adventure Works Cycles sample database in SQL Server 2005.
The online documentation refers me to
http://go.microsoft.com/fwlink/?linkid=42219, but I was not able to find the

I have a client who has reported a discrepancy in their database.  In
their test database a certain report returns 5,333 rows, but in the
production database it returns 5, 332 rows.
I'll get to the bottom of it in due course, but I came across an

Is there some reference material that shows how to connect to a SQL 2005 DB
using Visual Basic 6? Any help is appreciated.

I need to update a field in about 20 records on a table. The table has
an update trigger (which updates the [lastedited] field whenever a
record is updated). As a result I'm getting an error: "Subquery
returned more than 1 value.", and the update fails.

I need to open a newly created xml doc (in the same format) each time
a new one is sent to our web service.  I would like to use a stored
procedure and call to it the problem is I keep getting a
XML parsing error: Invalid at the top level of the document.

How do I import data from CSV file (source.csv) to my MSSQL table
(dbo.target)?
Kindly advise.
Thanks

I've written this query:
select distinct topics, questions, answer
from topics AS A, QuesNans AS B
where A.topicid = B.topicid

This is kind of what I'm trying to do in my MS SQL 2000 query. Should
I be able to reference s1.col1 inside the 2nd derived table?
I'm getting 'Invalid column name col1' and it's coming from the 2nd
derived table (I've commented out other refs to just it to check).

I have a problem in this query:
select order from ordertable
where orderdate >= '06/20/2007' and orderdate < '06/21/2007'
this query do not return any record

I have a problem in this query:
select order from ordertable
where orderdate >= '06/20/2007' and orderdate < '06/20/2007'
this query do not return any record

Here is my problem:
I have two tables. Table1 contains two fields. Field1 contains names
of job types (Accountant,Doctor,etc.) Field2 contains the number of
cases to select from Table2 for each job type.

I have this piece of SQL code:
UPDATE a
SET Field1 = c.Field1
FROM a

How does the phrase "Is Not Null" in the where clause effect the
effectiveness of a query?
If it is a determent to the effectiveness of the query, how do you
work around it?

All,
Is there any way to _set_ an IDENTITY column to have a certain value
so as to create a gap in the set of identity values on purpose?
All I've found is SET IDENTITY_INSERT.

I'm an Access/SQL novice and I have an sql problem:
I have the following table Price:
FuelID PriceDate   Price
LPG    1/05/2007   0,2