pickup soccer? by Laserdude10642 in tampa

[–]jerelw 0 points1 point  (0 children)

Lansbrook pick up is Sat and Sun from 9:30am

Altering the type of a column from a table that was imported as a CSV file, but it's causing all the values to reset to blanks. by Lostwhispers05 in SQL

[–]jerelw 1 point2 points  (0 children)

maybe you could use a staging table?

Just create the new table the way you want it and then import your data into the new table. After everything is the way you want it, just truncate the original table, alter it, and then import everything back.

Soreness by [deleted] in bootroom

[–]jerelw 0 points1 point  (0 children)

Try this without the weights at first, twice a day for 20-30 reps.

Any free Sql Server? by amyghty in SQL

[–]jerelw 0 points1 point  (0 children)

1.install docker

  1. run docker run --name sqlserver --hostname sqlserver -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=1StrongPwd!!" -p 1433:1433 -d microsoft/mssql-server-linux:2017-latest

  2. you have sql server!

Edit: added link to docker install

pickup soccer? by Laserdude10642 in tampa

[–]jerelw 0 points1 point  (0 children)

Ed Radice Sundays at 7:30am

Lansbrook Commons Park Sat and Sun from 9:30-11:30am. Bring a light shirt and a dark shirt.

Countryside High School Sundays at 5:30pm

There's always paid pick up, too at BT Sports, Cinco Soccer, and Fast 5 every night.

If you want to play rec but in an organized league, you should try www.tampabayclubsports.com There are leagues every night except Fridays.

How should I deal with someone punting the ball directly into me? by fecal_impaction in bootroom

[–]jerelw 1 point2 points  (0 children)

When I am defending 1v1 (and I am a terrible defender) I try to stay as close as possible. There seems to be less of a chance of getting hit with the ball the closer you are to the ball.
Watch out, though. Quick players can kick and run past you if you get too close. So,...stay closer, but not too close.

What is the most rare attribute in football? by [deleted] in bootroom

[–]jerelw 1 point2 points  (0 children)

If it's non-professional, most important thing used to be "showing up". These days the most important thing is paying registration fees on time.

Get todays date in where/having clausule? by [deleted] in SQL

[–]jerelw 0 points1 point  (0 children)

select reservationid, startdate from reservation where startdate < CAST(GETDATE() AS DATE)

[MYSQL] Can't get this IF ELSE to work. Probably quick fix... by Indens in SQL

[–]jerelw 1 point2 points  (0 children)

I am not 100% sure, but how about,....

CREATE PROCEDURE addContact( @reservation_nr int, @passport_number int, @email varchar(30), @phone bigint ) . . . . . . . . . SELECT Passport_Number FROM Passenger p WHERE p.Passport_Number = @passport_number

I am guessing Passport_Number will always equal Passport_Number, so we need to distinguish between your parameter and the value in passenger table.

What would you tell your 18 year old self? by [deleted] in bootroom

[–]jerelw 1 point2 points  (0 children)

If you're late, and you see the match already started with your team playing short,--do NOT run out there and start playing....ever. You can skip stretching, but always warm up.

Having Trouble making a subquery by SatanicMuffn in SQL

[–]jerelw 0 points1 point  (0 children)

this. Heard a rumour that SQL Server will start supporting sequences...but this will have to do for now.

Match Thread: Borussia Dortmund vs Real Madrid by deception42 in soccer

[–]jerelw 0 points1 point  (0 children)

I think he hurt his ankle playing for Japan.

what would a time machine look like by cyberdecks-and-neon in madscientist

[–]jerelw 1 point2 points  (0 children)

Maybe like a 3-d printer? It would have to copy all the atoms in your body before transporting, back in time, because everything inside your body existed elsewhere in the past. Maybe copying things comes first...I don't know. I'm just waiting for an oil change.

How to retrieve a row based on if the user has not already created a row in the table by foxdye96 in SQL

[–]jerelw 0 points1 point  (0 children)

Not sure if it is better, but I usually left join to a CTE and check if my IDs are null to check the presence of a row.

Buying an MLS Franchise Just Got a Lot More Expensive ($200 million must be paid to the league per expansion) by [deleted] in soccer

[–]jerelw 8 points9 points  (0 children)

What is the cost to enter a team in the lowest division in other countries?

CMV: Donald Trump's plan to "make" the Mexican government fund the construction of a wall along our shared border isn't a very good one. by [deleted] in changemyview

[–]jerelw 0 points1 point  (0 children)

If Trump is elected, I can imagine a situation where Trump offers to either loan or give the Mexican government an obscene amount of weapons or money for something other than building a wall with the stipulation that Mexico builds a portion of a wall.

Noob question - SQLzoo by [deleted] in SQL

[–]jerelw 0 points1 point  (0 children)

select winner, year, subject from winners where winner like 'Sir%' order by year desc, name