I have activity dates in a file.  these dates can be any day in the month.  I
need to force the date to be the last day of the month in the activity date.  
Any help would be appreciated.  Thanks

Hi, Is there a way on SQL 2000 to shrink a Table ? I have a Table with 1.1GB
Unused Space (sp_SpaceUsed) and could shrink it to 20 MB. Thank

This SQL:
SELECT LanguageCode, LookupID, LanguageText
FROM  tblLanguageValues
is producing this XML:

When I run a bulk load I get the following error when I use a standard
non-xml format file which has been proved to work when used with BCP:
"9422    Bulk Load Error:XML parsing: line 2, character 0, incorrect document
syntax"

Windows 2003 server, using SQL Server 2005.
We have created a Linked Server to Active Directory and have a table that is
populated based on the users (EmployeeList).  The EmployeeList table has an
identity column that we would like to use as the EmployeeID in AD, updated

I have a part number like this 101I/2505366C91 and I need to evaluate part
of it like this.
If the three numbers after "101I/" are "01_" , I need it to say "Frame"
If they are "125" I need it to say "Engine cooling"

I was wondering if it is better/worse to have 1 SqlConnection as a
public object and initalized after i.e. the login to the application,
or to reconnect each time before some database action is needed in a
piece of code, and of course to deconnect directly after having

I have a table and I want to search two columns for text entered by my
users, which could include multiple words.
I'm looking for suggestions as to the best way to approach this. I'm
familiar with "LIKE %term%" syntax, and I have MS SQL Server 2005, which I

I've been reading along from time to time and have had questions
answered in this group before that were very helpful.  I've had a
question itching me a little lately and wondered if someone would be
kind enough to answer it for me.

This is the function I call:
SELECT * FROM [BIBOM].[dbo].affiches
(207,'10132,10592,11156,11175,11382,11450,11453,11470,11604,11660,11667,11671,11685,11689,11700,11705,11720,11724,11729,11738,11766,11780,11783,11785,11786,11788,11789,11799,11806,11812,11845,11853,11856,11857 ...

I have a very weired random foreign key conflication issue.
1) There are 2 tables: Patient and Admission.
2) The patientID is a primary key in Patient table.
3) There is a Foreign key limitation in Admission table, which references

I am enjoying and learning from Joe Celko's book SQL Programming Style. In it
he often mentions the concept of a data dictionary. For example, on page 8 he
states a scalar data element should "Be unique (within any data dictionary in
which it appears)." I have been using SQL ...

My Select statement worked just fine.  I have to add this WITH to the Select
statement.  It's not joining correctly.  Can someone help me out.  Besides
fixing this for me, can you also explain what I'm missing?  I know it's got
to be something simple and I'm just not seeing it.  ...

I'm just mucking about, and wanted to test that a ROLLBACK removed any
#temp tables. And it does.
BEGIN TRANSACTION
PRINT 'Begin'

Inside a UDF i'm trying to insert rows in the result table:
   CREATE FUNCTION dbo.fn_Strapons (
    @UserGUID uniqueidentifier,
    @AssociateNumber varchar(50))