Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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 Posted / chinnu


Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user ..

Answer / bru medishetty

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 ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

How to verify the port number of the sql server?

0 Answers  

Does hive support indexing?

0 Answers  

Which institute is best for SQL Server 2005 Training?

6 Answers  

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

Explain the various types of concurrency problem?

0 Answers  

Explain hostprotectionattribute in sql server 2005?

0 Answers  

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

What is Cross Join

3 Answers  

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

What is right outer join in sql server joins?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories