I know this is probably not the most efficient way to do this, but it's the
only way I know how
I created a DTS package throught the SQL 2000 Import Data wizard - -
unfortunately, there were around 30 million records that are being copied

Here are the two tables I have.  Each sponge run has multiple weights
associated with it.  I need to create a pivot table to list one run per row
with weights_# in 1, 2, 3, 4, 6, 9, 10, 19.  I started the query below, but
I just can't get it to line up on one row.   :

I have fairly lengthy sp that on some occasions will select data for "All"
(CustId's e.g.). Or other occasions there is a variable that represents a
concatenated "List" of (CustId's). -- with a function to turn the list to a
temp table

Using SQL 2000.  I am trying to join two tables in a query with a one to
many relationship.  Trouble I'm having is I only want to return the top 5 of
the joined table records.
What I have is an inventory table and a history table.  So for a given list

Hi all, misters
I want to create a stored procedure for create severals stores procedures,
using some parameters
Any sample about it, please ?

SetDefaultInitFields is confusing, and poorly documented.  I'm on SQL
2005 and Visual Studio 2005, and .NET 2.0.
I am trying to tell SMO to fetch a bunch of table properties in one
call, since the server I am reading from is remote (through a VPN).

Is there a
DBCC SQLPERF
(or other syntax)
command to "reset" the indexes that show up in the "Missing Index" report in

I am trying to write a stored procedure to select a record and update.
So far I have :
PROCEDURE GetNumber (@NextID Nvarchar(16) OUTPUT) AS
UPDATE Table1 SET DateUsed = Getdate() WHERE ID = (SELECT TOP 1 Id FROM

Can anyone help me create a function that will accept a string of words,
 then remove any that are listed in a noise word table, add any that
match in the thesaurus table, and returned to whatever called it?
Cheers,

As DBA's, do you have a preference to how code lookup tables are built?  For
example, say I have the need for a number of lists of selectable values in
an application.  The first is customer status, the second is salutation, etc
etc.

We have a SQL Server 2K5 DB Application (with Merge Replication Involved) and
we were having performance issues with Reporting (they took too long to
generate).  We introduced Maintained Views to reduce our reporting times and
discovered that most of our data input functions ...

I am working on an insert SP, but now it will not execute.  I have given it
4 minutes, although it still doesn't execute.
Here is my SP,
CREATE PROCEDURE InsertEmployee

I'd like to write sql code that takes the results of some queries and
dump them into excel.  I'm told you can use bcp to do that...but I
also want to format the results - all without leaving sql.  So for
example I'd like to make the column headers bold, etc.  I'm told bcp

I find this at:
http://www.sqlservercurry.com/2008/06/combine-multiple-rows-into-one-row.html
==================================
-- Query to combine multiple rows into one

Is there a TSQL function similar to the MS-Access
"DateSerial(Year,Month,Day)" function, that will convert values for a year,
month and day to a date?