Hi Chris,

Right now i want to keep this idea as the last option.currently i am seeing if full text index works for me .. Any suggestion how can i accomplish...

I dont have any rules in between .. It was as similar to URLName like URLExclusionName( because the URLExclusionName already starts with % and ends with %). There was nothing...

Thinking of the same requirement.,i am using URLS to search so my base URL will be something like http:\\www.google.com . I have another table which contains the keywords or like...

Here is the sample data

%://llnw-1083.listen.com/6%.rad%

%://fe5357.sidestep.com/servlet6/%

%://cdn-62.blinkx.com/stream/%.flv%

%://genio.virgilio.it/scripts/alice/ifr_virg_comu_genio_cachebust.js_728x90_rmt931648.html%

%://download462.mediafire.com%

%://www.asus.com.au/websites/au/xml/localization.xml%

%://msnvideoar.vo.llnwd.net/d1/stupidvideos/dog_taps_paw_in_time.flv%

%://www.princes-trust.org.uk/crossdomain.xml%

%://www.shockwave.com/content/sol_addiction/sis/addict.dat%

%://quality-s.qvc.comquality-s.qvc.com%

I understand the URLName starts with % and indexes wont work when it finds %. thus why i am thinking to use FullText Indexes but not...

Hi Eugine,

Yes,they are URL Names .i cant seggregate them with some criteria.. What i was thinking among these three approaches

1) First use Exists clause and update the ExclusionID with 0...

Hi Chris,

Nice to hear from you.. I am have gone through couple of articles posted by you. This requirement is unavoidable to use like operator. Finally i got ready to...

There are 5 million records in person table and 4 million in person exclude table

We are trying in different ways but couldn't find a convincing solution. please suggest what can...

(On behalf of santosh)

Hi

We understand the join from left side is returning more records. so we have a slight change in our requirement to return first record matched

Supppose in above...

Hi,

I want to use this SCOM. i just want to know where can i find it .where is this application residing in vista. do i need to install it

Thanks

Raj Deep.A

I Understand your requirement,Can you please send me the sample matrix you are showing now.

As i understood,you dont want to disturb the present matrix,but you want to add another columns...

It Works.Thank you very much David

Regards

Raj Deep.A

Actually,

I typed the matrix manually to show the matrix.there is no problem ,i am able to see the values if they are null and Zero.It was Ok as i...

Hi ,

I Understand your posting but i need some more information to solve your problem

This Scenario is enough for how the report should look like But it is not enough...

Hey,

Try this

=IIF(Fields!Sales.Value0,Fields!Margin.Value)/ IIF(Max(Fields!Sales.Value)=0,1,Max(Fields!Sales.Value))," ")

Regards

Raj Deep.A

Actually it the multiple parametres in Sql Server 2005.Instead try to create some procedure like this in Database

CREATE FUNCTION dbo.Split

(

@ItemList NVARCHAR(4000),

@delimiter CHAR(1)

)

RETURNS @IDTable TABLE (Item VARCHAR(50))

AS ...