1,788 reputation
313
bio website stuart-moore.com
location Nottingham
age
visits member for 1 year, 10 months
seen Jul 22 at 12:33

Nottingham based DBA, mainly SQL Server but turns hand to anything else. Currently getting excited about cloudy stuff.


Feb
12
revised Restore the latest backup on the database
Updated answer after clarification of details from OP
Feb
11
answered Restore the latest backup on the database
Feb
11
comment Restore the latest backup on the database
Will you be able to query the original server while doing the restore? Or is it in a completely seperate environment?
Feb
8
answered In SQL Server, what are the typical symptoms of parameter sniffing?
Feb
8
answered How can I install a provider for linked server?
Feb
6
awarded  Informed
Feb
6
answered SQLQueryTableData-Important
Feb
6
revised Reference the database from a stored proc?
improved answer
Feb
6
answered Reference the database from a stored proc?
Feb
5
comment Change SQL Server 2008 name
what happens if you run the following DOS command: nslookup SERVER2
Feb
5
comment how to insert data from one table to another
I have edited an an extraneous column that I used for testing. Here's a SQLFiddle showing it working - sqlfiddle.com/#!2/ea8e8
Feb
5
revised how to insert data from one table to another
deleted 15 characters in body
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).