In an effort to give you a clear idea of what I'm doing, I'm going to give
you as much info as possible.  Hopefully, this isn't overkill...
Background:  I have 2 select statements which both count the number of units
of products ordered and I'm trying to combine them into one list ...

I am a newbie to SQL server. I am trying to using SQLXMLBulkLoad. All I am
trying is to insert a record into the PUB db.
The following is the error msg
Error Source: Microsoft Data Transformation Services(DTS) Package

Can anyone tell me how to change the names in a column to small cap.
e.g.  
Name
Jane

If this has been answered already, or is better answered somewhere else, then
please let me know.
I need help with a query. I have a table with many fields of information
about servers and network equipment. IP address is the Primary Key. I am

Server: Msg 170, Level 15, State 1, Procedure SWR_Save_Work_Orde, Line 10
Line 10: Incorrect syntax near 'SWR_Save_Work_Orde'.
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error
Code:

Please Help...I've tried everything I can think of with no luck.
Given the following tables:
PERSONS table with a (unique PERSON_ID), SIBLING_ID, BIRTH_DATE, SURNAME,
FIRST_NAME

Hi Expert,
How can I do this without enter 100 time every day?
insert into [tablename] (column1) values(1)
insert into [tablename] (column1) values(2)