Paul Tax tax

tax / phonebook.xml

Created November 11, 2015 11:46

	<?xml version='1.0' encoding='utf-8' ?>
	<root_contact>
	<contact display_name="john" office_number="123456" mobile_number="123456" other_number="123456" line="0" ring="" group_id_name="0" default_photo="Default:default_contact_image.png" selected_photo="0" is_favorate="0"/>
	</root_contact>

tax / gist:29cd3b887e0f37625d49

Created July 8, 2015 09:28

	{
	"id":"284",
	"title":"Bolshoi Ballet - Het Zwanenmeer",
	"subtitle":"",
	"onlinelabel":"Ballet",
	"type":"screenevent",
	"iconset":null,
	"ageclass":"no-class",
	"threed":"false",
	"releasedate":"2015-07-21",

tax / gist:5635087

Last active December 17, 2015 15:59

Role to be able to only execute stored procedure 1. Create login on server2. run code3. Add login with role to specific DB

	USE [mydb]
	GO

	/**** Object: DatabaseRole [db_executestoredprocedures] Script Date: 05/23/2013 12:10:19 ****/
	CREATE ROLE [db_executestoredprocedures] AUTHORIZATION [dbo]
	GO

	-- 1b - Grant permissions
	GRANT EXECUTE TO db_executestoredprocedures
	GO

tax / Search for text in stored procedure

Created August 28, 2009 09:00

	/http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html/
	SELECT ROUTINE_NAME, ROUTINE_DEFINITION
	FROM INFORMATION_SCHEMA.ROUTINES
	WHERE ROUTINE_DEFINITION LIKE '%foobar%'
	AND ROUTINE_TYPE='PROCEDURE'

tax / Pat noder.sql

Created June 25, 2009 15:24

	select
	pt.name AS 'Part type',
	count(*) AS 'Qty processed',
	'Passed' = (
	select count(*)
	from tbl_rmaproducts_generic rp2, tbl_parts p2, tbl_part_type pt2, tbl_rma rma2
	where swapgroup_id = 8
	and p2.id = rp2.part_id
	and pt2.id = p2.parttype_id
	and rma2.id = rp2.rma_id