Cast following INT variables to varchar.

@TempBatchNumber

@SourceSystemID

@EDWSourceSystemID

Set @DeltaSizeSQL =

'Select SUM(A.DeltaCount * B.AvgRecordSize) from '+'.'+@Databasename+'.dbo.parameterhistory A

Join Operations..DatasetTables B (Nolock) ON A.ReferenceObjectName =...

One correction :

SET @SqlQueryFirstName = @sqlquery + ' firstname = ' + @firstname

Hi,

Instead of writing SET @SqlQueryFirstName = '@SqlQuery ' + 'firstname = @firstname' this use below code.

SET @SqlQueryFirstName = @sqlquery + 'firstname = @firstname'

i.e. remove single quotes from...