thanks

Its a good idea, but i just have to display the data one by one. not allowed to be creative

it gets the next row id in the table. not the last.

The task im accomplishing is to get a quote from tbl_Todaysthought table.

say tbl_Todaysthought has 10 rows then after...

CREATE TABLE [tbl_TodaysThought] (

 [ThoughtID] [int] IDENTITY (1, 1) NOT NULL ,

 [Thought] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [Author] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 CONSTRAINT [PK_tbl_TodaysThought] PRIMARY KEY  CLUSTERED

 (

  [ThoughtID]

&nbsp

cool

thanks

I can't find " view designer in Enterprise Manager".

how do i access it?

My bad, i was looking at the wrong column in results. damn QA.

thought changed the inner join to left join for null cases.

thank your advices

how do i "extract the individual values one at a time from the parameter "?

can i get an example.

thanks

Declare a temp var and set it to owner.table name

DECLARE @table varchar(64),

@sql varchar(150),

@owner varchar(20),

@temp varchar(90)

DECLARE curTable SCROLL CURSOR FOR SELECT name FROM sysobjects WHERE Type = 'U'  And Name...

Noel that doesn't help.

Is there a way to get the choices and their corresponding count?

thanks

Lowell:

select QuestionID, Answer, count(Answer) as CountOfAnswer, count(QuestionID) as CountOfQuestions,

convert(money,count(Answer)/count(QuestionID))  as PercentOfQuestions

from tblSurvey2_Answers where QuestionID in(select QuestionID from  tblSurvey2_questions where QuestionID

in(select QuestionID where AnswerType in ('radio', 'checkbox')) )group by QuestionID,...