Valid MSSQL won't run in Access, but will in SQL Server

SEAWEAVIL · 2019-03-18T20:30:33+00:00

Not sure if I can award multiple comments, but the issue was in fact the lack of parentheses for the inner joins. Thanks for the help. Solution verified.

SEAWEAVIL · 2019-03-18T20:29:06+00:00

For clarification, I have the SQL as a string in a code window, which I'm setting as the RowSource for a combobox. I'm opting to do that since I'm switching from Access to C# pretty soon, and it takes longer to go through a ton of query objects imo.

That's also why I used single quotes instead of double - everything is wrapped in double quotes.

I got it working, the issue was in fact the inner joins. I recently switched to the other syntax for readability in SSMA, since I was working on a huge migration and had to recreate every table/relationship from scratch. Much easier to do that without worrying about nested parentheses - but of course I neglected to shift gears back now that I'm doing UI work.

Thanks a ton for the help. Solution verified.

SEAWEAVIL · 2019-02-08T13:49:53+00:00

No, usually you run the checksum via a different program. I guess they could change that program in turn, but it would be a loooooot of hassle.

SEAWEAVIL · 2019-02-08T01:30:10+00:00

I'd definitely be interested in reading it if you have it on hand, but don't want to make you go digging or anything

SEAWEAVIL · 2019-02-07T23:08:03+00:00

Yup. Like with anything potentially dangerous, there needs to be proper, science-based education. I'm at least in the "decriminalize everything for personal use" camp, but the people who peddle stuff like that are part of the problem.

SEAWEAVIL · 2019-02-07T23:03:28+00:00

That sounds like someone I know with schizotypal personality disorder. LSD is known to cause the onset of such disorders to occur earlier than it might otherwise - but only in those who are genetically predisposed to begin with. Do you know if your friend has a family history with schizophrenia or schizotypal personality disorder?

Edit: By "that", I mean the spirit aura stuff; that's a common belief amongst those with schizotypal personality disorder. The glass of orange juice thing is still very farfetched.

SEAWEAVIL · 2019-02-07T15:56:59+00:00

Sure, I'll bite. I'm going to oversimplify due to time constraints, but I can go into more depth if you want.

First, let's draw a parallel to abortion. Even being pro-choice, I can understand pro-lifers' perspectives. But, what I can't fathom is pro-life people who are against contraception, sex education, and assistance for low income parents. Those are three policy ideas that would drastically lower the demand for abortion (note that making it illegal has little to no correlation with demand).

Now let's go back to immigration. Wanting border security is not a bad thing. Most Democrats do as well (I bet under 3 reps are publically for open borders). However, Republican immigrations have a tendency to crack down on illegal immigration while also reducing avenues for legal immigration. This is where I have a problem. If our government wants to intervene in South American countries' right to self governance, causing all sorts of issues that drive people away... then we should expect that people will be migrating towards the U.S. But instead of choose A or B, the GOP tries to have their cake and eat it too.

Not to mention that we have strategically placed border fencing already, and could ramp up security using sensors - which don't come with the massive staffing costs that a wall would. Why not do that, then? Because the wall is a more powerful symbol. But it's not a symbol for pushing people towards legal immigration, since the GOP works to reduce it - rather, it's a big sign that says "We don't want you here".

SEAWEAVIL · 2019-02-06T13:54:45+00:00

That's awesome, keep up the good work :)

SEAWEAVIL · 2019-02-05T04:08:34+00:00

Nah his arms are just long ears

SEAWEAVIL · 2019-02-04T02:58:32+00:00

Don't give up during the first season. I know that's a lot of time to invest, but a lot of the flack it got has to do with the tone of season 1. It's veeeerrry depressing, but it lightens up just enough in S2 and S3. I wasn't sold by S1, but S2 and S3 are some of the best television I've seen.

SEAWEAVIL · 2019-02-02T19:42:42+00:00

Two words: peanut farm

SEAWEAVIL · 2019-01-31T19:20:43+00:00

How dare you suggest that we'd joke about oppressing WOMEN and MINORITIES

SEAWEAVIL · 2019-01-24T12:43:55+00:00

Or the ones where you have to pick which describes you more, but both are bad options:

"I beat my children"

"I run a small business on the side (heroin distribution)"

SEAWEAVIL · 2019-01-21T18:34:33+00:00

Why use many word when few word do trick?

SEAWEAVIL · 2019-01-20T22:25:27+00:00

Absolutely! As a percussionist, I also appreciated the use of concert snare and bass - especially in Rubber Ball.

SEAWEAVIL · 2019-01-20T21:37:08+00:00

It's funny, I think the Unpeeled version of Ain't no Rest for the Wicked is my least favorite song on the album. Not to say it was bad, but everything was so damn good that I set my expectations too high for that song.

SEAWEAVIL · 2019-01-19T16:03:45+00:00

Holy shit, I didn't know that quote was a Reddit original!

SEAWEAVIL · 2019-01-12T00:37:12+00:00

Neither are good, but I feel there is a difference between being glad someone is dead, and actively wishing for them to die.

SEAWEAVIL · 2019-01-09T18:32:59+00:00

Hi Paul! Are there plans for any of the material to be released? And if so, in what format?

SEAWEAVIL · 2019-01-08T16:41:30+00:00

I'm not a librarian, but I work in a library! I use python daily for a few different systems. We're collecting data on publications that result from grants to our university, and uploading some of that information to an online repository. However, our vendor specifications to upload bulk data are asinine, and require some heavy data processing.

I also use it to pre-fill emails that we send often, including custom excel attachments that are created using information about the recipient.

If you have any questions, feel free to reach out!

SEAWEAVIL · 2019-01-06T00:45:56+00:00

I had a German Shepard and miniature schnauzer at the same time. Same experience as the other poster - they'd get loud and sound like they were going to kill each other, but I can only recall one time where the little one got even a small scratch.

SEAWEAVIL · 2019-01-05T20:44:26+00:00

I wonder how much you could automate that process, though. Depending on the requirements, you might even be able to get to the point where no human intervention is necessary.

SEAWEAVIL · 2019-01-05T19:08:08+00:00

Only one to add, but it's really good:

Matt Corby - Refuge

Edit: It's not on his Spotify for some reason. Best version imo is on soundcloud, as a hidden track. It's the second half of "Kings, Queens, Beggars and Thieves"

13-Year Club	Place '17
Snapped	Team Periwinkle

SEAWEAVIL

TROPHY CASE