i swear i tried that! cant have though because it works fine, thanks!

Thanks Wayne,

I have one problem with this approach, i', trying to make my Xquery selection alongside other standard sql column selections and this doesnt work with your solution. i will...

Thankyou very much, i think i was trying to over complicate things, that works a treat.

Regards

Thanks thats a great help

Sorry stupid question, i did it, just needed to put

Declare @i int

Declare @j-2 int

exec sp_CountAudioFiles @i out, @j-2 out

Print @i

print @j-2

Thanks

It's ok now, I have it working, The Order By was breaking the SP.

Thanks for the help

Dave

Sorry to be a pain, but the code does not work, it says 'Invalid Column name ID' I should have made this clearer. For testing purposes i have not implmented...

Thanks for the reply, The code you have provided me with only returns the first Select statement so when it is run the only thing that appears is  <AudioScriptXML>. I...

Hi All, I have looked at this discussion for an answer to a problem i have with Stored Procedures and returning XML. I have particularly tried ti implment what Kreynolds...

That great thanks

Hi All, Just wanted to say thankyou for all the help with this problem. I now have a working solution. The code is below for you reference/interest.

Regards, Dave

The stored Procedure...

Sorry, forgot the new code

Dim SQLReturnString As String

Dim param1 As New...

Hi, I have chnaged this to the following to make it compile, however, There is value in the Return Parameter apart from '''. This Stored Procedure is now working in...

Hi this works and builds a concatonated list of 1's and 0's whcih is what i want. But it only ever shows 3, 1's...

tHANKYOU