Rich,

unfortunately, there is no way of removing the indentity characteristic from the column. Catalog updates are not supported

Sorry about that, I posted it before I got your update. I'll edit mine out

The answer is it depends. I don't have your table layouts or sample data, so I don't know what the specifics are. What you can do is take...

*** Edited *** same example as Sean's

First of all, why would you want to drop all of the identity columns in the database? These are usually use as surrogate keys amd there may be other...

Try something like this:

declare @transaction table (WorkerID tinyint, TransactionDate smalldatetime, laborRate decimal (6,2))

insert into @transaction

select 1, '2011-01-03', 100 union all

select 1, '2011-01-04', 105 union all

select 1, '2011-01-05', 95 union...

The data you provided doesn't match your expected results. Try this:

declare @Propertymaster table(ID int,

PROPERTY_STATE char(2),

PROPERTY_COUNTY varchar(15))

insert into @Propertymaster

select 770885,'PA','Philadelphia' union all

select 778460,'AK','Anchorage' union all

select 778461,'CO','Douglas' union...

From BOL: Groups a selected set of rows into a set of summary rows by the values of one or more columns or expressions. One row is returned for each...

Jim,

without the table layouts and sample data, it's hard to give you code that will work. With that said, it looks like you are getting the Max(LaborRateID) instead of...

I don't have a 2000 test environment, but you can try this using XML

create table #T (

ID int ,

Val varchar(100));

insert into #T (ID, Val)

select 1 ,'A'...

Here's a generic dynamic sql statement to generate your pivot table. Keep in mind that if the list of distinct names is long, this will take a while to...

NOTE: The first code is much more efficient. Just based on the sample data the first had a scan count of 2 and logical reads of 2, while...

what have you tried? I won't provide the code right away, since it doesn't look like you've given it a try. Depending on the size of the table,...

wrong post

do you have any examples of what you are doing? It's easier if you provide code, sample data and expected results instead of some ambiguous urgent request