Thanks for the info Buxton. I will have to look into this. I did not even know this was possible.

What are you trying to accomplish?

You can use openrowset to write to a text file.

http://msdn2.microsoft.com/en-us/library/ms190312.aspx

If you need to export data to a text file, you can use the...

Todd,

I am not sure how this would work. This function is used...

You could do the same thing, but probably cast as big int, for the numeric SKUs.

The above will overflow if you have more than 7 digits to the left of your decimal. If this is the case you will have to go with more digits...

Use converT, like you mentioned.

CONVERT(NUMERIC(9,2),werksmassFM / (Sum_Lmenge.SumCol/ls.lmenge)* p_transpreis)

You WILL recieve an error if you use the group by method I posted because I did not know what your keys were. Because I didnt know I put...

Thanks for doing the leg work, as usual 🙂

If they're all the same on the big tables and the OUTER JOIN is the slowest on smaller tables, why would you...

Interesting, I did not know OVER() could be used in this context. Thanks for pointing this out Kathi.

For the numeric datatype anything with a percision up to 9, is 5 bytes.

More info http://msdn2.microsoft.com/en-us/library/ms187746.aspx

The small money data type consumes 4 bytes, while money consumes 8.

more info...

I would personally make a derived table with the sum and join it to the main query. If you use Jason's method, you will have to evaulate the subquery...

No, you cannot do that.

Change your set to a select, functions requre a select statement.

declare @str varchar(max)

SELECT @str = dbo.fnGetValue()

EXEC mySproc @str

Len does not count blank spaces. Make sure you are trimming your string. This is your poblem in a nutshell.

declare @var varchar(20)

set @var = 'adam haines '

select...

Yeah, selectivity is always a good place to start. At least you have identified your problem and can now concentrate on resolving it.