I know this is a hard question, but suggestion at all would be great.

After reading this artical http://www.mssqltips.com/sqlservertip/1485/using-sql-server-indexes-to-bypass-locks/ I added a INDEX to my table in question, added a few transactions and added predicate parameters to each column that comprised the...

I've managed to get beyond the Key lock by using this little snippet. I'm not sure if I'm moving in the right or wrong direction?

create nonclustered index ix_Horizontal_ID_included

on [Storefront].[Horizontal]...

For these two tables it is ok to have dirty data. Is there any way that I can set a feature on these tables to where there is never a...

Did you see the attachment i posted?

Is it possible to cascade on delete from the sidelite table to the size table since the FK is in the sidelite table?

Ok, I've scripted out a few tables and each one of these need to have one finish association for each new row added to their entity.

Basically, I need to know...

I have attached a file with the DDL so you guys can create a little schema.

I have also attached a screen shot of where the finish info is coming from,...

Thank you very much for taking the time to answer my question with the code ready to go!

I am very grateful!

Erik

Thanks!

I've DECLARED the Count variables to =0, this should set them correctly unless i am wrong. Everything evaluates correctly until i get to the part in question, which is the...

After reinstalling my report services everything seems to be connecting just fine.

I will have to admit, this AD with Reporting Services was rough!

I have one last error, and I...

Thank you guys for all the help !

I know this is going to sound crazy, but that Quote table will turn into it's on product table after the shopper request a quote. The QuoteID is the ProductID...

Yes,

The line item in the OrderDetail table on column ProductID can represent either the FK_ from the utbQuote table or the utbProduct table.

What a great piece of code and a great way to implement this...

Keeps me from having to do a IsQuote BIT column...

Thanks for the professional help !

Erik