OK based on your post,i think this query has 10 left outer joins altogether;

I think I saw Jeff Moden mention that left outer joins require a table scan, right?

that would...

I tested your code with that one sample row you posted, and I get a problem with the field for INVOICE_NUMBER, because the data is 41 chars, but the definition...

this is similar to a different thread i was in, where we calculated the difference between the defined length,and the max used space for a row;

take a look here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=385732#bm386585

even...

if you are in as a builtin\Administrator, you can still use the sp_password, you simply leave oldpassword as null.

an admin does not need to know the old password,  so you'd...

From what I've learned, RAID 5 is slower in comparsion to RAID 1 because the data is distributed redundantly accros the stripes to allow for recovery ,so it can potentially...

this is a really good source...there's a brief paragraph on the one filegroup per disk and such:

http://www.sql-server-performance.com/articles/per/optimize_filegroup_performance_p2.aspx

ouch; i had a similar issue where a controller card went bad and was writing bad data for hours before the db was too corrupted to use, but I had...

I think the article complete skips over how the other 90% benefit after the 10% paid for the research and development of the software.

Take the Internet for example...it wasn't targeted...

here a snippet i saved for looping thru access tables from an application:

Set AccessCN = New ADODB.Connection

    AccessCN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Clients\someAccessDb.mdb;Persist Security Info=False"

    AccessCN.Open

    Set rs = New ADODB.Recordset

   ...

the way to do it is with the ALTER TABLE ALTER COLUMN command:

example:

create table test (testid int,testcol float);

exec sp_help test;

alter table test alter column testcol decimal;

exec sp_help test;

drop table test;

now...

a simple asp web page like this would work; change the connection info toyour page, put it somewhere on the web server and browse to that page:

<!DOCTYPE...

I'm betting it has to do with dynamic sql; also "Primary" should be in single, not double quotes, right?

if you add one of the many split function examples here on...

I'm confused about what you mean when you said "I go to my site, it asks me for a local user account"

Are you sure it's SQL server that is asking...

thanks for the correction Steve; i never get to play with replication, but I try to read about it here.

since this is db2 instead of sql, does that mean the  idsdemo.FFIITMAP is not databasename.tablename? so the tablename has a period in it? ie [idsdemo.FFIITMAP]

if that's true, then we'd just...