Difference between Datetime and Datetime2
December 30, 2017
December 29, 2017
using the Adventure-works database
Get the list of employees whose birth date lies in 7th to 21st in the month of May
-- Get the list of Employees where birthdate lies in 7 to 21 in the month of May
Select NationalIDNumber, BirthDate
where MONTH(birthdate) = 5
and day(birthdate) >= 7 and DAY(birthdate) <= 21
order by day(BirthDate) asc
December 25, 2017
Happy New year 2018
So block your leaves in Microsoft office outlook by using .hol file
Hol stands for Holiday file
This file is used to add holidays in your outlook calendar.
This is very easy to create and install into the outlook.
One of the major advantages of this task is that whenever other colleague or stakeholder want to block your time then he would easily know / aware about the holiday or leave you have planned already in the outlook calendar.
Lets start to create one simple Entry
Add your holiday in below format
[Maharashtra Day / Labor Day] , “2017/05/01”
Save this file as Holidaylist.hol
Remember I have not saved this file as txt file, I have saved this file as hol file.
Hol stands for Holiday file
Send it to your outlook email.
From inbox open this file / attachment.
This will prompt you to save the file / modify the outlook.
Click on ok and you are done.
For more reference please refer below link
howto create Holiday file in Microsoft office outlook
December 10, 2017
Example: from version 10.0.1 to tableau 9.3
From version 10.0.1 to tableau 9.1
We need to create twb file, if it is already a twb file the no need to make any change. If you have twbx then Unpackage the workbook by right click on Workbook and Select Unpackaged if workbook is packaged.
Next step is to open twb file in Notepad.
Select the file and right click on the twb file and select open with notepad
In notepad file Find the latest version i.e. 10.0.0 and replace with the version you want to be in
Example if you have tableau 10.0.0 and you want to convert into tableau 9.3 then find 10.0 in the notepad and replace with 9.3
There should be at least 3 instances where you have to replace the version in notepad.
Save the notepad file as it is.
You are done, now you can again right click on the twb file and select package workbook
June 17, 2017
Different file extensions available in Tableau
- Tableau Workbook
- Tableau Packaged
- Tableau Datasource (.tds).
- Tableau Packaged Datasource (.tdsx).
- Tableau Data extract (.tde).
- Tableau Bookmark (.tdm).
- Tableau Map Source (.tms).
- Tableau Preferences (.tps)
January 19, 2017
SELECT DISTINCT so.ID, so.name AS 'Procedure Name' , oo.name AS 'Table Name'
FROM sysdepends d, sysobjects so, sysobjects oo
AND so.name= 'Stored_Proc_Name' -- Enter Your stored Procedure Name here
ORDER BY so.NAME,oo.NAME
January 13, 2017
CREATE PROCEDURE dbo.FindStringInTable @stringToFind VARCHAR(100)
DECLARE @sqlCommand varchar(max) = 'SELECT * FROM [dbo].[TableName] WHERE '
SELECT @sqlCommand = @sqlCommand + '[' + COLUMN_NAME + '] LIKE ''' + @stringToFind + ''' OR '
WHERE TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'TableName' -- This condition can be removed.
AND DATA_TYPE IN ('char','nchar','ntext','nvarchar','text','varchar')
SET @sqlCommand = left(@sqlCommand,len(@sqlCommand)-3)
PRINT 'Unknown Error !!'
Execute FindStringInTable '[String to Search]'