Is there a way to bulk insert from a variable, not a file?
Example:
Instead of this:
    BULK INSERT [dbo].[Inventory_ent_Load_25]

I'm customizing an ERP application that has a SQL Server 2000 back
end. I need to create a few views, stored procedures, and tables in
the database to support my customization.
In an effort to logically separate my custom additions to the

Example Source Table A
Col 1                  Col 2    Col 3    Col 4
01/11/2007    A    B    10
01/10/2007    A    B    20

My SQL database was created using the Access utility to convert an
Access database to SQL.  On the SQL Server, I have a DTS package that
exports the entire contents of a SQL Server table to a fixed-
length .txt file with CRLF row delim.  The exported table's last

I have a date that I am using as part of my select statement:
DATEADD(YEAR, 2, a.SurveyDate)
I need to restict the results of my query to only start with
displaying next month. I need to add two years to every surveydate and

At my last place, they were about to use Oracle Materialzied Views to move
data from a server in Europe to our servers in the US.  If you want to use
Materialized or Indexed Views in 2000 or 2005, could you do it with this same
goal?  That is, could you use an Indexed view to ...

I havent messed with triggers before so I am hoping I can get some
help on this...  I am assuming that what I am trying to do is easy..
First off, I have a test table to just play with temporaily and a real
table that will hold the trigger... here they are:

I have a table with a field called caption when I do
declare @name varchar(3)
set @name = 'ED'
if exists ( select * from Group where (caption like @name  + '%' ))

I have a stored proc that I would like to return a value to Windows OS.  
I thought of using Raiserror to set a code (I want to return an integer
value) so that I could pick up the value in errorlevel.  But using option -b,
I can only get errorlevel to be equal to 0 or 1.

I use openrowset with stored procedures in query analyzer
SELECT *
FROM OPENROWSET
('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','exec

Please could somebody help me with this problem.  I think it should be
simple but I am missing something:
Assuming I have a query that returns something like this:
item     weight    trip

I have created a cursor that uses sp_send_dbmail to mail out an e-mail and
then insert the values into a table, the values are supplied from a temporary
table which is populated with a SELECT statement.  The issue that I am having
is that the last value is always repeated, two ...

Somebody knows as I can keeps Chinese characters in a data base SQL? My
necessity is to be able to as much send reports in English as in Chinese

SQL 2000 v4
How can I get the value used in the having clause? Once I've identified the
elig_ids that have 2 or more servicedates, I need both the elig_id and the
servicedate that contains 2 or more. I don't necessarily need the dupes, one

I have a datetime column when I pass date value, it bails out..
Convert doesn't works
convert(varchar(20),@myDateColumn,101)
cast doesn't work!!! cast(@myDateColumn as smalldatetime)