Database

CREATE PROC sp_MyProc (@ItemID AS INT)
AS
BEGIN
   SELECT *
   FROM   myTable
   WHERE  ItemID=isNull(@ItemID,ItemID)
END

SELECT *
FROM   myTable
WHERE  @ItemID IS NULL OR ItemId = @ItemId

IF @ItemID IS NULL 
BEGIN
   SELECT * FROM myTable; 
END
ELSE
BEGIN
   DECLARE @like NVARCHAR(6) 
   SET @like = '%' + CAST(@ItemID AS NVARCHAR(5))
   SELECT * FROM MyTable WHERE ItemID LIKE %like; 
END

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.