I have tried the same and its working properly.

Check the following code.

create table table1(field1 int, field2 varchar(20))

create table table2(field1 int, field2 varchar(20))

insert into table1 values(1,'abc')

insert into table2 values(1,'def')

select * from...

I didnt fiind any problem in executing the above statements.

Must declare scalar variable - this error appears only when u execute the following statement

SELECT @sunday = (Select DATEADD(week, DATEDIFF(week, 6,...

You are trying to create the foreign key before you create the table. check that...