Viewing 14 posts - 1 through 14 (of 14 total)
Some news regarding this as I still haven't resolved this?
November 22, 2016 at 11:10 am
Phil Parkin (11/18/2016)
tocy1980 (11/18/2016)
update Server_FINAL
set Server_FINAL.Parts = [Linked Servers].[DATA STORE LINKED].['ET NEW$'].[Parts Used]
and it doesn't work.
Get this error: he multi-part identifier "Linked Servers.DATA STORE LINKED.'ET NEW$'.Parts Used"...
November 18, 2016 at 6:53 am
I have tried this:
update Server_FINAL
set Server_FINAL.Parts = [Linked Servers].[DATA STORE LINKED].['ET NEW$'].[Parts Used]
and it doesn't work.
Get this error: he multi-part identifier "Linked Servers.DATA STORE LINKED.'ET NEW$'.Parts Used" could not be...
November 18, 2016 at 6:26 am
I mean update (fill with some values) one table column from another table column.
the trick is here I don't know how to connect Linked Server e.g.
update Server_FINAL
set Server_FINAL.Parts = [DATA...
November 18, 2016 at 6:12 am
Thank you Jeff.
Really I am still the newbie in SQL so this is still hard for me...
At this moment I am just trying to find for me familiar solution...
November 13, 2016 at 12:28 pm
delete from na_wf
;
insert into na_wf
SELECT [Country]
,[Region]
,[Br]
,[Tr]
,[Div]
...
November 13, 2016 at 5:18 am
ESAT ERKEC (11/10/2016)
Could you format this column to text in excel ?
A have already tried format to text, number, custom etc. but still nothing.
I would like to avoid opening these...
November 10, 2016 at 6:36 am
Should I mark this topic as closed or finished and how?
October 26, 2016 at 11:26 am
Luis Cazares (10/26/2016)
To obtain the data in the new way (which should be the correct way to store it)...
October 26, 2016 at 11:21 am
This works like a charm!
Thank you very much!
And one more question 🙂
If I need to put the data in the form like it is in the picture how to do...
October 26, 2016 at 9:29 am
I am still checking the data but it seems that query works excellent.
One more question.
I see few zeroes after [Aug-15] and I suppose it is because I don't have...
October 26, 2016 at 9:05 am
Luis Cazares (10/26/2016)
Here's an example which is partially explained in this article: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/
SELECT [Customer], [Section], [Data], [Year], Jan,...
October 26, 2016 at 8:32 am
Viewing 14 posts - 1 through 14 (of 14 total)