Compare Date 2 different table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Compare Date 2 different table

Author

Topic

ranganathanmca
Starting Member

15 Posts

Posted - 2011-03-10 : 06:13:56

Hi guys.,

I need to compare 2 different type of date first date format :

2011 1
2011 2
2011 3

second date format :

July 2011
June 2011
April 2011
March 2011
February 2011

compare the month if it's equal we need to display the data,Please share some example queries

Thanks for advance

ranganathan palanisamy

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-03-10 : 06:29:54

the date is in a single column or two column ?

what is the data type for the column ?

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources