and if we get really picky:>>>

update... where FieldName Like '_____-%'

Funny this is something like saying I'd rather write 1 = 1 than 1 = 1

If you are concerned...

Correct!

You should not rely in "Default" behaviours for data manipulation instead use type casting to get a desired behaviour (it is good to feel you are in control)

Just to clarify the term a bit: This is called "Pesimistic" locking!

There are other ways to implement this when scalability is a concern. The proposed method above is the so...

Recursion in SQL Server 2000 is something to stay away from! Not only for the limitation in the nesting levels but for the stress this generates in the locking schema...

Hi, its me again

Let me again try to persuade you from following that path because query costs are very relative and depend not...

Andy,

From what the Previous poster did I can see that @Current has the data already agregated!!! you don't need the SUM again!

ex:

SELECT a.StoreName, a.Sales  as ThisPeriod, ISNULL(b.Sales,0) as LastYear

FROM @Current...

Glad to help

I am almost certaint that there is a better way to do that without following this route but that is not the point of my reply. This is a quick...

Farrell, I didn't look at the SQL code you were trying to execute

The reason is that all you are doing is running a...

I would like to warn you about some pointers about encryption of data.

If you use asymetric encription your encripted data will be useless for joins, group by, sorting and indexing!

You...

Farrell that value is the cost in seconds (CPU seconds) to be able to use the SET command with Dynamic SQL you probably need to includ it in the @sql...

you can add columns and drop columns but that's about it when dealing with replicated tables. For that you use sp_repladdcolumn and sp_repldropcolumn respectively. If you need to perform changes that...

Yes XPath in SQL 2000

FROM BOL:

OPENXML(idoc int [in],rowpattern nvarchar[in],[flags byte[in]])

[WITH (SchemaDeclaration | TableName)]

Arguments

idoc

Is the document handle of the internal representation of an XML document. The internal representation...