Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
CREATE PROCEDURE [dbo].[Tel_WordReport] ( @tableName varchar(100) = null, @ColumnName1 varchar(100) = null, @Value varchar(100) = null ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; declare @SQL varchar(500) = null -- NONCLUSTERED INDEX [NIX__UNQ__UID_] DECLARE @Year_Ref smallint SET @Year_Ref = (SELECT [Year_Ref] FROM YEAR_LOOKUP WHERE [Year_no]= YEAR(GETDATE())) SET @SQL = 'SELECT Date,Ref, Comments,SentTo,SentBy,Regarding' SET @SQL = @SQL + ' FROM [' + @tableName + '] ' + ' WHERE [' + @ColumnName1 + '] = ''' + '' + @Value +''''+ ' AND [Year_Ref] =''' + '23 '+'''' SET @SQL = @SQL EXEC (@SQL) END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.