MS SQL and multiple stations

MS SQL and multiple stations

Hello,
I am building a project that consists of a parser that parses data from different stations and inserts them in a MS SQL DB that will be connected to Zenon 7.11.
I have built the DB tables EMPFANGEN and SENDEN as it is described in the manual.
The problem is that variables from different stations have the same variable names eg:
Station1:
-D100
-D101
Station2:
-D100
-D101
etc.
I cannot see any way to make the variables in the DB distinguish by station since the table only holds variable name and variable value. What is the best way to solve this? Should I use different variable names?
eg:
Station1:
-Station1_D100
-Station1_D101
Station2:
-Station2_D100
-Station2_D101
Best regards,
Giannis

This is a migrated post! Originally posted on 19.10.2015 by user giannis4. Please be aware that information can be outdated.