I have three tables users , article and comments_article i use this query for have all article and the information about who write this article:
SELECT article.* , users.* , article.id AS id , (SELECT COUNT(*) FROM `article` JOIN users ON article.id_user=users.id ) AS coun FROM `article` JOIN us...
@James only on call 48 hours and then done for a while. it's not actually that bad. we dont get a lot of pages even though we've set ourselves up to get a lot
@James well, for things like server bounces, we want to know when any server is down and then we want to be able to cross-reference that to servers coming back up (cleanly).
When you say "after use count in PHP but it doesn't work..." ... this isn't a programming site. If you need help with the PHP piece, please take this question to Stack Overflow — Kermit8 secs ago
@swasheck i suppose something like that is common many places, though? when i was a monitoring tech working the night shift about 10 years ago, we'd wake up the oracle dbas almost every night.
Your urgency though, is not our urgency. The StackExchange model is that we want good questions that help promote learning, not just scratching the current itch
@James i see. yeah. that's the confusion. i'm actually currently working an incident so that's why i'm not making much sense. i'll talk to you all later
you are not the first to ask, nor will you be the last. Asking is fine but you must do the basics which are outlined in the How to Ask that Bluefeet already linked
YP, not MP
But, even as that's the case. you could show some effort on your part by running the same search through google.it and find the Italian translation or let Chrome autotranslate for you. Instead, you stand with your hand out
@Carbos I feel like I'm repeating myself, but we've given you some pointers on how to improve your question. Instead of arguing with us about the urgency of it, edit your question and fix it.
If you kick someone in chat there's no notification of that for anyone but yourself.
This is not good. I just applied the third kick to someone thinking it was the second because someone else applied another one without my knowledge. When I kick, I have to announce it manually out of a personal ...
My question is why do you need to debug in 64 bit? I know for us, we debug in 32 bit but that's because we have a 64 bit instance installed with a 32 bit integration services instance installed. I didn't think it was typical for local machines to run IS package in 64 bit. With that being said, ma...
Write this: select * from TableA
Want this: select c1, c2, c2 ... from TableA
SQL Server Management Studio provides intellisense to pick one column at a time. it takes a while for table with lots of columns.
I can use Script Table as =>Select To=> New Query Edit Window. and the copy/Paste to m...
@swasheck oh i see. well that seems to make more sense. i'm hoping to get some of the noise turned off so that we can focus on things that matter (e.g. blocking on the trading systems).
Write this: select * from TableA
Want this: select c1, c2, c2 ... from TableA
SQL Server Management Studio provides intellisense to pick one column at a time. it takes a while for table with lots of columns.
I can use Script Table as =>Select To=> New Query Edit Window. and the copy/Paste to m...
