try this one.

select * from transmast where month(trans_date) = month(getdate()) and

year(trans_date) = year(getdate())

Seems to be simple and you could also have a lot of ways to get this....

I think the question itself might not be framed properly.

Because every where in the question, the tablename is mentioned as "people".

"There is the data in the People table:"

Where as the...

I think the question itself might not be framed properly.

Because every where in the question, the tablename is mentioned as "people".

"There is the data in the People table:"

Where as the...

I think the question itself might not be framed properly.

Because every where in the question, the tablename is mentioned as "people".

"There is the data in the People table:"

Where as the...