It has been two days since the idiot gentleman last posted a taunt.

It appears that he finally realized that he is an amateur in a professional forum, proving the old...

Deb,

I took basically the same approach you describe but I combined steps 3,4,5 in one SQL task  (text below).

If you want to use VB, I'm always in favor of using...

"how can  i create a temoprary table every time the DTS is run without haivng a permanent temporary table and store the data from csv file into ti. Could you...

I just found this thread and have really enjoyed reading all NINE pages.

I have read the original question and  the evolving dimensions of the question. Factually, it would appear that he...

The editor replaced a closing parenthesis with a winking icon.  You'll probably have to add it to get the Create Table statement to work.

Erik,

This is what I came up with last night.  Hope it is in time to do you some good. I made assumptions about the actual data you will have, so...

Will this app price only blinds and verticals?  Anything like cabinets, or other products not tied to a length and width?

Do all companies sell all blinds? If not, maybe you...

Erik,

I want to give this one a little thought too.  I'll try to post something manana. 

For clarification, do you forsee a possibility that an item could have both a...

 It is great to see someone planning a database rather than jumping with the 'Ready, Fire, Aim' approach.

If I understand the question, each user will select a product, width, and...

Having read the recent posts, I am very curious about Joe Celko.  I assume he is a strong supporter of natural keys? 

Does anyone have a link to something he...

Harry,

This looks a lot cleaner than the first version.  If I understand your last post, I agree that in the CompanySeasonProductTemplate table, you could create a composite index on CompanyID, SeasonID,...

This question illicits the same type of furor as Windows vs. Linux, Wintel vs. Apple, and 'Tastes Great' vs. 'Less Filling'

Personally, I don't see a down side to using a...

I think your second schema (id=554884) is cleaner than the first.  you've removed the redundancy of storing SeasonID in multiple tables.

I, too, am unclear on the business requirements so I'm...

Yelena makes a good point about emailing performance data from within the databases. 

I am not sure from your question what kind of monitoring the vendor will do.  If they...

A good resource for such things is EventID.net.  You need to use MSSQLServer as the source.

According to the two posts there, this is purely informational.  However, I would question why...