Hi Guys,

Thank you for your contribution guys. My sister's doing oracle pl/sql so i thought SQL Servercentral Gurus could be of help. I've advised her to post it in an...

hi paul i did:

Create procedure QuestionSelector(@QuizID int)

As

Select statements.

Then i exec QuestionSelector @QuizID = 1; and its working thanks alot. I appreciate your patience and i'm really grateful

Hi paul,

I totally apologize for the troubles, as it is i'm still mastering T/SQL programming. I just executed the questionSelector procedure and i got this error:

Msg 8146, Level 16, State...

Hi Paul White, here are my schemas:

/*To create Question Table */

create Table Question(

QuestionID int not null

,Title varchar(max) not null

,Answer1 varchar(max) not null

,Answer2 varchar(max) not null

,Answer3 varchar(max) not null

,Answer4 varchar(max) not...

I tried, its not giving me any errors. But its not fetching any data from the Question Table. The dbo.Question has already being polpulated with data. When i run the...

Hi Paul white,

I've never come across iTVF. what does it mean?

Hi Jeff Moden, Hi Paul White.

I apologize if i provided insuffient information. That said, here's roughly what i want to achieve:

I have 4 tables in my database, one table is...

hi,

I created a Procedure and and placed the statements in the procedure....then i called it as a datasource and it worked. But its not yet working for my purpose yet.

the...

Hi SS,

You've being of immense help...i'll fix dat area...and let you know as sonn as i do. Once again tank u very much!

Hi,

lol...i know PL/SQL is the SQL dialect for oracle database and T-SQL is for microsoft server. I'm still a fresher! Can u tell me where to place the script you...

Hi,

Tanks alot for going to great length and writing this PL/SQL script. I'm still mastering Pl?QL.

You might have guessed i'm using Visual Studio 2008 and my Database resides on MS...

Hi SSCrazy,

i have a total of 50 questions for a particular test. so i tied:

SELECT Top(40) [QuestionID], [Title], [Answer1], [Answer2], [Answer3], [Answer4], [CorrectAnswer], [QuestionOrder] FROM [Question] WHERE ([QuizID] = @QuizID)...

Tanks for your reply. I droped the "," and i got a syntax error