Ektron Archive Content

Posted on By David Kittell 
UPDATE [content]
SET [searchable] = 0
	,end_date = '2014-02-04 12:10:00.000'
	,end_date_action = 2
WHERE content_id IN (
		SELECT c.[content_id]
		FROM [content] c
		INNER JOIN [content_folder_tbl] cft ON c.folder_id = cft.folder_id
		WHERE
			-- content_id = 34
			cft.[folder_name] LIKE 'OLD%'
		)
Originally Posted on February 4, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Ektron MSSQL MSSQL - Ektron MSSQL - Ektron 8.0.2 SQL

Related Posts

Count All Rows In All Tables

Posted on

There are a few ways to count all of the rows in all of your tables in a database. The “Fastest Option” actually pulls the information from the database where the numbers are stored rather than taking time to count rows. SELECT t.NAME AS table_name ,i.rows FROM sys.tables AS t…

Read More

Java – FRC – Limelight Vision – Basic Information Read

Posted on

The code below will help you to be able read basic information from your Limelight Vision camera. If you haven’t already read the documentation it’s a good idea to start there -> http://docs.limelightvision.io/en/latest/ Start with a new “Timed Robot” template project and add a few imports import edu.wpi.first.networktables.NetworkTable; import edu.wpi.first.networktables.NetworkTableEntry;…

Read More

Mac OSX – Computer Name

Posted on

# Name the Machine in all areas the same – Start # Get Serial Number sSerialNumber=$(system_profiler SPHardwareDataType |grep "Serial Number (system)" |awk ‘{print $4}’ | cut -d/ -f1) echo $sSerialNumber # Ask User if the computer is a laptop printf "Is this a laptop, if yes type y or if…

Read More