Wednesday June 21st 2017

Categories

Insider

Archives

‘SQL, BI, IT news’ Archives

Using subqueries to find gaps in sequence

Using subqueries to find gaps in sequence

Using subqueries to find gaps in sequence source Microsoft Database development self-Paced Training Kit Tobias Thernstrom, Ann Weber, Mike Hotek and GrandMasters Create Table #orderdates (customerid int not null, orderdate DateTime not null); Declare @startdate datetime, @enddate datetime, @customerid int set @customerid =1 while [...]

Difference between CTE and Temp Table

Difference between CTE and Temp Table

From Reporting Perspective its import to to know the difference between CTE, derived tables and Temp Tables, following is the some of our attempt to elaborate the differences A common table expression can be thought of as a temporary result that is defined within execution scope of single a single SELEC, INSERT, UPDATE, DELETE or CREATE VIEW [...]

Tracking data changes in SQL Server 2008 and up

Tracking data changes in SQL Server 2008 and up

Commonly asked question in interview question. Please note that beginning from SQL server 2008 Microsoft introduced change tracking and change data capture (CDC) to help answer questions about data that changes in a database. Comparing Change Tracking to CDC SQL Server 2008 introduces two tracking features that enable applications to determine [...]

IIS not running ASP.NET MVC application

IIS not running ASP.NET MVC application

I found an issue of running MVC / ASP>NET web form sites on IIS. They were working fine on the Visual Studio, however After installing the IIS they were not running on Localhost. I was able to resole that by using the following help from Stackoverflow.com. I followed the diagram below you will that in The World Wide Web services 4.6 is checked and [...]

How to host ASP.NET web application in IIS version 7.0 or IIS 8.0?

How to host ASP.NET web application in IIS version 7.0 or IIS 8.0?

Recently I came across lot consulting working automating crosstab reports in Crystal Report. Crystal Reports has wizard for generating cross tab report, which is very limited in usage. We cannot customize these wizard generated crosstabs. Issue involved creating a crosstab which show months in columns in first half of the page and then shows [...]

Creating a dynamic Cross tab in using date add function

Creating a dynamic Cross tab in using date add function

In this post I used dateadd function to dynamically generating 3 new columns for bill paid amount during 3 months as follows Select ,sum(Case when date_format(b.dateCol,'%Y-%m-01') = date_format( DATE_ADD(date({?enddate}), INTERVAL - 0 MONTH) ,'%Y-%m-01') then b.paid_AMNT else 0 end) as Month3 ,sum(Case when [...]

ASP.net Web Parts

ASP.net Web Parts

The transaction log for the database is full

The transaction log for the database is full

o fix this problem, change Recovery Model to Simple then Shrink Files Log 1. Database Propertise > Options > Recovery Model > Simple 2. Database > Shrink > Files > Log Done. Then check your db log file size at Database Propertise > Files > Database Files > Path To check full sql server log: open Log File Viewer at SSMS > Database > [...]

Intermediate Java Tutorial – 2 – Some More String Methods

Intermediate Java Tutorial – 2 – Some More String Methods

 Page 1 of 8  1  2  3  4  5 » ...  Last »