@mike-2 Vessey

yeah am sure

i didn't type Select Average(salary) from #employee

Thanks for Mike Vessey and Vinu Vijayan

Hi calvo,Koen Verbeeck,Jeff Moden ,capn.hector,GSquared ,

Thanks to all.

Thanks Keon Verbeeck

now i understood.

really thanks

Hi ,

thanks for reply

i wrote the query

i used dateadd funciton

DateAdd( month , @Monthnumber, 0 ) - 1 )

Regards,

firoz

Hi Dev,

Thanks for reply this query

Select A.*,B.*

from A Full Outer Join B

on A.Id=B.id

where A.Id is null

or b.id is null

My tables doesn't have column call "id" then how...