Error while Running query in postgreSQL from sql server 2016

The below query runs well in sql server 2016:

 select ResellerId, vCompanyName ,x.*  from wlt_tblReseller AS main  outer apply ( select (count (ipkReportTypeId)) AS "count", vReportTypeName                 from wlt_tblReseller _all                inner join wlt_tblClient clients  on clients.ifkParentResellerId = _all.ResellerId               inner join wlt_tblReport_CompanyMaster reporslogs on reporslogs.ifkCompanyId = clients.ClientId               inner join wlt_tblReports_TypeMaster rpt_types on rpt_types.ipkReportTypeId = reporslogs.ifkReportTypeId                where RootResellerId = main.ResellerId                  and rpt_types.bStatus =1                  and bIsStatic =1                  and vReportTypeName  is not null               group by ipkReportTypeId,vReportTypeName             ) AS x  WHERE IsMiniReseller = 0    and ResellerId <> 1     and vReportTypeName is not null  order by  vCompanyName desc  

But when I take it to postgreSQL and change outer apply to LEFT JOIN LATERAL,it does not run and produces the following error:

ERROR: syntax error at or near "WHERE" LINE 9: )AS x WHERE IsMiniReseller = 0 and ResellerId <> 1 and v… SQL state: 42601 Character: 649

What could I be missing?Any help will be much appreciated.

Regards Chris.

sqlcmd is running but database shown no running query

We are facing this weird issue on our Azure setup. The database is SQLServer and client is CentOS. We fire queries using sqlcmd. Sometimes it happens that you see the sqlcmd running, but there is no runnable/sleeping query running in db (seen using sp_who2). This happens only for DML queries, for the queries of the sort insert into < sometable > select < someslectquery >.

And this happens like 25% of time. This occurs even when we run some procedure. The procedure stops at some insert .. select query. But sqlcmd still show s it running.

We have another setup with AWS with same database and same Centos, but we haven’t seen this thing happening there.

On same azure database, when we run the queries using windows machine using SSMS then the query completed on back-end. We tested this multiple times.

Has anyone face any such thing? Where to look for the issue?

Can I use Zephyr Strike outside of combat to increase my running speed?

The spell Zephyr Strike, from XGE, has the following text:

You move like the wind. Until the spell ends, your movement doesn’t provoke opportunity attacks. Once before the spell ends, you can give yourself advantage on one weapon attack roll on your turn. That attack deals an extra 1d8 force damage on a hit. Whether you hit or miss, your walking speed increases by 30 feet until the end of that turn.

Clearly this spell was written with combat in mind. I’m curious what support, if any, exists for using it outside of combat for the purpose of increasing a character’s movement speed, for instance in a foot chase.

What I would like to happen: I cast Zephyr Strike, waive the attack, and immediately trigger the bonus 30 feet of speed (say, to 60 ft). Since Zephyr Strike’s casting time is a bonus action, I then take the dash action, doubling my speed to 120 feet. I have this speed for 6 seconds.

My interpretation of the spell as written: The bonus to speed requires the player to take the attack action. The extra speed only lasts until the end of the turn. So to gain the speed benefit, a player must attack something, which uses their action and prevents the use of the dash action while under the effect of the spell.

Obviously the DM can rule however they want, but I’m curious what support the rules might have for my preferred outcome.

Running select filename from dbo.sysfiles returns short foldernames with tilde

I am running the following statement in SQL Server 2014(in Windows 2012R2):

select filename from dbo.sysfiles where fileid = 1 

However it returns:

c:\progra~1\micros~1\mssql1~1.sql\mssql\data\master~1.mdf 

I wish for the full path without the tilde.

(e.g C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\DATA\master.mdf)

I tried upgrading the SQL Server 2014 Express to 2016 Express but it made no difference.

Any ideas? Thanks. Dave

UE4 – Timeline isn’t running

I suspected in my last question, that the problem was caused probably by the timeline I used in the custom event I made, Move To.

What I did was I researched this problem, viewed the documentation, and took a good look at the timeline itself, but I couldn’t find anything that could solve this problem.

The code is pasted here in BlueprintUE, in the MoveTo custom event if you need to see the code. Here is a picture of the timeline:

Timeline

I have been trying to fix this problem for days, help would be very much appreciated! Thank you!

How is movement calculated when running up walls as a monk?

Picture this circumstance. I am a 5 foot tall level 9 Wood Elf Monk with Mobile. I have 60 feet of speed per turn, via:

  • 35 feet from Wood Elf feature
  • 10 feet from the Mobile feat
  • 15 feet from being a level 9 monk

And can run on walls via the monk’s Unarmored Movement class feature.

I am 15 feet away from a medium sized melee combatant in a 5 foot wide corridor with a 20 foot high ceiling.

Avoiding all attacks of opportunity against me and without using any attacks from me and only the wall movement + speed listed, what is my maximum possible remaining movement to be on the other side of the combatant, out of range, with this setup?

To simplify this, I want to run up the wall, around the guy, without giving him a chance to hit me with his 5 foot range, and still have as much movement possible.

You know, normal Monk things.


My main concern is how the movement starts, and how diagonals work while wall running. Do I spend 5 feet to start “wall running” in the same square I’m in, or do I start by spending 5 feet to be 10 feet in the air? Can I simultaneously move forward while moving up?

I’ve also considered the potential of dropping while on the wall to conserve movement (presumably 10 feet past the combatant), and I want to suggest that for anyone to consider it themselves as a potential part of the answer.

Considering how abstract this question is, there may not be an official answer in 5e, but references to prior editions/Pathfinder on this topic would be valid substitutes.

Running Parallel Campaigns

So, as seems to frequently be the case with me, more players wish to be a part of my new campaign than I’m comfortable putting around one table (maybe 8). I toyed briefly with the idea of running two campaigns with different parties in parallel in exactly the same world (their actions can affect each other and the world in general, etc). I’m not likely to go down this route – it would require a substantially greater investment of time I don’t have – but it made me curious.

Has anyone ever run two campaigns in parallel? How did it go? What were the pitfalls you experienced, and how did you work around them? Were there any really cool moments that came about because of it? What special considerations would you make in planning such an undertaking?

Running a game of Microscope that isn’t totally insane?

I purchased Microscope quite a while ago, and have played countless games that were really awesome. We’ve created things like superheroes with the power to turn any weapon into fish, people marrying the ocean, ninja training schools masquerading as pre-schools, gnomes being used as fuel for magic, a bear running for president but being beaten by the janitor who happened to be nearby, etc. It’s silly and great.

But I keep reading other people’s games, and they get pretty deep and meaningful. People want to find out, not what crazy stunt happens next, but small, personal thing happens next. Very little like our games at all.

Every single game of Microscope I have played has been silly to the core. Every single Microscope game I’ve read about has not. There has been silliness, but never to the same extent it has been in ours. We rarely make anything meaningful. It makes me think there’s something we’re doing wrong.

I imagine this is partially why the Palette is there. But it doesn’t seem powerful enough to handle this particular problem.

How do you make sure a Microscope game is meaningful, and not a random amalgamation of nonsense?

Authorization error running db2 command line with db2inst1

I need to enable the COLUMNAR setting in DB2 Express Edition on Docker. For that to work I need to set INTRA_PARALLEL ON at the instance or database level.

I connect to the db2 command with db2inst1 that is the instance owner, but I’m getting an error saying that the user is root. How to fix this problem?

db2 => connect to bank0002 user db2inst1 using xxxxx     Database Connection Information   Database server        = DB2/LINUXX8664 11.5.4.0  SQL authorization ID   = DB2INST1  Local database alias   = BANK0002  db2 => UPDATE DBM CFG  USING INTRA_PARALLEL ON SQL5001N  "ROOT" does not have the authority to change the database manager  configuration file. 

Should I keep running my old projects as Active, Or just Verify

Greetings, friends.
Wondering if I should keep running some of my oldest set of GSA projects as active…and not just set to Verify only…
I mean those oldest projects where I just link to my money site directly with SER.
I don’t think I need to stop running old projects where SER creates links at T2 T3 .. .. just those pointing RIGHT at the  money site.
…and JUST those projects, of course, that I have newer replacements for with my own T1s, either on PBNs, a few legit listings, and various social media and other content platforms, and hopefully some authority links.
Is it ever OK to link directly to a money site with SER?
I have Asia Virtual Solutions active, blog comment, directory, forum, guestbook,Image COntent, Microblog, Pingback, Referrer, RSS, Social Bookmarks, Trackbacks, Web 2.0, Wiki running.
I also have a separate set of older projects that post to anything that will accept an article pointing at the money site. The articles are OK. Spun, hand-written, reviewed spintax for accuracy. On those I have Asia Virtual Solutions (projects to MS that use articles), articles, blog comments, pingbacks,referrers, social bookmarks, social networks, and wikis that use articles when posting.
This is how I chose to set up older projects. Are *either* the first set of projects, or the second that use articles,  appropriate as a T1 pointing at  a money site? And if not, what SHOULD I be using SER-generated backlinks? I’m *SURE* some will suggest SEREngines. I’ve haven’t used SEREngines since the last version, so if someone could explain I would very much appreciate it. Trying to do SEO right, finally. No more continuing poor practices that are just from a time I didn’t know better.
Should I *NOT* have been doing this? Is it considered “spam practices” by Google? At some point, I came to to understand that T1s should be stable and basically be legit. Is it OK?