Thats the challenge that is faced at a conference there are always too many sessions that you want to attend. This means that if you have intro sessions they are...

What you are trying to do is to join to the NULL record if the other record doesn't exist. You can do this row on row comparision with SQL you...

There is no way I know of to hide ALL. Instead you have to limit the number of values passed to the SP.

I answered this earlier in the thread

You...

Is there a reason you can't post to the forums yourself.

As for your solution it is not the same functionally. Whats more I think you looked at the wrong proposed...

You can limit to 5 by having a second parameter that is based on the first.

Set the query to use the second parameter and set the default value for the...

This is very dangerous as it allows SQL Injection, and as parameters can be passed by URL this is very very risky.

Using a split function is the safer option.

You don't have to change the XML, when RS passes the parameter it automatically converts the array of selected items to a comma delimited list.

Its all about how the columns in the with are matched when you don't specify an xpath literal i.e

with (name varchar(100)

,age int)

With...

Its a real shame the script component doesn't expose a columns collection for the Row object. That way you could iterate over the columns very easily and not have to...

I just wish this discussion was on the same page as the article. That way anyone reading the article can clearly see the comments about what is wrong and thus...

Further to the comments about in memory structures which are just a big confusion. Any data written to a table will reside in the data cache(memory) as long as it...

If you are mapping locations on the earth you need to use the geography type with the approriate Spatial Reference. This will allow for the curve of the earth. If...

Un like sql 2000 FTS on SQL 2005 is a much more capable beast, but that also means it is much more capable of taking all the resources. You need...

Thats why SQL 2005 has 2 new isolation levels to allow for readers to read consistent committed data unblocked.

I agree this is a great discussion. I never said I was against using NOLOCK rather the article does make the reader aware enough about what NOLOCK actually means to...