Ryan-

I added the ID to the select statement and it works. Thank you for your assistance! 😀

update a set

Equipment = b.Equipment,

...

Ryan,

Thank you for your assistance. Mine was obviously extremely inefficient. I tried your solution and got the following error:

Invalid column name 'ID'

Both tables have an ID column so I am...

I followed the steps you indicated with the following results:

1. log in; status says sa(115)

2. run query by clicking the run query button; status says sa(115)

3. run query again pressing...

Thank you sir. What if the "Disconnect after query executes" option is not checked?

RBarry,

Thank you for the info. I failed to mention that I am using the SQL Query tool from SQL 2000 which does not have the options you mentioned.

I have it working in my stored proc. Your knowledge and this forum give me hope. Thank you all for your assistance. 😀

If I run the whole script it works fine; I was trying to step through it and Matt's assumption was correct. I did not highlight the update section with the...

Can someone explain the [Must declare the scalar variable "@PrevGrpBal"] error message?

The following section of Adam's script appears to declare the @PrevGrpBal variable:

--===== Declare the variables for the "Code...

You are correct Matt. I typed it in the message incorrectly; the error reads:

Must declare the scalar variable "@PrevGrpBal".

If I understand you correctly regarding populating the table, I would create...

Thank you all for the information.

Adam - I tried your code and received the following message:

Must declare the scalar variable "@PreGrpBal"

I am unsure how to resolve this.

Additionally, I do not...

Just to clarify, the loop w/o cursor did work fine with the exception of the initial blank line.

Thank you all for your suggestions.

Thanks for your help Noel. Perhaps I did not understand your response to my question, I tried the following approaches but was unable to make it work:

-------------------------------------------------

if object_id('cat') is not...

Very cool! Is it possible to create a line break between the columns? I have the following data:

Mark,

Here is how I solved it:

1. Database Menu

2. Set Datasource location option

3. set the datasource to the same stored proc

4. Crystal Prompts for the new parameter's value.

Thanks for your time.

Hi Mark,

I am unsure where the XSD file exists at. Is it like  a text file?