Click here to Skip to main content
15,899,634 members

Comments by cnh 2 (Top 3 by date)

cnh 2 25-Apr-13 15:11pm View    
multiple Entries for the same Booking_ID was referred to my WagesEntry Table ... the only reason I set the IDENTITY INSERT was to create some sample data ... anyways ... I think I get a way around it with Filtered Indexes and Constraints ... I hope :)
cnh 2 23-Apr-13 16:49pm View    
I've just updated my question - the View works fine, but it doesn't allow me to use the value for our Employees when they actually enter data onto the specific table ... a cross reference would be lovely, with a Check Constraint that refers to the Calculated Value of the Field in the View ... I just have no idea, what' possible and what's not - must be coz it's 4 am here ... thanks for the help so far anyways :)
cnh 2 23-Apr-13 16:31pm View    
Sorry, my English is not the best as well ;) ... I mean to link these tables in a View is simple and to create the Compute VColumn on it as well, I just can't get it done on Table Level ...