SQL Journey

How to get current date

SELECT GETDATE()

Batch Update

update tbl_TEMP_DelivDocStats set [Total Documents] = (select Count([qry_Data_Docs].[DocuStartP]) from [qry_Data_Docs] where [qry_Data_Docs].[system] = tbl_TEMP_DelivDocStats.[system] and [qry_Data_Docs].[DocuStartP] is not null and [qry_Data_Docs].[Live Data]='L')

How to use cursor

DECLARE MyCursor CURSOR LOCAL FORWARD_ONLY FOR
  SELECT DocNo FROM tbl_DATA_Docs where LiveDataID=2
OPEN MyCursor

FETCH NEXT FROM MyCursor INTO @DocNo
WHILE @@FETCH_STATUS = 0
BEGIN  

.........
.
..

.
END
CLOSE MyCursor
DEALLOCATE MyCursor