I'm a little confused on what you are doing, but table types are:

Type = System are system related tables, such as sysobjects, sysfiles and so forth.  They are internal system...

you have to understand how it is calculating the percision and scale for the result. 

your numbers have a percision of 14 scale of 10, so the resulting percision is...

try

declare

@test-2 NUMERIC(24,11)

declare

@test2 NUMERIC(24,

out of curiousity what are you using the second server for, the one you are logging shipping too?  You said for querying via excel, but you'd log ship every minute... ...

use the  new Included Columns for creating indexes in sql 2005, look in books online for more info

have you looked at

http://support.microsoft.com/kb/240853

Have you tried asking your san vendor?  Typically the vendor will say which option is better for the particular san and environment that you have.

I probably did not explain fully what I was trying to do.  So i'm not trying to put indexes or certain tables in certain files.  I want all data spread...

declare

@MyTable TABLE

(

[wait type]

varchar(150),

Requests

float,

[Wait...

What type of variable are you trying to get it into?  I would assume a table variable and if so, you just declare your table variable and then insert into...

I'm assuming you are using a OpenXML statement in your proc....  You have to be careful with that, if you try moving up the nodes with a (at least I...

I recently deployed an app that installs MSDE during the installation.  What a nightmare MSDE can be.  Most likely, your mdac was not installed properly.  You need to check your...

Ahhh, I see what you are saying.  I agree with Wayne, you really should put your sum in your UDf.  The interesting part is the error he is getting. 

'acctNo'...

Let me make sure i'm getting this right.

If you currently try it with say an account number of 1, it works.

But the problem is, when you try passing in

1

2

3

it doesn't...