How I Can Select Record From Database According To Month-Wise Not By Date Wise Means Whatever Date Is There In Database Select Reocrd By Month And Year Basis

Question

0.00/5 (No votes)

See more:

, +

i want to select record from database according to month-wise not by date wise means whatever date is there in database, i want to select data on basis of month and year which user will supply, here m using datepart() but it gives me result in two different column.

select DATEPART(MONTH ,GETDATE())  as [MonthNumber], DATEPART(YEAR,GETDATE()) as [Year]

what i want to do is select record from database where MONTH and YEAR is same

how i can do this .....

m using some of the separator /AND space FUNCTION ALSO but m not achieving my result

SQL

DECLARE @MONTHLYRECORD INT
select DATEPART(MONTH ,GETDATE())  as [MonthNumber], DATEPART(YEAR,GETDATE()) as [Year]
SELECT @MONTHLYRECORD

this query produce error

Posted 7-May-14 20:38pm

Tarun Jaiswal

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

King Fisher · Accepted Answer · 2014-05-07T20:57:00

Solution 1

use this Query for get last month Records

SQL

select *From table where month(date)=04 and year(date)=2014

to get the Month and year

SQL

DECLARE @MONTHLYRECORD INT
declare @year int
select @MONTHLYRECORD= DATEPART(MONTH ,GETDATE())
select @year=DATEPART(YEAR,GETDATE())
SELECT @MONTHLYRECORD,@year

Posted 7-May-14 20:57pm

King Fisher

Updated 7-May-14 21:01pm

v2

Comments

Prasad Avunoori 8-May-14 3:05am

What do you mean by "MONTH and YEAR is same"?<br>
What are the parameters your are passing to it?<br>
Make your question clear.

Maciej Los 8-May-14 3:12am

Wrong place to post comment. Your comment corresponds to the first soultion ;)

King Fisher 8-May-14 3:16am

i'm not ;)

Tarun Jaiswal 8-May-14 3:39am

King Fisher 8-May-14 3:46am

run this

create table ##table2(id bigint identity(1,1) ,value nvarchar(max) ,dates date)

insert into ##table2(value,dates) values('zzz','2014-02-15')
insert into ##table2(value,dates) values('zzz','2014-03-15')
insert into ##table2(value,dates) values('zzz','2014-02-15')
insert into ##table2(value,dates) values('zzz','2014-04-15')

select *From ##table2 where MONTH(dates)=02 and YEAR(dates)=2014

Tarun Jaiswal 8-May-14 4:13am

thx buddie but m not interested in creating GLOBAL TABLE
and YES this query works well.

King Fisher 8-May-14 4:59am

Welcome

Peter Leow · Accepted Answer · 2014-05-07T21:08:00

Solution 2

Check this out: where-clause-to-find-all-records-in-a-specific-month-year[^]

Posted 7-May-14 21:08pm

Peter Leow

Comments

Tarun Jaiswal 8-May-14 3:46am

thanx it works.

Peter Leow 8-May-14 4:08am

You are welcome.

How I Can Select Record From Database According To Month-Wise Not By Date Wise Means Whatever Date Is There In Database Select Reocrd By Month And Year Basis

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How I Can Select Record From Database According To Month-Wise Not By Date Wise Means Whatever Date Is There In Database Select Reocrd By Month And Year Basis

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us