Of course I find it an hour later.   http://www.sqlservercentral.com/columnists/dcorey/netlibencryptionizerreview.asp

Go to the site's search page at http://www.sqlservercentral.com/search/turbo.asp and look for 'encrypt'.  There's a lot of hits that might steer you in a productive direction.  I thought there was a...

As a general suggestion since several viable solution approaches have been described, you can get yourself into an indecipherable mess if you try to do the conversion and the aggregation...

I don't know if this would perform better in QA, but it's worth a shot:

Set @sql = 'select DOCKEYID from DOCKEY'

  + ' where DOCNBR = ' + @Docno

exec @rval =...

Definitely wrap it in a view, or you'll be doing CASTs for the rest of your life.  I assume you're not doing updates on the date field, that could be...

Though you have a solution, there's an excellent TechNet article at http://support.microsoft.com/default.aspx?scid=kb;en-us;139444.  I had such a problem at a previous job that I created a multi-step SQL script that...

I don't think this is your issue, but there is a condition where a transaction can get hung up and sql server thinks there is something going on and won't...

I used isql extensively for a payroll system that had pretty complicated validation conditions that couldn't easily be enforced through triggers and keys, so I wrote a series of isql...

I prefer not to use the money data type, I use decimal instead.  I've had some funky stuff happen in the past with Access and Crystal Reports formatting the field...

Definitely don't use nvarchar if you can use varchar, the "N" means it's unicode, storing two bytes for every byte of data.  You need the N series of text datatypes...

Off the top of my head....

select 'Duplicate', acctid, Status

from accounts

where status = 'hold'

and acctid in (

   select acctid

      from accounts

      where status = 'billed')

Maybe something along these lines.  With your...

I think triggers will be your best bet.  I've seen similar things, and I would think that in such a situation that you're not going to do cascading updates/deletes, so you...

Books that I think should be on any SQL Server DBAs shelf, both by Microsoft Press:

Inside SQL Server 2000, by Kalen Delaney

Microsoft SQL Server 2000 Administrator's Companion, by Garcia/Reding/Whalen/DeLuca

You can...

Got it!

I got a push in the right direction from a local mail list and got it working.  I added the ability to specify a sort order as a third...

I've received a suggested solution from a local email group using Dynamic SQL:

CREATE PROCEDURE [dbo].[YourSproc]

@table1 varchar(100),

@field1 varchar(100)

AS

SET NOCOUNT ON

Declare @sql varchar(500)

select *

from %EdTableName%

where

   'table1' in [EdTableName]

   AND 'field1'...