Viewing 13 posts - 1 through 13 (of 13 total)
I executed the code and added the tables to the diagram but it gives it a one to many relationship , which contradicts what i need to put , because...
August 14, 2008 at 6:39 am
Grant Fritchey (8/13/2008)
August 14, 2008 at 4:21 am
ive never really been taught about parent and child , i think like this.
one property manger manages one property.
one propert has one property manager.
i need a 1-1 relationship , ...
August 13, 2008 at 8:15 am
Grant Fritchey (8/13/2008)
Can you post the scripts you're using to create the tables? There may be something there.
USE [e5053759]
GO
/****** Object: Table [dbo].[Property_Managers] Script Date: 08/13/2008...
August 13, 2008 at 7:12 am
steveb (8/13/2008)
try casting the weeks to integers
Select Property_Name, Sum(cast(week_1 as int) + cast(week_2 as int) + cast(week_3 as int) + cast(week_4 as int))
from Profit_Records
where Type_Property = 'CASTLE'
Group by Property_Name
Ok so...
August 13, 2008 at 6:19 am
I get this when i execute that code
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the nvarchar value '£307' to data type int.
should i change the data...
August 13, 2008 at 5:31 am
Ahh you absolute star , i get this when i execute
Msg 8117, Level 16, State 1, Line 1
Operand data type nvarchar is invalid for sum operator.
what do you suggest i...
August 13, 2008 at 5:23 am
steveb (8/12/2008)
It looks like it is an issue with the data that is currently in the tables, are you able to clear out the tables then create the relationship?
Yeah...
August 13, 2008 at 4:04 am
Also , i have tried putting porperty_ID as the primary key in propery managers and it works fine , is this acceptable for me to have property_ID as a...
August 12, 2008 at 5:14 am
Ahhh so in the attirbute pro_man_ID i have entered say 9987 but it should be 9988 for example ?
thanks for your time , san
August 11, 2008 at 9:49 am
There is a lot i don't understand about that , but that is why i am going to research it further , the assignment i have uploaded is...
July 6, 2008 at 3:03 pm
Thanks guys , i understand exactly where your coming from.
Its not a sob story or anything , but because i had a lot of work on top of me i...
July 6, 2008 at 6:33 am
Hello there , Ive uploaded the assignment and my work on it so far , your help would be much appreciated , i just need to know if i am...
July 5, 2008 at 5:51 pm
Viewing 13 posts - 1 through 13 (of 13 total)