Database

ProjectId  ParentProject  ProjectName
1          0              X
2          1              Y
3          2              Z
4          3              W

SELECT PROJECTID,PROJECTNAME

FROM PROJECT 

WHERE PROJECTID = (	SELECT P1.PARENTPROJECTID + 1 
		FROM PROJECT P1
		INNER JOIN PROJECT P2
		ON P2.PROJECTID - <code>4</code>  = P1.PARENTPROJECTID ) 

Select @parentid=parentid from tablename where projectid=4

if(@parentid<>0)
Begin
WHILE (@PARENTID <> 0 )
 BEGIN



   Select @parentid=parentid from tablename where projectid=@parentid


if(@parentid is null)
    break
set @id=@parentid
  End 
   End 

if(@parentid is null)
    break

Nick Jacobs wrote:

Ok, so what setting did I change?

Mycroft Holmes wrote:

Bloody hell Nick how are we supposed to guess that?

SeMartens wrote:

And what is your concrete problem? Reading from the database? Setting the text? Please be more specific

Sharma Dinesh Kumar wrote:

i Want To search fuzzy word search using where clause in sql server 2005
Thank u

I are troll

prubyholl wrote:

Plz i want the accounts and customers details to appear even if no transactions exists.

SELECT * 
FROM dbo.tblRecords
WHERE [Key] = CAST(RAND()*10 AS INT)

Category

ID  Code
--  ----
1   1.1.1
2   2.2.2
etc

BudgetLine

CategoryCode  SubCode
------------  -------
1             1        (gives 1.1.1.1)
1             2        (gives 1.1.1.2)
2             1        (gives 2.2.2.1)
2             2        (gives 2.2.2.2)

ID  Code   ParentID
--  ----   --------
1   1      NULL
2   1      1        (gives 1.1)
3   1      2        (gives 1.1.1)
3   2      2        (gives 1.1.2)

Table: ACC_GROUP
Id  Parent  Desc
1   NULL    Assets
2   1       Current Assets
3   2       Cash on Hand


Table: ACC
Id Group Number Name
1  3     1-1110 Checking Account
2  3     1-1120 Payroll Account
3  2     1-1300 Deposits Paid