really quick SQL Server question

AHarvey · 24 Mar 2017 at 12:42

Hi all,

I have access to our works SQL Server Management Studio and all the live data. I am very new to it.

I need to change the owners of some orders, I think I know how but I can't get hold of the director who does this normally, I've had a message from the old dev who says "in the live sql box there is a sql script that does it. Just find the id to transfer from and to"

Any idea where the live sql box is?

I've looked and can create scripts from new but can't find anything to reference what we need.

AHarvey · 24 Mar 2017 at 23:18

that's what I figured as well, but looking all over the place I've been unable to find anything that meets this. There's a standard replace procedure that covers the entire row for the table, but nothing specifically targeting ownership of an order.

Tech Director is over Tuesday or Wednesday, I'll ask him then whether what I've written is correct. I know it is to a point, it changes the info inside the order but not on the search page.

AHarvey · 27 Mar 2017 at 20:54

I know enough about coding and a basic knowledge of SQL to get by, turns out what I had written was spot on, it's fairly logical, but the director is over on Wednesday and is going to give me a full crash course over the software and a few other tasks I can take over

Thanks for the advice though

appreciate the responses

AHarvey · 21 Jun 2017 at 17:23

Ergates said:
"I have access to our works SQL Server Management Studio and all the live data. I am very new to it."

AWOOOOGA! AWOOOOOGA!

LOL, I've not broken anything yet, work on it daily now.

I've also applied, and IF they decide there is a second place available will be moving to a full time SQL analysts job in Stoke