Search - Joel Lipman .Com

1. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; ... "shared data source" to use). You might be able to get this working with a shared data source but in our case the shared data source didn't have the correct database (initial catalog) specified despite ...; Created on 22 November 2013
2. Compare two databases using T-SQL: / Transact-SQL /; ... Method #3 And a further enhancement which lists the different datatypes, is_nullable, maxlength and collations side-by-side: -- all columns side by side SELECT t1.TABLE_CATALOG AS [DB1_Name], t2.TABLE_CATALOG ...; Created on 24 September 2013
3. Search a database for a value and count matching rows: / Databases /; ... table names) DECLARE Cursor1 CURSOR FOR SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS ...; Created on 05 November 2012
4. SSRS Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; ... entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW: ...; Created on 14 December 2011
5. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... e.TimeStart, e.TimeEnd) [Total Time] ,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank] FROM [ReportServer].[dbo].[ExecutionLogStorage] e INNER JOIN [ReportServer].[dbo].[Catalog] ...; Created on 02 December 2011
6. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... e.TimeDataRetrieval + e.TimeProcessing + e.TimeRendering AS TotalTime FROM [ExecutionLog] e INNER JOIN [Catalog] c ON c.ItemID=e.ReportID WHERE c.Name='My Amazing Report' -- just change the value ...; Created on 17 November 2011
7. The ReportServer Database: / Databases /; ... ,a.[Status] ,a.[ByteCount] ,a.[RowCount] FROM [ReportServer].[dbo].[ExecutionLog] a INNER JOIN [ReportServer].[dbo].[Catalog] b ON a.ReportID = b.ItemID The Top 5 Most ...; Created on 08 August 2011
8. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... Catalog.Name AS ReportName, DATEPART(dayofyear, ExecutionLogStorage.TimeStart) AS DayOfYearRun, DATEPART(week, ExecutionLogStorage.TimeStart) AS WeekRun, DATEPART(year, ExecutionLogStorage.TimeStart) ...; Created on 03 August 2011