ya it was working fine

but why u and jef told don't use cursor

CREATE FUNCTION [dbo].[Split](@String varchar(8000), @Delimiter char(1))

returns @temptable TABLE (items varchar(8000))

as

begin

declare @idx int

...

alter PROCEDURE [dbo].[SP_Searchengine]

@VALUES varchar(8000)

AS

BEGIN

create table solution

(

AdSpaceId int,

AdInfoId int,

BusinessName varchar(200),

AdSpaceName ...

Thanks,

Jared

SQL Know-It-All for u job s for me and i inform u solved this problem by using...

thanks for every one who joined in this discussion i just solved this problem by creating cusor in my store procedure

no i don't nead join query

iam just using that value one by one for searching

a name in a another table iam using like %+@value+%

sorry one question but we can have loop it also possible or not in sql server

http://www.sqlservercentral.com/Forums/Topic1267085-391-1.aspx

iam not getting proper loop structure thats why i posted two three post

and sorry for your inconvience

how it will work please tell me

i execute ur store procedure like this

EXEC [dbo].[CategoryName]

@VALUES = N'the sep'

in execution i used two words the and sep

i know there...

how to use this

Full-Text Search (SQL Server)

in my select query

iam not getting the point in reading this related article

Select *

from tblAdSpace s

join tblMembers m on m.MemberId=s.MemberId

join tblAdInfo i on s.AdSpaceId=i.AdSpaceId

join tblAdBlock b on s.AdSpaceId=b.AdSpaceId

join tblAdContactInfo INF ON INF.AdInfoId=i .AdInfoId

join tblApplicableCategories ACS ON ACS.AdInfoId=...

i used that inside my store proc but iam not getting clear output

alter PROCEDURE [dbo].[SP_InsertGrabberDetails1]

(

--@TotalBlocks ...