Two books spring to mind. Code-Centric: T-SQL Programming with Stored Procedures and Triggers by Garth Wells (Apress). A good basic and not so basic book, nice keyweord reference and a...

Antares is right. Have you posted the whole of the Stored Procedure code?

You'll need something like SET @GcoNewTotalQuote = ... somewhere in your code. Also just setting the output parameter...

This looks like a platform problem to me, but I'm no OS expert. What I do know is that if you execute DTS direct from a client then DTS will...

Interesting, there could be several answers to your question depending on what exactly you're tryin to do

Would it be possible for you to post up an example of the kind...

From your post I'm not sure of your context. NPeeters is right, however I'm wondering when you say 'controlling the execution' you're really talking about running the app' from within...

One other issue concerning performance, if you have to use a cursor then always try to declare it as FAST FORWARD. Basically this gives you an in memory read-only recordset...

Hi wsze. There are two main differences between a clustered and non-clustered index.

The first has to do with what the clustering actually does. It basically alters the default sort for...

Heres a simple query using northwind showing the form you need

SELECT productid, sum(quantity * unitprice) from [order details] GROUP BY productid

Here I've used the calculation of the columns quantity by...

Just like the old quote "Democracy is a bad form of Governement, but consider, the others are so much worse. MS gave us standardisation and firmly entrenched the culture of...

Hi Dalton

Not really a SQLServer issue but what the heck!. The url for your second page shows objRS("titulont") as the value in the query string pair tit=Contracting. I presume you're...

Just a thought. Would DTS be a better method for importing the text-file?

I have found it is possible to please all of the people all of the time if you...

You might like to try this url http://www.sqldts.com. An excllent site devoted solely to DTS. Last time I looked there was an article giving a step by step...

One other consideration I've found useful in deciding on choosing the approach is to think about maintenance. I have seen, and have been guilty of, creating fairly complex SQL structures...

You may well find in programming circles a client side cursor reffered to as a 'disconnected recordset'. One of the great advantages of client side for things like web apps...

You may well find in programming circles a client side cursor reffered to as a 'disconnected recordset'. One of the great advantages of client side for things like web apps...