Its easy to convert DVD folders to ISO.
Mac offers hdiutil command line tool which can be used for to achieve the same.
Open Terminal Window (GO > Utilities > Terminal)
Type the following command
$ hdiutil makehybrid -udf -udf-volume-name <<YourDVDVolumeName>> \
-o <<yourname.iso>> /folderpath/parentdirectoryofvideo_ts
Note: If video_ts resides on /user/user1/download/movie1/video_ts
above command will look like
$ hdiutil makehybrid -udf -udf-volume-name movie1 \
-o movie1.iso /user/user1/download/movie1
In few minutes .iso file will be ready.
By default the output iso file will be stored on /user/user1 folder.
Deleting duplicate rows in SQLServer is very simple.
Example : Check this table let me call it as Sample, order number 1,2 & 3 have identical values. Now we need to delete the duplicate rows.
Step 1 : Insert another column in table Sample called Dup of type Integer.
Step 2 : Execute this Query (uses Common Table Expression)
WITH DUP_CTE AS (
SELECT *, ROW_NUMBER() OVER (PARTITION BY ORDERNO,Name,COST ORDER BY ORDERNO) AS DupRank FROM Sample
UPDATE DUP_CTE SET Dup = DupRank
Now the table looks like this
Step 3 : Delete all the rows where Dup greater than 1
DELETE Sample Where Dup > 1
Step 4 : If new column Dup is not needed drop it from Table.
Easy right !!
When you try to run/execute a .vbs file, you will be prompted with Security Warning. The security warning is good and it saves your PC from some malicious programs. But its an annoyance when you try to execute your own code.
As VBScript developer you will face this issue a lot when try to Schedule your task. To overcome this Microsoft suggest to set the Environment variable called SEE_MASK_NOZONECHECKS to 1.
set oShell= CreateObject("Wscript.Shell")
set oEnv = oShell.Environment("PROCESS")
oEnv("SEE_MASK_NOZONECHECKS") = 1
oShell.Run "c:\projects\sample.vbs /norestart",0,True
Recently tested this code on Windows 7 64 bit and it worked fine.
How to Save and Schedule SSIS Packages using SQL Server 2008 R2 for Non Administrators
Upgrade SQLServer 2008 R2 with latest SP
Saving Package from Business Intelligence (.dtsx) to SQL Server
EXEC sp_addrolemember 'db_ssisltduser', '<<user/group>>'
EXEC sp_addrolemember 'SQLAgentUserRole', '<<user/group>>'
Follow this step for Connecting to a Remote Integration Services Server
Displaying new INR on webpages is now so easy.
To display ₹ on your webpage use this HTML Code ₹ ; (without spaces) [& # 8 3 7 7 ;] (Source Code not on GUI)
No external .JS or plugins necessary.
Best practice is to download the file settings-init.php, make changes and upload it back.
1. Download woocommerce/admin/settings/settings-init.php (plugins folder)
2. Code to add currency starts between Line 45 to 72
3. Now add this line in suitable position 'INR' => __( 'Indian Rupee (& # 8377;)', 'woocommerce' ),
[HTML code &#.. should be without spaces]
4. Save & Upload to woocommerce/admin/settings folder
Note : & # 8377; is the HTML code for new Indian Rupee Sign