Really the way you have is should return just fine.

-- This is where I had to break it out into two separate selects

...

John (2/4/2009)

---

I had to rename some things because this is code I'm working on for a client but here it is:

Working Code:

ALTER FUNCTION [dbo].[MyFunc] (

@MyId INT

)

RETURNS @t TABLE (

MyIDINT

,MySubIDINT

,MyNameVARCHAR(50)

,MyLevelINT

)

AS

BEGIN

DECLARE

@MySubIDINT

,@MyLevelINT

-- This...

OK,

Thanks.

you will have to post your code so someone can look at what you are describing.

I am not sure exactly what you're doing, but when in passive mode it is a lot easier to connect FTP.

Active mode means that the server that you are connecting...

You are doing right.

You are just missing a step.. "That is if you are wanting to view the new values in the query window in management studio"

-------------------------------------------------------------

DECLARE

@Var1 INT

,...

Thanks for the help...

I do not have any data in the table yet.

I see what you're saying.

I have found some info on working with percentages from

So what I can tell from...

Thanks,

Is the UnitPriceDiscount a percentage or a number ?

select 10 *((1.0)-4)* 6

or

select 10 *((1.0)-.25)* 6

I have really worked with that adventureworks database ever since MS released it a couple of years ago. And I model a great deal of my work after that wonderful...

I did not use this type of implementation; however, there had been a couple of times that i have thought back on the Northwind database where employees are also managers.

The...

I did a update from Microsoft yesterday and had to restart my machine after the update. When the machine restarted I got bombarded by emails from jobs that ran two...

Hi,

i was able to telnet with success to my smtp server.

What is AV?

Thank you...

So you are saying it is best to install sql server on the production machine and have another box with management studio installed to remotely manage sql server.

Ok, i...