Delete Multiple rows 2

[dembyg]

I created a store procedure that should delete mulitple rows however it is not working.. can anyone help me.


************* Start of code
EXEC('SELECT * FROM tblqaCorrespdence WHERE iIndex IN (' + @tmpIndex + ')')


************* End of code
These are the values that need to pass - Execute spTest(1,2,4,6,7)

 

[SQLDenis]

replace exec with print and post code here

print('SELECT * FROM tblqaCorrespdence WHERE iIndex IN (' + @tmpIndex + ')')


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jgpasko]

************* Start of code
EXEC('SELECT * FROM tblqaCorrespdence WHERE iIndex IN (' + @tmpIndex + ')')


************* End of code
These are the values that need to pass - Execute spTest(1,2,4,6,7)

Shouldn't the SELECT be a DELETE?

John Pasko
"No matter where you go, there you are." -- Buckaroo Bonzai

 

[SQLDenis]

lol didn't even notice the missing DELETE, damn where is my coca cola

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jgpasko]

Dennis,

heh, I use a SB Triple Espresso IV Drip.

John Pasko
"No matter where you go, there you are." -- Buckaroo Bonzai

 

[SQLSister]

Hey Dennis, congrats on being the Tipmaster of the week. Well deserved!

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[dembyg]

OPPs i forgot to change my select to delete thanks... However it still does not work when running the code in Query analizer i recieve an error message ---Line 1: Incorrect syntax near 'number'.

 

[SQLDenis]

SQLSister ,
thanks

dembyg, can you post the print out


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[dembyg]

After running the following code in Query Analizer
PRINT('Delete * FROM tblqaCorrespdence WHERE iIndex IN (' + 74 + ')')

I recieve the following error..

Syntax error converting the varchar value 'Delete * FROM tblqaCorrespdence WHERE iIndex IN (' to a column of data type int.

 

[SQLDenis]

print('SELECT * FROM tblqaCorrespdence WHERE iIndex IN (' + convert(varchar,@tmpIndex) + ')')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[dembyg]

Thanks the code you wrote works however i need to delete multiple rows example ---
print('SELECT * FROM tblqaCorrespdence WHERE iIndex IN (' + convert(varchar,11,12,13) + ')')
addition tmpindex data type equals int instead of varchar...
Thank you for your assistance

 

[SQLDenis]

This is what you want
declare @tmpIndex varchar(50)
select @tmpIndex = '12,13,14'
print(DELETE tblqaCorrespdence WHERE iIndex IN (' + @tmpIndex + ')')

I don't know how tmpIndex can be an int in our case since it has multiple values

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/