thanks for letting me know, regarding upgrading the server unfortunatly it's not an option for me

I can't get this script to work on SQL server 2000, can you help? I get Invalid object name 'sys.objects'.

thanks for the info, much appreciated

I've been able to find the answer thanks to a work collegue. you use NextResult instead, I've posted a working example of the vb code below

Public...

I was wondering about something like that, but wasn't sure how to. but as I said earlier I've gone with the other way and it seems to be working ok....

Jeff, how do you mean normalised? I'm interested on your thoughts, although it's probably too late to change what I have now

Jeff, it's for a problem at work, I'm not the normal DBA hence my lack of any real knowledge, it's just something I play with. I built a toolkit in...

many thanks for your solution, I'll try this out when I get into work on Monday

Thanks, I did think along those lines but just couldn't seem to get it right

I've finally worked out how to do this in a stored procedure (posted below) the only problem I have is that when I pass in the two strings I'd like...

92 fields

Thanks Christopher, The only problem is at the moment there are 92 fields in the database and could grow, that's why I was thinking about using cursors. Is there...

I was right, it was a stupid mistake on my part. I forgot to use SET NOCOUNT ON

I've a sneaky feeling the SP is erroring before the final select statement, but I can't find out where, the stored procedure is as follows

CREATE PROCEDURE spGetareas_byName_and_Date @Name as varchar(100),@Date...

yes it does, that's why I was puzzled when it threw up errors in the vb code