BALA SINGAM

To Create A Service

* Start | Run and type cmd in the Open: line. Click OK.
* Type: sc create
* Reboot the system

To Delete A Service

* Start | Run and type cmd in the Open: line. Click OK.
* Type: sc delete
* Reboot the system

This small tutorial is to show how to get particular date part of from a date value field in SQL Server query.

select sales_date,
         Day(sales_date) as Day,
         Month(sales_date) as Month,
         Year(sales_date) as Year,
         Day(getDate()) as Current_Day,
         Month(getDate()) as Current_Month,
         Year(getDate()) as Current_Year
   from sales_detail

Result

In above query my date field is sales_date , using Day , Month and Year function i can get the particular date part by passing sales_date as parameter. This is to get date part value from a particular field value.

To get date part from current date is almost same only passing the current date as parameter. To get current date use getDate() function which will return the current date.

Few weeks back , I have this reportviewer printing problem during our UAT. When user click the print button in reportviewer the machine died and reboot , and its only happen in few machine. In others machine reportviewer working fine.

Further finding shows only the machines that have installed the Security Patch KB925902 facing this problem.

The problem

The user machine crash and reboot when users click print button in reportviewer.

Cause

The problem exist after the installation of Security Patch KB925902 and microsoft site reported following models of printers effected

The site also stated

This problem occurs when a printer driver makes a call that has invalid parameters to the Win32K.sys component. This problem affects the following printer drivers:

Solution

I guess you already know , yes apply another hotfix , KB 935843