All excellent suggestions and i will take all advice for the separate User and Subscriptions tables.

To keep the post short i did not mention all other fields i use...

I agree with your separation of tables for Users and Subscriptions.

At least this way it will allow multiple yearly subscriptions based on expiry dates and paid amounts.

Do you...

We do have named instances but set up using TCP/IP standard ports, etc.. for web development work from our local machines, so hopefully connecting should be easy enough. We have...

Perfect Andy! Well done.

I posted on your first video asking for a new video explaining how to delete and update using FK's and this has delivered!

I'll be jumping...

Nice Video and a good intro to foreign keys.

My interest in FK's are more specifically related to the deletion of data between joined tables.

Eg.

Table 1 - Orders

Table...

What about an XML resultset type?

I have a rather complex SQL statement which uses FOR XML PATH to produce an RSS XML Output. I am then trying to pass...

Thanks again to both of you for your expert comments. That's why i love this forum! So i can get inside the brains of the people that know.

As for...

Thanks for those comments.

The script you attached below is virtually the same one i've created in SSIS and what i planned to use for CLR.

I have just finished...

Thanks for the excellent responses. I agree the deletion of data is not the best solution. Status updates are always the better way to go.

I will look at the...

Thanks for both posts.

So if i understand this correctly:

1) I can still keep the foreign key relationship on my orderdetails table?

2) If deleting an order, i would have to first...

I'd prefer to install IIS 6 to match another production server currently running so i assume i can download that and install onto Vista Business.

Thanks again.

Thanks to both of you. That is exactly the simple answer i was looking for.

I assume IIS 7.0 is the way to go as i will be using this...

I agree the order of package installation does matter a lot as well as versioninig.

Hence why i want to go back to the beginning and not clash with any...

I've now done several uninstall/reinstalls and still the same problem exists. I've read a number of posts and a lot of them say the Visual Studio 2008 components cause issues...

You might want to look into Conditional Splitting.

Set your Excel file as a data source and pass each row through the conditional split. You can send each row of...