The problem with the numbers table not out-performing the straight function has nothing to do with the actual numbes table; it is the CTE that is dragging it down. ...

Thanks SQLGuru. Proving it was not really the problem. I had no problem comming up with enough data to point my finger at the SAN. I was...

Dominic,

Your code works for me as well. I second looking at what Joel has suggested with your WHERE clause. Also, can you show us your call to...

sp_GetAppLock basically allows you to use SQL Servers locking space to serialize database object access. I think it has its uses but understanding SQL Server's default locking architecture when...

Colin,

You mentioned how telling the truth on SAN performance for DB servers tends to be going a bit against the grain and I'll agree. I've battled a bit...

Yep, pretty simple Peter. You'll need to prefix your columns with the appropriate alias as Sergiy is suggesting.

Wow, you guys were working late yesterday. Thanks for jumping in Sergiy. Steve (Stout), the example Sergiy gave you is exactly what I was describing. He was...

Can you post your code?

This is a very basic INSERT INTO...SELECT statement. You've already added in the column references into your INSERT INTO statement, you just need to add to the SELECT part...

Set based means that you are working on 'sets' of data instead of rows. Anytime you can apply logic or business rules accross a set of common data, you'll...

I think that you'll find the same problems in SQL Server 2005 as well. SQL Server is designed to work off sets of data. Row by row processing...

In this case, not by using a CHECK Constraint (that I know of). You are limited to using a trigger to validate your data or add the checking logic...

I would say that your answer is NO then. Check Constraints do not support the use of inline table valued functions.

What did SQL Server tell you when you tried?

Loner,

What is wrong with using a global variable to hold the output of T-SQL executed in the Execute SQL task? I do it all of the time. Isn't...