I have a few values that when the query is executed I want it be converted into columns instead of rows.
So on the database it looks like this:
Location | Val |
East Flow | 10 |
East Level | 20 |
East Pressure | 30 |
East MR | 40 |
West Flow | 100 |
West Level | 20...
I have two table Old_Table and New_Table. My old table has 13 million records in it currently and I need to process the data in old table and dump it into new. Data will be continuously inserted into my old table. So, I wrote a stored procedure and created a sql job to run nightly and process the...
@bluefeet Im sorry I mentioned your name in a pivot table once. but what I am trying to say is when a question is very similar to what you have asked a couple of days ago and it didnt get much attention whoever answer this question if you prompt this user to look at your question aswell that you asked sometime ago will I be wrong in doing so ??? — M.Ali2 mins ago
yeah the issue is because you mentioned me in a comment
This is because you are using a pre-ansi join. Here is what's going on: the list of JOINs are "connected" with the last table from the list, namely, the konta k. The konta__kategoria kat part of the non-ANSI join is not in scope in any of the ANSI joins, triggering the error that you see.
You ca...
If you had only asked this:
what other way I can get attention drawn to my questions ?
I would have voted to close the question as a duplicate of:
How do I get attention for old, unanswered questions?
...which has plenty of advice for getting attention to unanswered questions (disregard t...
hahahahahahaha ... 7 of my top 10 worst-performing queries on a specific server are all found in one stored procedure written by a specific dev. do i a) help, or b) hammer?
first click and Community Server gave me "Oops something went wrong!
Either the site is offline or an unhandled error occurred. We apologize and have logged the error. Please try your request again or if you know who your site administrator is let them know too."
@AaronBertrand I like the fact that he didn't call you out in the question but certainly did in the comment on your answer
@Zane steal that checkmak
@Zane I've copied your answer and it also works, I don't know why (I've tryed inner join), maybe I made a syntax error, thank you — user26063531 min ago
@swasheck community server sucks zebra dongs. Try again.
@M.Ali Not sure how that's relevant. Your reaction (or over-reaction) to a comment is not something I can predict, control, or be responsible for. — Aaron Bertrand1 min ago
@M.Ali seriously, though, if you're going to call me out with such accusations that I "told you off," could you provide a reference so that other readers may judge for themselves, rather than your word vs. mine? — Aaron Bertrand11 secs ago
Take it easy pal, I am not accusing you of anything what you said was right. what I did was wrong. and I did it in ignorance not knowing all the rules of SO. I have avoided doing it afterwards as much as I could. — M.Ali24 secs ago
For ETL, we're going to need to drop and recreate indexes. The user account that will be doing this doesn't have drop/create priv's. Anyone have a schema + drop create procs handy?
Oh, that might be less blecherous but no, the account will only have insert/update/delete and execute permissions
I thought of going the route of providing a table and schema as the input and just reorg the indexes based on that but then we have a few tables that have a ton of indexes for consumption post load
I would appreciate a comment on the -1 so we can all learn from down votes. The reply was factually correct and addressed the question directly. — Ali Razeghi13 mins ago
I don't see that on their profile... but yes, it doesn't mean inactivity, just no recent up-votes. I don't know how the network defines "recent" exactly.
> Rusty Eulberg, a database administrator from Lubbock, Texas
@AaronBertrand well that's true, though it doesn't seem to bother Google/Facebook/Twitter all that much. however, your point is well-taken considering the Live platform is an abomination to begin with.
Yeah, but doesn't explain why repeat view took 12X longer than initial. Usually it's the other way around (or, when they've done things this stupidly, both views are even)
I used to be able to edit a record, click Save, and the record updates. I had a couple jQuery datepicker's on my form - just standard MM/dd/yyyy format. SQL didn't mind updating the SQL datetime with these. Now, I added a timepicker addon (http://trentrichardson.com/examples/timepicker/). So ...
Doesn't fix the root cause of the problem. You can't just throw a DISTINCT in front of all your problems. — Zane6 secs ago
Too mean? I'm starting to get annoyed that 50% of these questions has pre 92 syntax and none of the answers mention that you should stop doing that.
I have tried using a join, I litterally am spending hours now just staring at the screen I need sombody to post the code in here if possible. — user315206946 mins ago
In MS SQL Server. Please don't tell me to ctrl-f. I don't have access to the entire query, but I'm composing the columns that depend on whether certain variable is declared.
Thanks.
You're right, you can't use the alias in the group by. But if you make your group by value...
GROUP BY [Cancellation Date] is NULL DESC
Then it's effectively the same thing.
I have a few values that when the query is executed I want it be converted into columns instead of rows.
So on the database it looks like this:
Location | Val |
East Flow | 10 |
East Level | 20 |
East Pressure | 30 |
East MR | 40 |
West Flow | 100 |
West Level | 20...
If you had only asked this:
what other way I can get attention drawn to my questions ?
I would have voted to close the question as a duplicate of:
How do I get attention for old, unanswered questions?
...which has plenty of advice for getting attention to unanswered questions (disregard t...
I used to be able to edit a record, click Save, and the record updates. I had a couple jQuery datepicker's on my form - just standard MM/dd/yyyy format. SQL didn't mind updating the SQL datetime with these. Now, I added a timepicker addon (http://trentrichardson.com/examples/timepicker/). So ...
In MS SQL Server. Please don't tell me to ctrl-f. I don't have access to the entire query, but I'm composing the columns that depend on whether certain variable is declared.
Thanks.
You're right, you can't use the alias in the group by. But if you make your group by value...
GROUP BY [Cancellation Date] is NULL DESC
Then it's effectively the same thing.
