If you would like to get only the latest record that is related to another record (Entity) here is one method of doing that by……
Source: http://www.ablebits.com/office-addins-blog/2013/05/31/excel-workbooks-separate-windows/ If you are trying to open Excel files in separate windows here are 3 methods that would help you accomplish that. Method 1……
If you would like to see the row count of each table in a database and you don’t want to go through every single table……
Here is how you can pin a folder to the taskbar in Windows 7: Source: http://www.unawave.de/windows-7-tipps/folder-to-taskbar.html?lang=EN First click with the right mouse button on the……
SELECT ID FROM yourTable GROUP BY ID HAVING (COUNT(ID) > 1) In SQL 2005+ you can do the following and get all of the columns:……
If you want to display all of the selected Values in a multi-select parameter you have to use the JOIN function in ssrs. =JOIN(Parameters!multiselectParameter.Value,”,”) Or……
If you have a multiselect parameter but you would like to have the “None” option added to it here is how you can accomplish it.……
In order to check is a Date is the same as today use the following code: DATEDIFF(d, SOMEDATE, GETDATE()) = 0 Tweet Tweet
Here is how you get the 00:00:00 timestamp for GETDATE() or any other date: SELECT DATEADD(d, DATEDIFF(d, 0 , DATEADD(d, 1, GETDATE())),0) Tweet Tweet
If you would like to find the start and the end of a Quarter based of a date here is the t-sql code you will……