Viewing 15 posts - 1 through 15 (of 484 total)
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...
July 27, 2010 at 8:03 am
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...
February 19, 2010 at 7:56 am
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
June 30, 2009 at 3:56 pm
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...
May 15, 2009 at 2:58 am
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...
April 21, 2009 at 7:50 am
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.
April 21, 2009 at 1:32 am
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.
April 21, 2009 at 1:29 am
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)
March 5, 2009 at 10:49 am
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...
January 3, 2009 at 8:42 am
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...
April 2, 2008 at 7:27 am
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...
April 2, 2008 at 3:09 am
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...
January 7, 2008 at 6:36 am
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...
March 8, 2007 at 4:13 pm
Thats why SQL 2005 has 2 new isolation levels to allow for readers to read consistent committed data unblocked.
January 30, 2007 at 3:42 pm
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...
January 30, 2007 at 10:37 am