Justr remember that Imceda wants you to buy their encryption solution.  I'd be concerned that the encryption key has to be accessible to those same people who would likely have...

Why do I think that this is a homework problem? 

If you don't have to return results when the SUM is zero, you could try using:

HAVING SUM(dbo.rep.repCPAPrimary) > 0

To my knowledge, HIPAA (Health Inofrmation Portability and Accountability Act) doesn't require passwords per se, but rather requires you to keep PHI (Private Health Information) secure from people who shouldn't...

That is unusual to have dynamic SQL out-perform compiled, but that makes sense, because the comiler and execution plan optimizer know exactly what the "like" comparison is in that case.

The first query has to do a table scan because you use a variable in the "like" portion.  Table scans are always used when you have a like comparison to...

Wouldn't this ASP.NET code work as well?  Though it may be better practice to let your server do more of the work, as you have done already.

If (Not...

I've asked the software vendor to run in 2K mode, because then I could use later features such as "TOP 10" and user functions, but they say it breaks pieces...

The getdate() function returns both the day and time parts of the current date.  That is why your initial query failed.  Converting to format 112 gives you only the date,...

The test is supposed to be tough.  Certification means something to both employers and professionals because it isn't easy to get.

You'd set up a many-to-many table that relates the SKU (item) table to the color table.

Item_SKU -- Item_Colors -- Colors

Then to find the color, you'd write a query to get...

I don't think you'll find a tutorial that will meet your exact needs.  Are you hoping to find something you can cut-n-paste that will de-dupe your DB?

Perhaps you should contract...

There are way too many options and compatibility settings that change the answer to this.  My production DB has to run in 6.5 Compatibility mode because of the vendor application. ...

This will return multiple spaces in the case of NULL fields, as concatenating a space with NULL returns the space.

I'm not sure how "understandable" this will be, as the algorithm is very complex, but here's an implementation I found on the net some time ago.  (The ) are close...