Lynn,

Your suggestion is interesting.

I had never used SAVEPOINT before.

For beginers though, this is more rope to hang themselves with ...

We are truly entering territory for the brave.

Yup !

If Tran_2 is within Tran_1, then rolling back Tran_1 also rolls back Tran_2 even though Tran_2 has been committed.

This is the whole concept of @@TRANCOUNT.

The report may have to sort through 5 million records but just to find...

JacekO

Thanks for you response.

I was talking about using the bcp utility, accessing the file system, generating Excel spreadsheet.

Yes, this was in SS2K, not SS2K5 of course -- now less and less appropriate to...

JacekO

Is the OUTPUT parameter better than using a return value ?

Of course if you need more than one value, then this is not readily doable with a single-valued return...

I agree with the suggestions made.

For instance, I had this ridiculous instance where I was using Crystal Report version 8 to generate the TOP 10 most popular items from an...

Steve Jones - Editor (3/12/2009)

---

I would recommend you try to get by without it. If you have questions about a specific thing you are planning, please start a new thread...

JackedO

Agrred.

I have this one case when closing a work order to assemble and deliver merchandise to a customer. The stored proc creates one invoice per store in the chain.

IF a...

You should also have a look at a related issue:

How do I secure a SQL Server extended stored procedure?

Written By: Edgewood Solutions Engineers -- 9/14/2006

http://www.mssqltips.com/tip.asp?tip=961

Regards

-> JacekO

3. There is an issue realted to passing the data between ths SPs. Remember whenever you use OUTPUT parameter to retrieve a piece of information from the called...

Beginners should be aware that the examples given above are just for illustrative purposes.

There is no point in encapsulating a single UPDATE statement alone in a transaction. The UPDATE statement...

GilaMonster (3/11/2009)

---

Personally, I don't use the...

Bob Hovious (3/11/2009)

---

As long as there is going to be carnage, would you also add to the victims' list the names of those who say "Choose your answer", instead of...

Ach soooo ...

How about next time YOU have to debug SQL statments embedded in the application code. The genius could not code it like

SELECT Customer_Name, Customer_Code, Customer_Alias FROM Customer

Of course...