WindowsKey + R Type: “regedit” Hit Enter Go to: HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU Find AUOptions. You can change the values from 1 through 5. 1. Download updates but……
WindowsKey + R Type: “regedit” Hit Enter Go to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\AUOptions Values: 1, 2, 3, 4, 5 1. Don’t check 2. Check but don’t download……
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=’table_name’ and COLUMN_NAME in (‘column_name’,’column_name2′) OR SELECT ORDINAL_POSITION ,COLUMN_NAME ,DATA_TYPE ,CHARACTER_MAXIMUM_LENGTH ,IS_NULLABLE ,COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘youtablename’ ORDER……
In order to add multiple lines in a single cell in MS Excel all you need to do is just use the keyboard shortcut ALT……
Disable Email Notifications: 1. Go to Tools -> Options 2. Under Preferences Tab click on E-mail Options… under E-mail area 3. In E-mail Options click……
Lets say you have a dataset that is returning a bunch of rows but you have a top N or some kind of a filter……
FormatDateTime command Command Result FormatDateTime(Parameters!Date.Value,1) Tuesday, February 10, 2011 FormatDateTime(Parameters!Date.Value,2) 2/10/2007 FormatDateTime(Parameters!Date.Value,3) 12:00:00 AM FormatDateTime(Parameters!Date.Value,4) 00:00 Format command Command Result Format(Parameters!Date.Value,”dd-MM-yyyy”) 10-02-2011 Format(Parameters!Date.Value,”dd/MM/yyyy”) 10/02/2011 Format(Parameters!Date.Value,”MMM-dd-yyyy”) Feb-10-2011 Format(Parameters!Date.Value,”MMM-dd-yy”) Feb-10-11 Format(Parameters!Date.Value,”MMMM-dd-yy”) February-10-11 Format(Parameters!Date.Value,”MMMM dd yyyy”) February 10 2011 Also this expression: =Day(Parameters!AsOfDate.Value) & “/” & Month(Parameters!AsOfDate.Value) & “/” & Year(Parameters!AsOfDate.Value)……
As you all know when you have an expression and you try to format the numbers inside the box by right clicking on the box/field……
If you have a single select parameter but you would like to have the “Select All” option added to it here is how you can……
The problem of trying to use DISTINCT when you have a ntext field is that it will not let you do it. So here is……