Microsft needs to make this clearer. RS only needs the shell environment. So to develop reports for Reporting Services you only need to have VB.Net (~$99) and not VS .Net.

Try changing

Country CHAR(30)

to

Country VARCHAR(30)

quote:

---

Here's a function patterned after the UNIX fold utility

CREATE FUNCTION Fold (

@pMaxWidthsmallint,

@pStringvarchar(7800)

)

    RETURNS varchar(8000)



BEGIN



DECLARE...

Here's a working example using the Northwind DB:

USE Northwind

SELECT P.*

FROM Products P

WHERE P.ProductID IN ( SELECT TOP 2 G.ProductID

...