I have a SQL Stored Procedure that validates a form. One section of the validation needs to verify a keyword(s) was selected. Depending on the users form there could be 3 to 25 keywords to confirm.
The idea is that @KEYWORDCATEGORY1 and @KEYWORDCATEGORY1_REQ need to increment to @KEYWORDCATEGORY2, @KEYWORDCATEGORY3 and @KEYWORDCATEGORY2_REQ, @KEYWORDCATEGORY3_REQ and so on.
I am asuming I can do this by concatenating a variable to @KEYWORDCATEGORY such as @KEYWORDCATEGORY3 + @VALUE or @KEYWORDCATEGORY+ @VALUE + '_REQ' where @VALUE woud start at 1. Can this be done?
/*VERIFY KEYWORDS*/
DECLARE KEYWORDS_CRSR CURSOR STATIC LOCAL FOR
SELECT
[KeywordId]
FROM
[dbo].[TableName]
WHERE
[User_Id] = @ID
OPEN KEYWORDS_CRSR
If @@CURSOR_ROWS > 0
BEGIN
FETCH NEXT FROM KEYWORDS_CRSR INTO
@KEYWORDCATEGORY1
WHILE @@FETCH_STATUS = 0
BEGIN
/*@KEYWORDCATEGORY1_REQ*/
IF @KEYWORDCATEGORY1_REQ = 1
BEGIN
IF @KEYWORDCATEGORY1 IS NULL
BEGIN
SET @ACCEPTED = 0
SET @RESPONSE = @RESPONSE + '-A Keyword for Category l must be selected.<br />'
END
END
FETCH NEXT FROM KEYWORDS_CRSR INTO
@KEYWORDCATEGORY1
END
but you could do this in a plain statement, without cursor, eventually.
can you clarify the data in the table, and what would the full output be?
thanks