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

Name	Expertise	Status

Manoj Rajshekar View Profile	Anything on MSSQL Server 2005, 2000, 7.0 and 6.x. Anything on MYSQL,MSAccess, DB2 UDB Anything on Database Programming/Scripting.	Available Ask A Question View Past Answers
Jwalant Natvarlal Soneji Canada View Profile	I can answer questions in Hindi as well as English. Questions related to query optimization, finding complex results.	Available Ask A Question View Past Answers
Mohit Nayyar U.S. View Profile	Microsoft SQL Server: T-SQL development (stored procedures, triggers, functions), Database optimization, performance tuning, high availability (Clustering, Log Shipping, Mirroring, Replication), scalability, SQL Server migration (Sybase/Oracle to SQL Server 2005), SSIS/DTS, Data Warehousing (SSAS), Reporting Services, database modeling, database administration, Security implementation and typically anything related to Microsoft SQL Server.	Available Ask A Question View Past Answers

VOLUNTEER TO BE AN EXPERT IN THIS CATEGORY

Recent Answers

2008-08-22 SQL query to fetch duplicate data only: Dear Mrinmoy, Here you can use GROUP BY with COUNT to get the desired result. For example: ### SELECT batch_code, cusip, age, salary FROM Employee WHERE cusip IN (SELECT cusip FROM Employee WHERE...

2008-08-21 Query for fetching 2nd largest , 2nd lowest data: Dear Mrinmay, There will be (and are) several ways to get the same results. I will illustrate one of them here. I believe it would not be the best one but can be used for your both queries, with less...

2008-08-18 triggers: Hi Oliver I didn't understand your question completely, so please check my answer on some basic assumptions. You need to use COLUMNS_UPDATED or UPDATE() to check if the binary column has been updated/inserted...

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-08-14 Calculate 5 highest numbers: Dear Ola, The above given query should work for this purpose, but has to be modified according to your columns in result and in table. For example: #### SELECT TOP 5 Animal_Name, Animal_Weight...

Category: MS SQL	Sort By: