Can you post the VB.NET code that is attempting to connect to a database?

What authentication method did you specify when installing SQL Server Express, mixed or Windows?

What OS is...

Have you considered replication? Express can be a subscriber and based on what you are saying you don't need to be able to write to the Express database.

Do you have the option of SQL Server 2008? SQL Server 2008 introduces the Filestream data type which is designed for applications such as yours.

If you cannot use 2008...

I agree with Tony, and others, that you need to evaluate all options and choose those which create the best application. I used to be a do it all...

Grant, glad there were no serious injuries. Another reason why I heat with oil. Even the past couple of years:P

The INTO needs to go immediately after the select list and before the from, so your code would need to be this:

select

account.nameof...

It depends on what you want to do. My personal preference is to use an identity column as the primary key which I use in relationships and for updates...

Is that login an administrator on the PC? If not you would need to have granted that login access to the SQL Server explicitly.

Also, the SQL Server Agent service...

GilaMonster (11/29/2008)

---

Jeff Moden (11/29/2008)

---

True enough... but they are suppose to imply the ability to think and do a...

There are 2 ways to create a temp table.

Create Table #temp

(

colA int,

colB...

Try converting the SUM(si.Qty) to a float as well. That shoul dnot be necessary, but I can't think of any reason why the code would not return a decimal...

GilaMonster (11/29/2008)

---

Jack Corbett (11/22/2008)

---

GilaMonster (11/22/2008)

---

I have a macro tool on my home pc where I can easily put in some pre-written answers. I'll see if I can find a site...

You...

Lynn,

Yes you are right, I actually don't use views all that often and wasn't sure if a CTE could be used in a view. Then I got an error...

It depends. I'd use a temp table or table variable if I am updating/deleting data from that set of data or accessing the data multiple times and now with...