Manoj Rajshekar - MS SQL - Databases - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Databases > MS SQL

Expert Profile: Manoj Rajshekar

Expertise: Anything on MSSQL Server 2005, 2000, 7.0 and 6.x. Anything on MYSQL,MSAccess, DB2 UDB Anything on Database Programming/Scripting.

Ask a Question	View Past Answers	View Ratings

Average Ratings
Prestige Points: 6518
Knowledge	9.70 Best of the best
Clarity of Response	9.70 Best of the best
Timeliness	9.66 Best of the best
Politeness	9.90 Best of the best
Number Of Questions (in Past 24 Hours)		0
Max Questions to be Asked (in 24 Hour period)		3
Total Questions (since joining AllExperts)		432

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
10	10	10	10	09/26/08
10	10	10	10	09/26/08
10	10	10	10	09/11/08
10	10	10	10	04/17/08
10	10	10	10	04/03/08

User Comments

Thanks for the kind reply, I will give a try and revert back
(Hemalatha on 09/26/08)

many thanks excellent as ever
(Oliver on 09/26/08)

Thanks for the reply
(hemalatha on 04/17/08)

Thanks a lot Manoj for your excellent answer. Willy
(willy on 04/03/08)

View All Comments

Ask a Question	View Past Answers	View Ratings

Recent Answers from Manoj Rajshekar

2008-08-16 SQL Query: Hi Ola, SELECT C.CustomerName, C.PhoneNo, P.PetName, P.DOB, P.Gender, Group1 = CASE WHEN (SELECT SUM(Weight) FROM Pets P WHERE C.CustomerNo = P.CustomerNo) > '2KG' THEN 'WEIGHTY' WHEN (SELECT...

2008-07-16 concatenation: Hi Ohad, You would not be able to achieve this using your select statement, since your data is stored row-wise. To achieve what you are looking for, you are better off creating a temporary table with...

2008-05-14 SQL query to extract records with specific values in two columns: Hi Sandi, To check only this, please remove all joins and select only from this table only for that condition. It will and should work. After that you could change the query to include other tables...

2007-11-05 query help: Hi Safwat, You could do this in SQL server only if you have some column which is serialized, like an identity column. In this case, you could do programatically by selecting the top 10 in the query...

2007-10-23 MSSQL Server 2005: Hi Rajiv, Please use SQL Server Integration Services to move data from oracle to SQL Server 2005. In the earlier version it was known as DTS. The other method would be to migrate your oracle data...