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 / 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 |
What the class forname () does?
what is for foreign key ??
4 Answers CarrizalSoft Technologies, Sabic,
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Where are sql server usernames and passwords stored in the sql server?
What is the use of custom fields in report?
Does the order of columns in update statements matter?
What are the grouping functions?
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..
17 Answers 3i Infotech, Rolta, TCS,
What is the order in which the SQL query is executed? list them in order.
5 Answers CarrizalSoft Technologies, CTS, Oracle,
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Explain the collation?
What is the use of “join” in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)