Check out the article here. The _ character is what is causing you problems. This should explain how to deal with it.

Yes, yes we are. On that note, if we are going to Roy's house let's just skip the watermelon and casserole and head straight for copious amounts of liquor. 😛

instead of "datalength(ns.ID_Note) -1" you should take a look at the reverse and charindex functions. Basically you can reverse your string and get the index of the first ".". The...

Without a doubt they both taste better raw than cooked.

Something like this should do it. Notice how i included the create table and insert scripts.

create table NodeSample

(

ID int identity not null,

ID_Parent int null,

Title varchar(20) null,

ID_Note varchar(20) null

)

go

insert NodeSample...

You need to take out the address column if you don't want it.

select distinct name from ....

You just can't get a distinct column. You are trying to get distinct...

So don't select that column.

select distinct [whatever columns you want]

add distinct to your query. simple as that.

Don't know what you mean by in the image...our network filter says it is a sex site.

for the query I don't quite understand why you need a subquery.

select DISPLAY_NAME, COUNT(DISPLAY_NAME)

from...

I don't about anybody else but that doesn't really explain what you are trying to do. What makes one of those records a child of another? Is there some sort...

Just my opinion but that sounds like a system requirement flaw and not a coding problem. Passwords should be stored encrypted and not retrievable. There should be a mechanism in...

I think you may find you have lots of data structure issues. All your columns are declared as nvarchar. This means they can't hold more than 1 character. Also do...

Not really sure what the RollNo table has to do with this...

I think this is what you are looking for.

select p.*

from Papers p

left join papers p2 on p.PaperID =...

Maybe with some table definitions, scripts to generate test data and clear rules about what you are looking for you might get some help. Given the unclear tables, lack of...