PLEASE!  If you want help, post the offending query that gave you the error!

Good lord, NO!!!!   Vamshi, I know you're kinda new at this, but holy mackeral this is bad!  And, if you didn't write it,...

Just an FYI...Don't forget the other difference... UNIQUE key allows 1 NULL as a value... Primary Key won't.

And, you can also build a PK without it being clustered, although there...

Anthony... it's bad form on this forum to post the same question more than once... ticks people off.  Go to your other thread and read what I posted.

I believe it uses the TAB delimiter for Excel spreadsheets...

We had several procs with such lineage... the problem was that the main routine (forgive me for calling it that) had the BEGIN TRANS in it making for a very...

Heh... first, your not auditing changes, you auditing the insertion of new data.  If you want to audit changed, then you need to make the triggier FOR UPDATE, instead.

I've seen...

Use your sample table... I just created my own and posted so other folks could see what's going on. 

If that's not what you meant, you need to explain to...

Hell, I know that DC... I'm not the kind of person who will go for a 10 second run when the current run is only taking 30 seconds on a...

To continue the analogy...

You have a small leak in a pipe that you noticed and you call the plumber.  He shows up in a well used but very clean truck. ...

Cool... someone actually does read these   Thanks for the nice feedback, SDM.

Alright... first, I hate "Adjacency Models"... they're relatively slow and I hate recalculating things every time I want to look something up.  Second, product tables don't change that often so...

The neat think about counting Pennies is that the Dollars take care of themselves   Add the following to the end of my script...

Case in point... I'm sure they thought it was pragmatic to do so, at the time...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=386825

... their batch job jumped from 16-20 hours to more than 70... and they...

Yes... they are articles... but you don't have to go far to find them.  When you installed the client side of SQL Server, you should have also installed "Books Online". ...