Basics of Python

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...

How to Install Visual Studio Code (VS Code) on Your System

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...

t

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...

SSRS usage Part1

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...

SSRS Usage Part2

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....