Okay, corrected the code for SQL 2008 (at least this is what worked for me).

/* create the basic table structures needed */

CREATE TABLE [X_DIMENSION]

( [LOC] [int] NULL , [X_ELEMENT] [varchar] (2000) NULL )

CREATE TABLE [Y_DIMENSION]

( [LOC] [int] NULL, [Y_ELEMENT] [varchar] (2000) NULL )

CREATE TABLE [X_Y_INDEX] ( X_LOC [int] NULL, Y_LOC [int] NULL )

/* Now we create some data to place into the tables, indexed */

INSERT X_Y_INDEX (X_LOC, Y_LOC)SELECT 5,7

INSERT X_DIMENSION (LOC,X_ELEMENT)SELECT 5,'DATA IN ELEMENT 5 '

INSERT Y_DIMENSION (LOC,Y_ELEMENT)SELECT 7,'REMAINING

DATA FOR ELEMENT 5,7'

DECLARE @X INT, @Y INT

SET @X = 5 -- or whatever method of loading you wantSET @Y = 7

SELECT A.X_ELEMENT + B.Y_ELEMENT FROM X_DIMENSION A, Y_DIMENSION B WHERE A.LOC = @X AND B.LOC = @Y

/* The Query returns the concatenated value! */

/* DATA IN ELEMENT 5, REMAINING DATA IN ELEMENT 7*/