OrderNo    Customer        EmpID    FName    LName
1000003    ROYAL BANK SAUDI    191    Jill    Banks
1000003    ROYAL BANK SAUDI    7116    Andy    Schmidt
1000003    ROYAL BANK SAUDI    7014    Dave    Pennel

I have some approximate timing statements scattered in a proc that uses
GetDate() and subtraction to see approximately how long various steps in
the proc take.  My code does this:
Declare @StepTime Datetime

I think this is much simpler than a cross-tab. I'm just trying to take the
output from a query that gives me from 2-50 rows and output each of the rows
for one column as a column in a single row. The new column headings make no
difference.  I really just want a simple way to take ...

Is it possible to execute 2 different statements at the same time inside
stored procedure?
For example
UPDATE table1 set col1=.......

Does anyone know of a web site out there where I can find ficticious personal
data, name, address, phone, e-mail, for testing purposes???
Thanks in advance for your help.
PSULionRP

I am trying to get rid of all customers who match themselves in this
query that are in the same state however even with the not equals in
the where clause it still gives me the repeats.  Is this a  change in
SQL Server 2005 from 2003?  this is a self-join.

To one of my queries yeterday on table partitioning in sql 2005, I got the
following response:
"Partitioning is mostly for manageability rather than performance.  The key
to performance is largely query and index tuning.  4 million rows is not

I found the following code as a SQL statement being used by an SRS
report, it does not seem to work and I was curious as to what this is
attempting to do.
The error message states at the end

I have a temporary table that a number of sps insert date into however I get
the following error:-
Insert Error: Column name or number of supplied values does not match table
definition.

UI    Source        Order    Amt            Category
4901    OracleEMEA    111044    -32747.990000000002    Booking
4901    OracleEMEA    111044    -22814.380000000001    Booking
4901    OracleEMEA    111044    -3636.1700000000001    Booking

I am using Windows Authentication Mode in SQL Server 2005. I would appreciate
if anyone let me know the connection string which I used. Both the web server
and database server are on domain....
Which user I have to mention in the connection string.

I have a web app that is passing a parameter to a stored procedure that is
pivoting the table. The param is going to the stored procedure as "NE, SE",
on the proc end how can the proc take both values and return the data that
equals "NE, SE"?

I'm wondering, is there any simple way to insert data
into two tables, one of which acts as master
(base class in OOP, maintains PK), and the second
is slave (specific subclass, holds some additional description

      I am newbie to MS SQL server 2005. I am writing a stored proced
which uses a system provided stored procedure. I can succussfully call
the sytem stored procedure but i don't know how to access the result
set inside a stored procedure. Can you pls explain the way for that?

I have a situation where I need clients to reserve an ID before they start a
request. It's possible than several users may try to reserve the same ID. If
that happens, whoever gets there first gets it, and the rest should try again.
My question is, if some sort of race condition ...