Mizda Gábor Gabrov

git clone [email protected]:YOUR-USERNAME/YOUR-FORKED-REPO.git

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream

	// forrás: https://stackoverflow.com/questions/3334138/combine-return-and-switch-in-c-sharp

	public class Switch<TElement, TResult> {
	TElement _element;
	TElement _currentCase;
	IDictionary<TElement, TResult> _map = new Dictionary<TElement, TResult>();

	public Switch(TElement element) { _element = element; }
	public Switch<TElement, TResult> Case(TElement element) {
	_currentCase = element;

	// forrás: https://stackoverflow.com/questions/508390/create-xml-nodes-based-on-xpath

	static XmlNode makeXPath(XmlDocument doc, string xpath)
	{
	return makeXPath(doc, doc as XmlNode, xpath);
	}

	static XmlNode makeXPath(XmlDocument doc, XmlNode parent, string xpath)
	{
	// grab the next node name in the xpath; or return parent if empty

	/Execute SSRS Subscription Manually/
	USE ReportServer
	SELECT
	S.ScheduleID AS SQLAgent_Job_Name
	,RS.SubscriptionID AS SubscriptionID
	,SUB.Description AS Sub_Desc
	,SUB.DeliveryExtension AS Sub_Del_Extension
	,C.Name AS ReportName
	,C.Path AS ReportPath
	FROM ReportSchedule RS (NOLOCK)