just wrap the servername in brackets, the same way you do with TSQL reserved words:

Data Source=SQLSRVDEVNSMAIN;Database=pubs;Trusted_Connection=True;";

string connectionString =

"Data Source=[HENRY-PC\SQLSRVDEVNSMAIN];Database=pubs;Trusted_Connection=True;";

you could also switch to an ip\instance, or an ip port, which...

i think something like this might help you build what you are after?:

results:

Years Months Days ...

as i understand it, you should do this in two places;

you can make your server require encryption from everything connecting,a dnt he native client will handle it automatically:

SQL Server Configuration...

maybe something like this will help you model your calculation?

SELECT

SUM(

CASE WHEN property = 'prop1' THEN 1 ELSE 0 END

+ CASE WHEN property =...

i think this is what you are after;

the "description" field must be like the NAME, and the NAME must be like your search parameter:

so the "description" must be like '%WASH...

Tammy from what you describe, the CASE statement is working as it is supposed to, but not the way you want it to.

a case statement executes the first TRUE condition...

ha; Ramesh and i came up with identical solutions;

jordan i think this example might help;

i'm using the power of set based operations and the row_nubmer() function to generate the needed values;

check out the SELECT statem3ent...if you run it...

here you go;

this is using the FOR XML trick to concat your values together:

create table #temp

(

offerid int

, Catg varchar(100)

)

insert into #temp( offerid, Catg )

select 1, 'health' union all

select 1, 'fitness'...

they linked server syntax you used is a bit different from what I typically use; i'm posting it here for reference;

also, just a confirmation, your server is not 64 bit...

tendayit thanks for posting everything we might need to analyze it; it's so large, it'd take a lot to look at it all;

your functions 2200+lines ,and it's all doing...

imtiazm (2/4/2010)

---

This is the reply i get

...

File activation failure. The physical file name "f:\XXX.ldf" may be incorrect.

File activation failure. The physical file name "f:\XXX.ldf" may be incorrect.

The log cannot be...

the right thing to do is to go tell your other admins to not fiddle with your development server. Going behind their back and trying to lock them out is...

Rup you might want to check for other iterations based on html differences; for examples spaces before/after the equals sign just to be sure;

i'm glad this worked for you.

--original:

set @pre...

Ruprecht I'm halfway there from a sinlge command solution, but i wanted to post an immedite fix right away; if this is a one-time solution, this would give you everything...