T-SQL Tip : Finding Running Total Value
Hi Guys, In one of my SSRS Reporting needs, I need to display RunningTotal in some funny colors. Here is the script that I have used. I hope it may help you somewhere too Thanks, Khilit
May 21, 2014
· 
Khilitchandra Prajapati · 
No Comments
Tags: SQL, T-SQL, Tip · Posted in: General, Interview QA, SQL Server
View is not showing newly added column in table
Hi all, This is for the people who still use “Select * From Table” in their SQL Views. I don’t know what is the reason that you are using this way to create your views, but you could be the victim of this scenario (see… what title says). Let me show you how you can […]
June 27, 2012
· Khilitchandra Prajapati · One Comment
Tags: INFORMATION_SCHEMA, INFORMATION_SCHEMA.COLUMNS, SQL Server, Stored Procedure, Tip, View · Posted in: General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, T-SQL, Tutorial
SSRS Report is asking for Username and Password while executing
Hi all, I want to bring to your focus a very minor detail which could eat-up your time when it happens. This is the case when your SSRS report is deployed on ReportServer and you are accessing thru any application or interface e.g. SharePoint. Your SSRS report is using Integrated Security and hence no need […]
June 21, 2012
· Khilitchandra Prajapati · No Comments
Tags: Asking for Username and Password, Execution, Fix, Report, SQL Server, SQL Server Reporting Services, SSRS, Tip · Posted in: Business Intelligence, Quick Fix, Quick Tips, SQL Server, SSRS, Suggestion, Tutorial
GodMode in Windows 7
Hi All, If you have a Windows 7, then you can enable so-called “GodMode” to get access to most of the controls of operating system & other components. You simply have to create a folder name with following words. “GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}” (Please exclude ” – double quotes while naming it). Ta-Da. The folder icon will change […]
February 21, 2012
· Khilitchandra Prajapati · One Comment
Tags: GodMode, Tip, Windows 7 · Posted in: General, New Features