that ERD must have taken you hours!

+1 for Redgate.

I spent a day writing an update script, RGT did a better job in 4 minutes (I had forgotten to refresh a view after the table meta data...

rather than copy data between tables do one of the following:

either have an additional column in the table with the datestamp to identify the version of the record, OR

Create two...

With Excel and SSIS it could be a whole host of reasons

Just some of the ones I have come across in the past

Excel 64 bit installed on a 64 bit...

+1 for Michaels suggestion: Pay to have the list cleaned:-)

SOUNDEX is a good start but is designed to work with Anglo-Saxon pronuciations

You could try pattern matching by removing vowels and...

and if you drop them both into a sequence container within the For Each Folder loop then you can process them in parallel

I don't like the join of BOM

you are filtering the join based on properties of RO - these feel to me like they should be in the WHERE clause.

If you...

Hire a DBA from Freelancer / ODesk (Or ask Gail nicely - she really knows her stuff!)

Front end development, back end development, performance tuning and database security are separate skills...

Or partition the tables based on date; this gives you the best of both worlds: Performance where queries only need to hit one partition and full dataset (at the expese...

That solution is fine as long as all the possible status codes are known. If they are not then you would need to use the PIVOT() function along with...

Rather than use a CASE statement, I would create a new table for the multipliers and then join them to the PackType table. If this is to be used...

the OP said that the number of <TD>s could be 1..n.

A solution that limits the number of columns could result in sparsely populated columns and/or some of the data elements...

Please explain how you fixed it so that other users reading this thread havn't wasted their time.

Obiron

I would take the original query and wrap it in a CTE (common Table Expression) then join the CTE back to the original table. IMHO it makes the code...

60 seconds in a minute,

3600 seconds in an hour.

You will be looking for the FLOOR() function and the MOD operator

FLOOR(200 / 60) = 3

200 % 60 = 20

200 Seconds...