access_time 1740180600000 face Vijay Kashyap
Basics of Python Python Basics: A Beginner's Guide Python Basics: A Beginner's Guide Python is a powerful, easy-to-learn programming language used in various fields. This guide covers fundamental concepts to help beginners get started. Variables and Data Types Python supports different data types s...
access_time 1781947800000 face Vijay Kashyap
How to Install Visual Studio Code (VS Code) on Your System Visual Studio Code (VS Code) is a popular, lightweight, and feature-rich code editor developed by Microsoft. It supports multiple programming languages, extensions, and built-in Git support, making it an ideal choice for developers. This gu...
access_time 2024-06-27T15:16:10.317Z face Vijay Kashyap
DECLARE @Date VARCHAR(8) = '20240101', @Group VARCHAR(MAX) = '00100A,00110H' --'0012GB,001360,00192P'--001AES,001281,001ECL,001VHS,001BPE' --@ShowCaptive INT = 1 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED DROP TABLE IF EXISTS #PRODUCTS, #GRP, #GrpBillExt, #BillAdjst, #TPREM_BillAdjst, #EEBILLF...
access_time 1717245180000 face Vijay Kashyap
SSRS usage Part1 ----------1.Query reporting tables to see usage SELECT Catalog.Name AS ReportName, Catalog.Path AS ReportPath, Catalog.Type AS ReportType, Catalog.CreationDate AS CreatedDate, COUNT(ExecutionLog.InstanceName) AS UsageCount FROM Catalog LEFT JOIN ExecutionLog ON Catalog.ItemID = Exe...
access_time 1717244880000 face Vijay Kashyap
SSRS Usage Part2 1.Add flag to see if a report is hidden or visible SELECT C.ItemID AS ReportID, C.Name AS ReportName, C.Path AS ReportPath, CASE WHEN C.Hidden = 1 THEN 'Hidden' ELSE 'Visible' END AS ReportVisibilityFlag FROM Catalog C WHERE C.Type = 2 -- Filter to select only reports (Type = 2) 2....