I need to encrypt some fields in one of my SQL 2000 databases. The fields
are decimal fields and I need to be able to decrypt them too, so a one way
hash is no good. I want to encrypt/decrypt these fields from within stored
procedures but am unsure how to go about doing it. Can ...

I have a sql table called FileInfo, which consists of two columns, filename
and File.  FileName is the name of file to be uploaded, and File is the
content of the files to be uploaded.  The file is located in c:\Files.
I need to create a script to pupulate the name of the file and ...

MY input values
Low Value:
A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be
HIGH.

I have a table can MemberSSN, which consists of MemberID and SSN.  I want to
generates a list of of all MemberID and their SSN, to a files called
MemberSSN and ouput to C:\.  
I  have an encryption key called Company.asc stored in C:\encryption, and I

I got the output from a view as following:
Part#   Project#  ModDate Status
100-1    100A       01/10/08  A
150-2    200B       02/10/08  A

Here is what I have so far....
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

In the following data I need to select (or isolate) the codes (code groups)
which contain a max codeDate of '12/31/08'.  Of the codes a, b, c, d  -- only
codes b and c contain a max codeDate of '12/31/08' in their respective
groups.  What would be the tsql to isolate these 2 ...

Where can I download CONMOM database which was used in C# 2005 Appdev
video tutorial.
Please help
Thanks

I'm trying to run a query that produces data from three tables, in essence
these are Location, Category and BannerPeriod, They all have a secondary key
of SiteID and are linked by this, really there are two stages to this query,
Stage 1 produce a complete combination of all ...

I know if I want to write a SELECT statement which TABLE could be "variable"
I should use "Dynamic Syntax"... but
Is there other way to do so? I mean, something in which TABLE in SELECT
works like a "@Table" variable.

I have a table, Orders table, that has a values for its comments field like
e.g
01/02/01: My text with a leading space
01/02/01:My text with no leading space.

I'm picking up a project (VB.NET) I started a few years back that stores
thumbnail images 200X200 maximum along with a few columns of text.
Currently it uses Access.  As for records, that depends on the user.  I
don't foresee a user ever going over 200,000 records.

When I issue the following search criteria 07/06/1975, my SP returns records
with 06/07/1975 as a match.
I need my dates to match the UK format i.e. dd/mm/yyyy.
TIA

I'm trying to create a query that shows duplicate entries on 3 fields
Table structure
   - Rough ID = Unique
   - Road_ID

I need to store a list of paths in sqlserver. The paths just have a start
and end point. It is currently stored something like this
CREATE TABLE Lines (
LineID INT,