search query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

search query

Author

Topic

esambath
Yak Posting Veteran

89 Posts

Posted - 2009-06-26 : 08:35:26

Hi Experts

I have 5 tables
LP_Usermanagement,LP_Rating,LP_Country,LP_Expertation,LP_Category

LP_Usermanagement

UserId Nicname
3 dhina
4 esambath
5 kathi
6 salam
7 sambath1
8 xcvbn
LP_Rating

RatingId UserId ExpertId comments points
1 2 3 good 5
2 1 89 good 4
3 35 115 its realy very good nice communication 0

LP_Country

CountryId Name Code
1 INDIA IN
2 india IN
3 India IND

LP_Expertation

ExpertId UserId CatId LanguageId Experience Keywords
1 3 1 1 1year B.Tech
2 4 1 1 2year MCA
3 5 1 1 3year MBA
4 6 1 1 4year B.Tech
5 7 1 1 5year B.Tech
6 8 1 1 6year B.Tech

LP_Category

CatId Name
1 sports

We have search the columns for
output [LP_Usermanagement]Nickname,category Name

input
[LP_Usermanagement]Nickname,[LP_Category]Name,,[LP_Expertation]Keywords,[LP_Expertation]Experience

this is my test query

select * from LP_Rating
select U.*,E.*,isnull(R.Points,0) as Points
From LP_Usermanagement U left join LP_Rating R
ON U.UserId=R.ExpertId inner join LP_Country Ct
ON U.CountryId=Ct.CountryId inner join LP_Expertation E
ON E.UserId=U.UserId inner join LP_Category C
ON C.CatId=E.CatId where U.deleted=0 OR U.Nickname Like '%B.Tech%'
OR C.Name Like '%B.Tech%'OR E.Keywords Like '%B.Tech%'
OR E.Experience Like '%B.Tech%'OR Ct.Name Like '%B.Tech%'

thanks an advance

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-26 : 09:05:11

Sorry, but I can't find the sixty-four-dollar question...

No, you're never too old to Yak'n'Roll if you're too young to die.

esambath
Yak Posting Veteran

89 Posts

Posted - 2009-06-26 : 10:09:54

Hi webfred,

I don't understand your question Please help this concern

Thanks an advance

quote:
Originally posted by webfred

Sorry, but I can't find the sixty-four-dollar question...

No, you're never too old to Yak'n'Roll if you're too young to die.

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2009-06-26 : 10:30:50

He's asking you what the actual problem is / what you want to know.

It looks like you've just posted a lot of data and then a piece of sql without saying what's wrong with it or what you want to get out at the end.

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-06-26 : 10:32:50

We don't know what your question is. Does you query not work? Do you want to see if there's a better way to write it? What results do you expect? etc.

Jim

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-26 : 10:43:20

quote:
Originally posted by esambath

Hi webfred,

I don't understand your question Please help this concern

Thanks an advance

quote:
Originally posted by webfred

Sorry, but I can't find the sixty-four-dollar question...

No, you're never too old to Yak'n'Roll if you're too young to die.

I am sorry for confusing you with my reply.
As Charlie and Jim already told I could not see whats the problem in your post.

Sorry again
Webfred

No, you're never too old to Yak'n'Roll if you're too young to die.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-06-26 : 12:00:42

Fred thinks and drinks in German, but is trying to post in English.

Perhaps if you drink in English, it would help?

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-26 : 12:10:40

Hello Don!
How can I drink in english?

But btw: I know about my poor english but until now I thought it was good enough to take part in posting here or am i wrong?

No, you're never too old to Yak'n'Roll if you're too young to die.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-06-26 : 12:27:59

your English is very understandable to someone who has English as a FIRST language. There may be a problem when it is not (but i cannot say, since English is my first [only] language).

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-06-26 : 12:37:26

Q:What do you call someone that speaks two languages?
A: Bilingual

Q:What do you call someone that speaks only one language?
A:American

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-26 : 12:39:52

OK - thank you for this.
Then the best way is to post only short statements without typing something like "sixty-four-dollar question".
But I cannot guarantee when I am drinking in German

No, you're never too old to Yak'n'Roll if you're too young to die.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-06-26 : 14:35:04

"sixty four dollar question" is part of the American lexicon. Has to do with VERY old time game shows on TV and Radio.
You are right, it would be better to say "W.T.F. is your question?"

Wish I was still drinking in German. There is NO real beer here...

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-26 : 16:48:31

NACH DEM DEUTSCHEN REINHEITSGEBOT IN DEUTSCHLAND GEBRAUT

und von Webfred getrunken...

No, you're never too old to Yak'n'Roll if you're too young to die.

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2009-06-27 : 03:44:28

Webfred. Your english is excellent. (much better than my german or itallian - which are the only other lanuages I speak (badly)). Definately *good enough*. Its shameful how few people in the UK can speak any other lanuage than English so I'm always impressed by the quality of a lot of posters English here where its not their first lanuage. Keep it up.

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-27 : 07:15:06

Oh I am very pleased to hear (read) that.
Thank you very much.

Fred

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources