Thank u this code worked great but i want to be able to put this into a store procdure

i want to have the user pass the glyear, glperiod and...

I forgot the table is created to hold individual sales so ever time an item is sold it created a new record i need to total up each stockcode

How do i call a public function

It sound like you need to set the logins on both servers to SQL Autherized not Windows

I Had the same problem I had to create a new user on...

I Logged in as a differnet User and i am still getting the error

how do i log on as a different user

How do i find out