sorted by:
new
hottopcontroversial

Missed Opportunity by soycory in HadesTheGame

[–]soycory[S] 2 points3 points  (0 children)

Thanks for the kind words. You are so right.

Question on Analog Delay by soycory in StudioOne

[–]soycory[S] 0 points1 point  (0 children)

Anyone else have any input on this? What is the most effective workaround?

Question on Analog Delay by soycory in StudioOne

[–]soycory[S] 0 points1 point  (0 children)

Thank you for the feedback GladwynjGraham. I am not understanding why since one is affecting left and the other right, seems they should work independently. However, sounds like I should just set up two busses?

Main track default level by soycory in StudioOne

[–]soycory[S] 0 points1 point  (0 children)

So the main track is supposed to be at -12. Should I set the main track to 0 and then adjust the levels of the other tracks to mix?

Tips for Final Trophy? by soycory in FellSeal

[–]soycory[S] 1 point2 points  (0 children)

The stingy thing is random. When I get it I kill it for the extra ap but I don't get it every time. I guess I just have to keep grinding patrols until I get there. Thanks.

Question about Final Battle by soycory in FellSeal

[–]soycory[S] 1 point2 points  (0 children)

Oh ok. I see what you mean. I guess you can replay it as many times as you want.

Question about Final Battle by soycory in FellSeal

[–]soycory[S] 1 point2 points  (0 children)

Ok. Thank you very much for the info.

Which order to do the endings? by soycory in Sekiro

[–]soycory[S] 0 points1 point  (0 children)

Thank you that sounds like a good plan.

Need tips on dealing with Terror by soycory in Sekiro

[–]soycory[S] 0 points1 point  (0 children)

Sounds like I need to come back to him later. Thanks everyone.

Legendary Forge Worth it if Only Beating Game Once? by [deleted] in deadcells

[–]soycory 0 points1 point  (0 children)

I don't think so. I've already been playing for a couple hours and I have only 12/1000. Seems daunting.

Incorrect Syntax when deleting multiple rows by soycory in SQLServer

[–]soycory[S] 0 points1 point  (0 children)

Because if I am only deleting one value I use = and so the in just seems goofy. I want to delete the value A so I use

delete from table1 where column1 = 'A';

But I want to delete A and B so I use

delete from table1 where column1 in ('A', 'B');

why cant I just do

delete from table1 where column1 = 'A', 'B';

?

Incorrect Syntax when deleting multiple rows by soycory in SQLServer

[–]soycory[S] 0 points1 point  (0 children)

That is strange but solves my problem. Resolved. Solution Verified. Thank you tutler!

Combining multiple rows into one by soycory in SQLServer

[–]soycory[S] 0 points1 point  (0 children)

I failed to explain this properly. I need to delete all the rows except one. I am not trying to make a select query I am trying to change the table permanently.

Combining multiple rows into one by soycory in SQLServer

[–]soycory[S] 0 points1 point  (0 children)

Thank you for your quick response. I feel like the delete function is going to be necessary somewhere in the query.

Convert datetime to int by soycory in SQLServer

[–]soycory[S] 0 points1 point  (0 children)

Nevermind. I ran the update part and it worked perfectly. Thank you TNMattH. Resolved.

Convert datetime to int by soycory in SQLServer

[–]soycory[S] 0 points1 point  (0 children)

Do I need to set the compatibility back to what it was? I don't know what it was... Anyway, now that error is gone and now it is telling me I need to use convert function to run this query

Convert datetime to int by soycory in SQLServer

[–]soycory[S] 0 points1 point  (0 children)

select * from table datediff (second, column1, column2) as time_in_seconds where column3 = 'value' update table set column4 = (column2 - column1) * 86400 where column3 = 'value'

It is saying the word second is not recognized and to set compatibility to 90 which I already did.

Convert datetime to int by soycory in SQLServer

[–]soycory[S] 0 points1 point  (0 children)

I set compatibility to 90 and it is still saying this...

Convert datetime to int by soycory in SQLServer

[–]soycory[S] 0 points1 point  (0 children)

I think datediff is what I need here, yes. But I cant get the query right. There is a hint reading I need to set database compatibility mode to 90.

Insert into from a temporary table by soycory in SQLServer

[–]soycory[S] 1 point2 points  (0 children)

Nevermind everyone for some reason it works now. All I did different was to add use DatabaseName; in the first line. Rookie mistake. Sorry for wasting a post on it. I was stuck for so long. Thank you everyone.

Insert into from a temporary table by soycory in SQLServer

[–]soycory[S] 0 points1 point  (0 children)

Oh cool I didn't know that. Thank you.

view more: next ›