Jason you are using C#.NET, right? why not take advantage of the typed data sets and the relations?

for example, In .NET i can add parent and child records to any...

As stated, there's a lot of concepts you don't seem to be able to grasp;

one of the ones that everyone mentioned that could help you turn this into a set...

if you sp_help YourProc name, what owner/schema is it? you get results like this?

sp_help sp_Test

Name Owner Type ...

...buth this random guy on the interwebz gave me the code to make this run faster ...what do you mean the numbers are off?...

I've been watching this one too...but the requirements scream "homework" to me, where the teacher wants you to use a specific set of...

the max value of the column, whether it's inserted by the identity() or not, is the max value of the data type...int, bigint, whatever type you decide.

an int is 2...

can't you just add to the WHERE statement to exclude items you don't want to include? like AND issqlrole = 0 or something?

yep Ninja's right; the key is the procedure usp_generate_purchase_order and the code you commented out ; whatever it is doing to a single set of parameters needs to be moved...

here it is, i think: Jeff Modens "Replace Multiple Spaces With One" Article[/url]

ok what i posted works for my sample data, but not all situations...but i swear it's a variation of that concept.

there is an easy way, but it does require nested replaces; it will remove any number of repeating chars with a single one.

I THINK this is how it works by...

you can use the row number function to do paging...is that what you are looking for?

is this a homework or...

what if you are in the office those two days?

do you have anything in place to track it when you ARE there?

(Is you making changes to the database behind my...

SQL 2008 R2 Express[/url]

there are like three different versions of sp_help_rev_login...one for 2000, and two others for 2005/2008 i believe.

you have to use the one specific to what you are exporting from.

this is...