i go throughed the links Sean Lange

they are fine but i am not able to implement this kind of dynamic solution for my store procedure

so plz tell ...

i just alter some changes in the table

i just find the solution for skipped like this when the data was like this ...

can any plz try to solve my issue in the proc

reponse i made depend upon the collection key

for response ' 943B4955-BF16-4DC8-869F-9907DFC95AF7'

...

hi dragosgrigs i just made the solution like this and i used floor () to solve it floor (HEIGHT) and thanks alot for giving new...

hi

vinu512

thanks for the solution which u just posted for me

hi KcV

it was working good when count value is 0 and answer value is 0

but it make error when it was like this

DECLARE @counttable...

thanks ChrisM@home

it was working fine

can u plz give one simple example for that

in table @Response

in this table @Response the record id was caled two time

u will find column Response and record

...

percentage i made by calculating reponse for a question choiceid

id depend on this two table

@Response,@Responsechoice

related columns

Response

QuestionId

Choiceid

even my friend gave me a idea to do like this using a split function or DelimitedSplit8K function also

DECLARE @questionIdandchoiceid varchar(8000)='1-2,2-3,3-5'

DECLARE @question table(

...

thanks

Lynn Pettis,

ard5karthick

for sharing your knowledges and idea

here i table script and a sample data

@DATAS varchar(8000)='siva coffe shop orian super market '

insert into @

select*from dbo.Split(@DATAS,'')ds

declare @table table

(

...

hi

Steve Jones

i didnt created full text index in temporary table. i created full text index in the table Business

by following this link

http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/