Yes, you're right about NULL. I just tried the use of a boolean bitUseDateSelection (which defaults to 0 unless both dates aren't NULL).

The result would be something like: SELECT * FROM...

Calvin, thanks for your reply. I did ignore the multi-tier aspect as you pointed out. But alas, developers would like an OO implementation, customers demand the best performance. And I'm caught...

Nice balanced article, Chris, although I am afraid that EB24 hoped for a more PRO-MS article to convince his superiors.

Which I am not qualified to provide. I use both as...

First of all, thank you for your suggestions.

Some solutions will not work. The prices are amongst others dependant op selected customer, products, various productspecifications, contents of package, and the package....

It is an OLTP app, and I used 150000 rows to demonstrate the difference in performance. Normally would be something like 1000 rows.

The calculation is quite complex (lots of percentages,...

I am referring to tools like Query Analyzer and Enterprise Manager. My company has a SQL Server Enterprise license, but I need the MSDE to distribute with an application to...

What are the consequences of using SET DATEFORMAT or SET LANGUAGE for Stored Procedures?

We noticed that using SET DATEFORMAT dmy; resulted in a decrease in performance, possibly due to recompilation...

When I started programming SQL Server stored procedures, I also did not use the autoincrement feature. So I created a stored procedure nextvalue which returned a new ID.

Everytime I...

NPeeters and EdVassie,

Thank you both for your remarks.

NPeeters, you solution was almost identical as ours in that it results in a Cartesian product. That was the problem I was asked...

Thank you for the illumination, Brokenrulz.

The use of the CASE statement is just what I needed.

Incidentally I needed the data from an undelying table, in my example [Order Details].UnitPrice....

Oops, forgot to mention that I determine @Id by means of the INSERTED table.

SELECT @Id = MyTableId FROM INSERTED

Gerry

Gentlemen, thanks again for some slick T-SQL.

So I can determine the column, but now I need to determine the value.

I can use something like:

SELECT @sql = 'SELECT...

Thank you both for your response.

The script of mccork combined with the explanation of teh general formula by a5xo3z1 has helped me a lot!

Gerry.

Thank you for your reply.

Apparently it can be done, but could you give a simple example? I don't kow how to use the bitmask variables.

Gerry.

quote:

---

One way is to search through SYSCOMMENTS ...

---

Jeremy,

Thanks for your quick solution. It was exactly...