ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Hi SQL gurus,

i am working for an MNC...

My team is having a problem in sql server. when user slects 
date prompts from jan 1st to april 30, it should display 
all months data like :

jan aa
feb bb
mar cc

but when it comes to april its taking data like :

jan aa
feb bb
mar cc
apr dd...and so on

means its taking data again from jan to april which we dont 
want. we want the data only april month as we are getting 
jan, feb and mar...

can any one write the code to relsove the issue please

would be greatful if you can send to shiva_sans@yahoo.co.in

and also please send your email also ...so that we will be 
in touch for any kind of queries ...


Thanks a lot in Advance !!!
 Question Submitted By :: Chinnu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!
Answer
# 1
A better way to get the query help is to post some 
technical information of your Table Structure, and the SQL 
code that you are executing, in which case it is helpful to 
answer quickly rather we guess how your table/code looks 
like.

My email is Bruhaspathy@hotmail.com

No Spamming and Chain emails Please. 

Thanks,
Bru Medishetty
www.LearnSQLWithBru.com
 
Is This Answer Correct ?    0 Yes 0 No
Bru Medishetty
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the appropriate number of test cases that you can write on a database? Microsoft1
How do you persist objects, permissions in tempdb  1
1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........  1
what is the diffrence between Snap Shot and Transaction Replication CSC1
what is cluster and nin-cluster index?  4
What is The Use Of TIMESTAMP DataType in SQL Server 2005?  3
Is it possible to delete duplicate rows in a table without using a temporary table ?  6
what is meant by deafult in sql server?  2
How to find the date and time of last updated table?  3
What types of integrity are enforced by a foreign-key constraint  1
What is the difference between DTS and SSIS? Allianz3
What is normalization and what are the different forms of normalizations?  1
one table has four field id,name,design,salary. i have to find maximum salary .  6
What is transaction ? Give me one example. Melstar7
How do I compare two values when one value(data type) is char and the other is an integer?  3
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))????? SAP-Labs2
What do you mean by COLLATION?  4
Explain sp_configure commands, set commands?  3
how can we use a composite key for two tables and how can we represent it BoA1
What is the use of MOVE keyword in restore command IBM2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com