create SQL View with calculation

I forgot to mention performance is critical as tableA contains 3,000,000 rows and grows by 50,000 rows per day.

tableB only grows by 1 row per day. (60 rows at present)

i'll add inserts for the test data in the next post :-)

CREATE TABLE [testdb].[dbo].[TableA](
	[aDate] [datetime] NULL,
	[aNumber] [smallint] NULL
) ON [PRIMARY]
 
CREATE TABLE [testdb].[dbo].[TableB](
	[bDate] [datetime] NULL,
	[bNumber] [smallint] NULL
) ON [PRIMARY]

Select allOpen in new window