meta user
network profile
| bio | website | leaf-node.co.uk |
|---|---|---|
| location | Nottingham | |
| age | ||
| visits | member for | 8 months |
| seen | 2 days ago | |
| stats | profile views | 26 |
Nottingham based DBA, mainly SQL Server but turns hand to anything else. Currently getting excited about cloudy stuff.
|
Feb 4 |
comment |
how to insert data from one table to another OK, I've edited my answer to incorporate your revisions, though please note that as the created column isn't defined anywhere I can't answer that section. |
|
Feb 4 |
revised |
how to insert data from one table to another more info from requester, so I've reinstated answer |
|
Feb 4 |
answered | how to sum column values with same id |
|
Feb 4 |
comment |
how to insert data from one table to another What's the created column? |
|
Feb 4 |
comment |
how to insert data from one table to another BTW, I made a mistake in the previous note, and meant is SKU always the string 'prod-' with the id appended. If there's no relationship, then this query logically can't exist as there's no way to like a specific sku to a particular id. |
|
Feb 4 |
comment |
how to insert data from one table to another How are id and sku related? Is sku allways 'sku-'+id ? |
|
Feb 4 |
revised |
how to insert data from one table to another change query based on askers update |
|
Feb 4 |
comment |
Using data from other database to populate a new database You have more columns in target than source, and they're also NOT NULL columns. Where are you getting the other values from? (This will affect the query you need to use). |
|
Feb 4 |
answered | how to insert data from one table to another |
|
Jan 17 |
comment |
How to identify the db orphan mdf and ldf files good points. I'd forgotten to account for multiple instances. |
|
Jan 17 |
revised |
How to identify the db orphan mdf and ldf files future proofed query |
|
Jan 17 |
answered | How to identify the db orphan mdf and ldf files |
|
Jan 16 |
comment |
Backup Only Database Schema Everynight When you say 'schema only', are you meaning you only want to backup certain schemas. Or are you using schema to mean the db structure, and you want the create scripts for tables, indexes, etc? |
|
Nov 27 |
answered | Update field with new string made from characters in existing value |
|
Nov 25 |
revised |
Please help configure my Mysql for 12GB 4cores server fixed up spelling and grammar |
|
Nov 25 |
comment |
Please help configure my Mysql for 12GB 4cores server Do you mean a single 4 core CPU, or 4 CPUs? What else is running on the server? Is MySQL writing anything to it's log when it does restart? |
|
Nov 25 |
suggested | suggested edit on Please help configure my Mysql for 12GB 4cores server |
|
Nov 24 |
comment |
Complex SQL Query Hi, sorry about that. I'd assumed a little too much about your data. I've added some edits to my answer that should solve those issues. I've added a where clause to let you specify the hostname, and then where clauses for each of the 3 joined tables to filter to snmp_index 527 as per your example. |
|
Nov 24 |
revised |
Complex SQL Query added extra criteria to fix OP's comments. |
|
Nov 24 |
answered | Complex SQL Query |
