That simple! Thank you Noel!

The value of ID also needs to be included because the result set is used in another statement and ID needs to be processed too. Is there any way that...

My table has two ID columns, ID and PID. What I want to do is to return all PIDs where the ID is lets say 10. This will produce a...

Thanks Frank

Thank you all for your feed back

Thanks David, I shall try that now

I searched all local drives on the database server for *.bak files created or modified on the date that the database had apparently last backed up and found nothing so...

Hi,

Unfortunately, the number of elements within the array will be different each time so it needs to be dynamic.

Thanks Frank

Having successfully run the code in QA, I tried to run the unamended stored procedure and it too works now! Could it have been some sort of security issue on...

Apologies, the code is 'IS NULL' not '= NULL'.

David

I am really confused now! When I copied the code to QA and executed it the table was populated? So for whatever reason, the code does not work when executed...

I reversed the procedure so that I returned one row of data and read the values into variables that I declared using the exact datatypes and lengths of the columns...

Hi Wayne,

Oddly enough, I restricted the SELECT statement to one row and attempted to manually add the data that was returned. I found that manually entering the data into the table...

Thanks everyone, I won't be able to check the suggestions right now because I don't have access to SQL Server today but there are enough suggestions there to ensure that...