this particular example is not a pure triangle as illustrated in your article. that's because the 'code' (account number) is used as the primary join article. so, the...

Kurt (2/12/2008)

---

The sql server throws an error for this query statement. That's normal, because full text indexing is not installed. It fails on the line create fulltext catalog and throws...

the create catalog should fail if full text indexing is not available. does the sql below run without error?

if (1 = 1)

begin

exec sp_fulltext_database 'enable'

...

are you certain the CREATE FULLTEXT CATALOG statement is not producing error?

you can enable full text indexing for the database even if full text search is not installed, but CREATE...

The problem is - this turns into a real dog of a query, and will have the tendency to blow out your tempDB, steal all of the RAM, etc......

i'm confused. assuming there's some column that can order the payments sequentially/chronologically, can't this be solved with a simple self join?

create table #z

( seq int not null, code char(2),...

you can re-install the trial, but the ticker will still be running from your original install. so you won't be able to get around the 180 day limit.

like i...

the CTE route is really cool since it calls itself. i only discovered that CTEs are really treated as "expressions" a few days ago so the self-referencing CTE in...

that's kind of fuzzy. if someone else is accessing it over the internet for training purposes, then it's obviously not being used only by you (the developer) for...

a (useful) recursive function uses it's calculation result as input to the recursive call. a recursive function is one technique to perform recursion, but not the only technique. ...

the technique doesn't use recursive calls (a process/method calling itself) but it does use recursion and can be considered recursive by defintion.

from dictionary.com:

re·cur·sive –adjective

1. pertaining to or using...

assuming parentid refers to an id in the same table (self join), you would have to do it with some sort of recursion. here's my suggestion:

create table #vehicles

( id...

but a view would making writing and understanding that query a lot easier.

quick and dirty, but you get the idea:

select * from (

select *, row_number() over (partition by Country order by Hits desc) as num

from tbCountryWebHits ) as z

where num <= 2

if...

WHERE r.stateid=(case when @StateID is null or @StateID='' then r.stateid else @StateID end)

and r.provid=(case when @provID is null or @provID='' then r.provid else @provID end)

and r.rID=(case when @ReqID is null...