MS SQL/Expert Profile

Average Ratings

• Knowledgeability 9.89
• Clarity of Response 9.94
• Politeness 9.94
• Response Time(hr) 87.1
• Response Time(hr, last 90 days) 4.4

• Number of Questions Today 0
• Max Questions to be Asked in a Day 5
• Total Questions (since joining AllExperts) 192
• Volunteer Since 2007-05-07
• Prestige Points 1090

Recent Reviews from Users

Read More Comments

Recent Answers from Jwalant Natvarlal Soneji

2011-09-07 Select Match Problem:

Hi Alp,    I think it should be better to design the table in a different way to handle such kind of information.    However, here is the SQL Query for given situation.  ########################  SELECT

2011-08-29 How to return an integer?:

Hi Alp,    Sorry for very late reply...    You may try the below query:  ############################  IF    (   SELECT COUNT(*)   FROM Customers   WHERE CustomerID = 3000   ) = 0  BEGIN   SELECT 0

2011-07-08 Access SQL question - Record with Email address:

Dear Ron,    There are multiple ways of achieving details of author according to email address.  You can write a query with DISTINCT clause on Email Address column or can also write query using MAX on

2011-05-19 Select the higest values:

Hi Alp,    My apologies for late reply!    The required result can be obtained using GROUP BY clause and MAX function.    Here's the sample query:  ######################  SELECT MAX(DealID), CustomerID

2011-05-19 Select the higest values:

Dear Alp,    You can use GROUP BY and MAX built-in functions to achieve the required result.    Here's a sample query.  ##############  SELECT DealID, MAX(CustomerID) as CustomerID  FROM Deals  GROUP BY