Hi Ron,

Thanks for your reply and links. I should be able to use something like this and appreciate your help.

Regards

Hi Ron,

Thanks for the information on hierarchyid. It looks like something I could use. However I have come across a little bit of a problem. I am using Microsoft Access...

Hi,

Thanks for your reply and suggestions. To answer your questions, yes the database will be normalised.

The CreatedBy will be labelled CreatedByID and will refer to the ID in the...

Hi,

I believe I have solved this one. It involves a fair bit of manual coding for the entire view, but below is the solution for one line:

CASE WHEN EXISTS(SELECT *...

Hi ColdCoffee,

Thanks for your post. I understand your frustration. The code you put in your post with the table structures is suitable for this question (as it contains the missing...

Hi ColdCoffee,

Thanks for the code, but unfortunately it is not exactly what I was looking for. I don't actually want to replace all NULL dates directly with N/A.

You will...

Hi ColdCoffee,

Works great thanks, except for putting the N/A in if the deliverable doesn't exist for that project such as below:

ProjectNameMeetingHeldForecastDateMeetingHeldCompleteDate

Project12010-04-28 13:18:08.3802010-04-29 13:18:08.380

Project2N/AN/A

Project32010-04-28 13:18:08.380NULL

Project4NULLNULL

You will notice that there are still...

Hi ColdCoffee

Thanks for all your efforts. I'll have to get used to posting stuff like this and will pay more attention next time. Apologies for the hassle.

Your answer did get...

Hi John,

Thanks for the outline of the definition of the Synonym for grovelli. I have also found it informative and helpful.

Do you have any input on my security structure/issues in...

Hi,

I think I may have found what the issue is, but am not sure of the solution.

If I go into the properties of a self created role, then click on...

Hi,

These are roles that I have created in the database, so they are not the pre-existing ones (The link you sent seems to relate to the pre-existing ones).

Also, I have...

Hi,

It is actually a table, but it mentions the stored procedure comment when I try to open it. I have decided to reverse the SYNONYM.

CREATE SYNONYM MySchema.SchemaTest

FOR dbo.SchemaTest

instead...

Hi,

Thanks for the reply. I have tested this by changing a table to another schema and then creating the SYNONYM.

When I open the ADP file, it recognises the table but...

Sorry, it's actually ALTER SCHEMA that I was using.

http://msdn.microsoft.com/en-us/library/ms173423.aspx

Does anyone have any input on my second post above?

Hi,

With no responses I am gathering that there is no way around the issue.

If so, is there anyone with experience structuring security on SQL Server Express 2005, with use on...