@myvar varchar(7999) --!! What made you think you could have a text parameter?

LIKE '%' + @myvar

or

LIKE '%' + @myvar + '%'

depending on what you want

You need to carry the RootIDs through the recursion. Something like:

DECLARE @t TABLE

(

        TableID int NOT NULL PRIMARY KEY

        ,TableName varchar(20) NOT NULL

        ,ParentID int NULL

)

INSERT INTO @t

SELECT 1, 'PropertyGroup', NULL UNION ALL

SELECT...

I also have difficulty getting my head around this type of query.

The following may not be correct but seems to work on the data provided. There are probably better solutions.

DECLARE @t...

Maybe I am missing something, but to get results older than 2 days don't all these queries need a < instead of a >?

As you only want the totals for each row the query is, as Colin indicated, quite straigtht forward.

(Although it would be better if you normalized the table!)

Try:

SELECT distribuorid, selection1, selection2,...

The following links may help:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=340622

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=335798#bm336118

Your question is somewhat confusing. It would help if you could give some sample data and the expected results.

Try declaring variables @WavPos and @MP3Pos and then replacing:

IF SUBSTRING(@ProductDescription, @EndPos + 2, 3) = @FileFormat

        SET @valid = 1

IF (len(@ProductDescription) - @StartPos) > 19

        IF SUBSTRING(@ProductDescription, @EndPos + 19, 3) =...

This should take into account your extra data:

SELECT YourCol

FROM YourTable

ORDER BY

        LEFT(YourCol, PATINDEX('%[0-9]%', YourCol) - 1)

        ,CAST(SUBSTRING(YourCol, PATINDEX('%[0-9]%', YourCol), 3) AS int)

Try something like:

SELECT YourCol

FROM YourTable

ORDER BY

        LEFT(YourCol, 2)

        ,CAST(SUBSTRING(YourCol, 3, 3) AS int)

If you only have two dates per month, something like the following should work:

SELECT T1.[Date]

        ,T1.Value - T2.Value AS Value

FROM YourTable T1

        JOIN YourTable T2

                ON T2.[Date] < T1.[Date]

                         AND YEAR(T1.[Date]) = YEAR(T2.[Date])

                         AND MONTH(T1.[Date])...

The lack of test data and results, along with the mix of old and new style join syntax, makes it difficult to guess what is going on here. I suspect...

SELECT *

FROM YourTable

ORDER BY

        CASE Code

        WHEN 1 THEN 'ZZZZZ' -- larger than MAX(ACCT)

        ELSE Acct

        END

        ,Amount DESC

February 10, 2007 at 7:09 am