Sorry mate, your job-title has quite a play...

Looking into your job-title I can recommend hiring some programmer with SQL and/or SSIS skils.

This work can be done in Excel using Excel VBA or any other programming language which...

frfernan (9/29/2010)

---

...

as far as I know a clustered index is best for sequential reading. If you create a clustered index using Attrib_Z, any query like

SELECT * FROM Widgets WHERE Attrib_Z...

one more url:

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/cf9121b2-38e0-4735-b765-4eab91bb443b

scott.pletcher (9/27/2010)

---

I wouldn't create a clus index on an ident column. That will not help your queries. In fact, you will reduce the chance of using a nonclus...

You have primary key clustered index on your table, is it incremental?

What your triggers do?

"forever" is relative term. What is your "takes forever" means? does it time-out? Takes seconds?...

Which table contains producers/makers?

Happy to Help!

umanpowered (9/26/2010)

---

...

The goal is to eliminate the duplicate data in C1. So if it was

B | X

B | Y

A | Z

The goal would be for the query to return

B...

check what is row delimiter in your header row, is it the same as for your daa rows?

Note: by default BCP uses (new line character) for row terminator...

It does look like the table in your eample is populated by some PIVOTING query. I would recommend to have a look it and see where data is comming from...

bitmask "nerd-kind" variation :-D:

;with stbb

as ( SELECT 5 AS Status, 1 AS BitMask UNION

SELECT 6 AS Status, 2 AS BitMask UNION

...

BTW, I've tried your script - it works for me.

The...

What it returns to...