Bust out scripted TVFs

[nycdotnet]

First practical feature should be the ability to bust out scripted Table Valued Functions.

For example, given this function

CREATE FUNCTION dbo.MyFunction ( @Something INT)
RETURNS @Results TABLE (
    Col1 CHAR(8) PRIMARY KEY, Col2 INT NOT NULL
)
AS BEGIN
    INSERT INTO @Results VALUES ('ABCDEFGH',100);
    RETURN
END

The parser should be able to bust it out to this:

DECLARE @Something INT
DECLARE @Results TABLE (
    Col1 CHAR(8) PRIMARY KEY, Col2 INT NOT NULL
)

INSERT INTO @Results VALUES ('ABCDEFGH',100);
SELECT * FROM @Results