Relative Content

Tag Archive for sqlsql-serverssms

SSMS table cascading

I have a table in SSMS, there are 3 columns that represent room, aisle and box. the way these columns are set up is the room has aisles and the aisles further have boxes. what syntax can be used to fetch data for all the possible cascading combinations in the three locations. For instance, a room can have 3 aisles and each aisle can have 6 boxes in it.