SELECT @columns = COALESCE(@columns+',' ,'') + CASE WHEN ColumnType='DateTime' THEN CONVERT(VARCHAR(24),ColumnName,103) ELSE CAST(ColumnName AS Varchar) END FROM ICCS_StdReport_Column_Master where TableId=@ip_tableId SELECT @tableName=TableName FROM ICCS_StdReportTable_Master where TableId=@ip_tableId SET @SQL = ' WHERE convert(varchar(30),Download_Date,111) between '+ ''''+ convert(varchar(30),@ip_FromDate,111) +''''+' AND '+ ''''+ convert(varchar(30),@ip_ToDate,111) +'''' set @Query= 'SELECT '+@COLUMNS+' FROM '+@tableName+ @SQL
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)