Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Reporting Services - typical Microsoft

    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.

  • RE: Trim result in function

    Try changing

    Country CHAR(30)

    to

    Country VARCHAR(30)

  • RE: Format Output

    quote:


    Here's a function patterned after the UNIX fold utility

    
    
    CREATE FUNCTION Fold (
    @pMaxWidthsmallint,
    @pStringvarchar(7800)
    )
    RETURNS varchar(8000)

    BEGIN

    DECLARE...

  • RE: Selecting x number of rows within group

    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

    ...

Viewing 4 posts - 1 through 4 (of 4 total)