swaters86

/*
 * Steven Waters - COP2930.145F14
 *
 * U03048478
 *
 * The purpose of this program is to allow a user to play a game of rock, paper, scissors
 * by entering in a number between 0 and 2, where 0 means picking scissors, 1, means picking rock
 * and picking 2 paper. Furthmore, the program should pick a random value for the computer which is
 * currently called Player 2 in case. Lastly, the program should display a message saying which player 
 * one or display a message saying it's a draw or that the user entered in an invalid number. 

swaters86

/*
RUN FIRST On MN1oDBS001
#1 - Backup profiles to MN1_.sql 
making backup of meta data to custom fake tables
*/
use custom
go

if @@SERVERNAME = 'MN1ODBS001'

swaters86

/*
RUN SECOND On MN1oDBS001
#1 - Backup profiles.sql
make a backup of meta data into a sperate table
make sure to update the timestamp for the table names in this script. 
*/

Use custom
go

swaters86

exec custom.dbo.CopyMetaData 'ZZ', '21', 1
go
print 'replicated out meta for 21'

exec custom.dbo.CopyMetaData 'ZZ', 'LA', 1, 0
go
print 'replicated out meta for LA'

exec custom.dbo.CopyMetaData 'ZZ', 'LB', 1, 0
go

swaters86

/*
 
CursorScriptForDeletingProfiles.sql
 
This is a cursor script that will allow you to delete a
profile from multiple site codes 
 
make sure to comment out the print @ASite statement and uncomment out the execute statement 
below it.
 

swaters86

MenuType
Label
url
ProfileLabel
Profile_Page_Title
Profile_Page_Keywords
Profile_Page_Description
Profile_Widget
Profile_Widget_Position
Profile_Widget_URI

swaters86

[DEBUG]
ExtendedPBOWarnings=1
ExtendedScriptWarnings=1
PBOWarningTimeout=0
RegExpWarnings=1
RegExpWarningTimeout=0
RequestWarnings=1
RequestWarningTimeout=0
ScriptExecTime=1
ScriptWarnings=1

swaters86

/* article 1 - North Branford residents hire attorney, start GoFundMe over propane facility */
select 
x1.Site as liveSite, 
x2.Site as stageSite, 
x1.PbsTag as livePBSTag,
x2.PbsTag as stagePBSTag,
x1.RequestStr as liveRequest, 
x2.RequestStr as stage,
x1.BuildTime as liveBuildTime, 
x2.BuildTime as stageBuildTime 

swaters86

select * 
from webextras.dbo.SEOLabels (nolock) 
where SEOLabel like '%some-object-to-painesvilles-plan-to-raze-1800s-house%'

select * 
from web.dbo.Artikkler_hode (nolock) 
where Avis='hr' and RowGUID='15172055-87FA-4CDC-AB26-782759B1FCFF'

select *
from web.dbo.Artikkler_fields (nolock) 

swaters86

set nocount on 
 
declare @ASite varchar(2)
 
select *
from web.dbo.profile (nolock)
where Avis='zz' and profile_id=1030377
 
declare sitecodes cursor scroll for 
  select avis from web.dbo.siteinfo (nolock)