how does the "with ties" work in this situation?  I've yet to ever find a need for that feature, but I am wondering if perhaps I've just found more difficult...

Just did.  The catch is, the stored proc in question doesn't return any result sets normally. I've also tried just referencing the record count as well. 

Create PROCEDURE q_test

AS

declare @e...

I'm using Delphi 7, SQL Server 7, and have raised 4 errors within a stored proc.  The Query analyzer shows them fine.  When I ask the ADO connection for the...

Something I have issues with in Databases is when things are hidden. And 2 areas this can easily happen are: Triggers and Constraints. Now Triggers are...

quote:

---

Another two cents on the lookup table issue: what always bugs me is the need to have so many lookup tables. ...

There are a number of ways this can be aproached. I prefer avoiding cursors when ever possible as I find they tend to consume a lot more time to...

This is probably asking too much, but can you do If/ELSE type conditionals? Is Computed fields a SQL 200 feature, or does version 7.0 also support it?

Well I have a case where I have 4 fields (which may be Null) and I want to create a computed total of them. (Nulls should be treated as 0)

Thanks!

Quentin

...

If the columns could possibly be Null, how would you handle this?