Jack,

You are awesome. And thanks to all other contributors. Great information and i now have a clear direction to go along with efficiency in how to structure the design and...

Thanks for the alternatives Brandie.

I think for sake of overbloating my table design i will probably go with the Users (1) to Payments (many) table design and just JOIN...

Thanks for both comments. I agree with your logic for checking login authentication based on current dates compared to the Expiry dates (even minutes, hours, seconds), however....

If i do not...

As i said above, if you are using the eWay credit card web service then you won't be able to authenticate the user credentials unless you write your own VB...

I changed the way i triggered the payment system for Tokens with eWay due to the SSIS 2005 limitations and the fact that i don't have SSIS 2008.

Instead of...

Thanks. That's what i was thinking as well. Apologies i didn't run some tests in SSMS first.

I thought Option 2 was the better format and made the most...

Thanks to both of you. Great feedback and a big help.

I will definately use the SQL Generator app. It seems perfect for what i want plus it generates the .NET...

I did a google search on this but can't seem to locate the specific application.

Do you have a website reference or a download link?

Wondering also if this is a...

Apologies to all. I need to get better at the proper definitions and schemas in my post. Will do so in future.

As for the last post that is spot...

I see.

Just having a quick read about the Remote configuration set up for ReportViewer, so you have just confirmed the direction i was thinking about.

Thanks for the input....

I didn't explain that very well.

I am a web developer that provides and Administration login section for my clients to manage their data and front end website. Each client...

Both excellent suggestions and i will approach the same.

Perhaps the single table stock control would suit me as i'm not dealing in vast amounts of products or quantities and...

So if i understand this correctly...

Are you saying that your Products table does not actually need a column for Stock Count?

But instead you use the ProductID to link another...

Yes. SSRS is set up on the same machine (my Laptop running Vista Ultimate) as my Database engine and all other services and components.

And yes i am getting the login...

Thanks for the link. I hadn't thought about video. Maybe youtube also has some helpful tutes.

Also, do you think i should install the instance name exactly the same as the...