I have three Table 1.Table is Vendor_tbl,2.Employee_tbl,3.Attendance_tbl
table 1(vendor Table) Structure
UniqueId] ,[VendorCode] ,[VendorName],[VStatus] ,[Createdate] ,[Createdby] ,[Updatedate] ,[Updatedby] FROM [dbo].[mstr_vendor]
======================================================================================
table 2(Employee_tbl)structure
[UniqueId] ,[WorkforceId] ,[BarcodeId] ,[VendorCode] ,[FirstName] ,[LastName] ,[Mobile]
,[WFStatus] ,[DeactivateOn] ,[Createdate] ,[Createdby] ,[Updatedate] ,[Updatedby]
FROM [WMS].[dbo].[mstr_workforce]
table 3 Structure
i want to monthly wise vendor performance
my where condition is between createddate '01/01/2015' and '01/06/2015' Vendor Code='0001'
i want show below like how get the details from above
Note:jan 2015 the vendor register 100 employees jan total reg is 100, feb month added extra 10 employees total feb month is 110 this total need continue with upcoming month
Please provide Solution I try different way but i am not get exact ans,below querys is i am using
Thanking You,
VEnkaT...