Sql Server & SSRS Tips

--SearchAllTables 'Jawad',joji CREATE PROC [dbo].[SearchAllTables] ( @SearchStr nvarchar(100) ,@ReplaceStr nvarchar(100) ) AS BEGIN CREATE TABLE #Results (ColumnName nvarchar(370),ColumnName2 nvarchar(370) , ColumnValue nvarchar(3630)) SET NOCOUNT ON DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110),@sql VARCHAR(2000) SET  @TableName = '' SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''') WHILE @TableName IS NOT NULL BEGIN     SET @ColumnName = ''     SET @TableName =     (         SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))         FROM    INFORMATION_SCHEMA.TABLES         WHERE       TABLE_TYPE = 'BASE TABLE'             AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName             AND OBJ...

declare @sd date=convert(varchar(10),getdate(),120),@ed date =convert(varchar(10),getdate(),120) ;WITH CTE as (  select users.user_name,users.u_fbid  ,count([messages].MessageID) SENT from  [messages] with (nolock)    left join users on messages.SenderFbID=users.u_fbid    where [messages].IsDelevered=0     and ([messages].messagedate   between     (case @StartDate when null then @sd else @Startdate end)     AND     (Case @EndDate when null then @sd else @EndDate end)   or Convert(varchar(10),messagedate,120)= @sd   )           group by users.user_name,users.u_fbid   ),   CTE2 as (  select users.user_name,users.u_fbid  ,count([messages].MessageID) received from  [messages] with (nolock)    left join users on messages.SenderFbID=users.u_fbid    where [messages].IsDelevered=1 and   (Convert(varchar(...