Cylindric

CREATE TABLE `Project_Assigned` (
  `AccountID` INT NOT NULL,
  `ProjectID` INT NOT NULL,
  PRIMARY KEY (`AccountID`, `ProjectID`)
);


CREATE TABLE `Account` (
  `Account_ID` INT NOT NULL,
  `Username` VARCHAR(45) NULL,

Cylindric

	DROP TABLE Items;
	DROP TABLE Orders;
	DROP TABLE OrdersItems;

	CREATE TABLE Items (
		ItemId int NOT NULL,
		ItemName nvarchar(50) NULL
	);
	
	CREATE TABLE Orders (

Cylindric

DECLARE @who TABLE (SPID INT, Status VARCHAR(255), Login VARCHAR(255), HostName VARCHAR(255), BlkBy VARCHAR(255), DBName VARCHAR(255), Command VARCHAR(255), CPUTime INT, DiskIO INT, LastBatch VARCHAR(255), ProgramName VARCHAR(255), SPID2 INT, REQUESTID INT)
INSERT INTO @who EXEC sp_who2
UPDATE @who SET BlkBy = 0 WHERE BlkBy = '  .'

DECLARE @blockers TABLE (SPID INT, blocking INT)
INSERT INTO @blockers SELECT BlkBy, COUNT(*) FROM @who WHERE BlkBy > 0 GROUP BY BlkBy


-- Ultimate Block
-- If this actually returns 1000 rows, there's a circular block

Cylindric

Public Function SuperConcat(range As range) As String
    Dim out As String
    
    For Each rCell In range.Cells
        out = out & rCell.Value
    Next rCell
    
    SuperConcat = out
End Function

Cylindric

DECLARE @who TABLE (SPID INT, Status VARCHAR(255), Login VARCHAR(255), HostName VARCHAR(255), BlkBy VARCHAR(255), DBName VARCHAR(255), Command VARCHAR(255), CPUTime INT, DiskIO INT, LastBatch VARCHAR(255), ProgramName VARCHAR(255), SPID2 INT, REQUESTID INT)
DECLARE @proc TABLE (SPID INT, Status VARCHAR(255), HostName VARCHAR(255), BlkBy VARCHAR(255), DBName VARCHAR(255), Command VARCHAR(255), CPUTime INT, DiskIO INT, LastBatch VARCHAR(255), ProgramName VARCHAR(255), last_statement TEXT)
INSERT INTO @who EXEC sp_who2
INSERT INTO @proc (SPID, Status, HostName, BlkBy, DBName, Command, CPUTime, DiskIO, LastBatch, ProgramName) SELECT SPID, Status, HostName, BlkBy, DBName, Command, CPUTime, DiskIO, LastBatch, ProgramName FROM @who

UPDATE p
SET last_statement = s.text
FROM @proc AS p
LEFT JOIN 
(

Cylindric

DQo8P3htbCB2ZXJzaW9uPSIxLjAiIGVuY29kaW5nPSJVVEYtOCIgc3RhbmRhbG9uZT0ibm8iPz4NCjwhLS0gQ3JlYXRlZCB3aXRoIElua3NjYXBlIChodHRwOi8vd3d3Lmlua3NjYXBlLm9yZy8pIC0tPg0KPHN2Zw0KICAgeG1sbnM6ZGM9Imh0dHA6Ly9wdXJsLm9yZy9kYy9lbGVtZW50cy8xLjEvIg0KICAgeG1sbnM6Y2M9Imh0dHA6Ly9jcmVhdGl2ZWNvbW1vbnMub3JnL25zIyINCiAgIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyINCiAgIHhtbG5zOnN2Zz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciDQogICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciDQogICB4bWxuczpzb2RpcG9kaT0iaHR0cDovL3NvZGlwb2RpLnNvdXJjZWZvcmdlLm5ldC9EVEQvc29kaXBvZGktMC5kdGQiDQogICB4bWxuczppbmtzY2FwZT0iaHR0cDovL3d3dy5pbmtzY2FwZS5vcmcvbmFtZXNwYWNlcy9pbmtzY2FwZSINCiAgIHdpZHRoPSIxMzAuMjE0NjUiDQogICBoZWlnaHQ9IjE1Mi41NzYyIg0KICAgaWQ9InN2ZzIiDQogICBzb2RpcG9kaTp2ZXJzaW9uPSIwLjMyIg0KICAgaW5rc2NhcGU6dmVyc2lvbj0iMC40NiINCiAgIHZlcnNpb249IjEuMCINCiAgIHNvZGlwb2RpOmRvY25hbWU9IlByaW5jZSBsb2dvLnN2ZyINCiAgIGlua3NjYXBlOm91dHB1dF9leHRlbnNpb249Im9yZy5pbmtzY2FwZS5vdXRwdXQuc3ZnLmlua3NjYXBlIj4NCiAgPGRlZnMNCiAgICAgaWQ9ImRlZnM0Ij4NCiAgICA8aW5r

Cylindric

[profile]
layer_height = 0.2
wall_thickness = 1
retraction_enable = True
solid_layer_thickness = 0.6
fill_density = 20
nozzle_size = 0.35
print_speed = 30
print_temperature = 210
print_temperature2 = 0

Cylindric

# generated by Slic3r 1.2.6 on Mon May  4 22:56:23 2015

[filament:PLA Faberdashery]
bed_temperature = 60
bridge_fan_speed = 100
cooling = 1
disable_fan_first_layers = 3
extrusion_multiplier = 1
fan_always_on = 0
fan_below_layer_time = 60

Cylindric

# generated by Slic3r 1.2.7 on Wed May 27 11:51:28 2015
avoid_crossing_perimeters = 0
bed_shape = 0x0,200x0,200x200,0x200
bed_temperature = 0
before_layer_gcode = 
bottom_solid_layers = 3
bridge_acceleration = 0
bridge_fan_speed = 100
bridge_flow_ratio = 1
bridge_speed = 60

Cylindric

@ECHO OFF

setlocal EnableDelayedExpansion
FOR /F "skip=1 tokens=1-6" %%A IN ('WMIC Path Win32_LocalTime Get Day^,Hour^,Minute^,Month^,Second^,Year /Format:table') DO (
    if "%%B" NEQ "" (
        SET /A FDATE=%%F*10000+%%D*100+%%A
		SET /A YEAR=%%F
		SET /A MONTH=100+%%D
    )
)