I was able to do this through dynamic sql in a stored procedure.

Thanks all for your help

I figured it out sql browser was not enabled, anyways got to know few more things which will help me trouble shoot related issues.

Thanks

Terry, Thanks for the reply, I tried your query below doesnt seem to work below - there is a little change the tables

Please dont think this as a puzzle...

perfect very clever and very dumb of me!!!

Thanks for the info Eric

One more question is it safe to patch the SQL Server with SP2, or do we have to wait for any validation from Microsoft or any...

when I the above bcp code I get the following error, I am not sure if my server settings are wrong

any ideas??

SQLState = 08001, NativeError = 17

Error = [Microsoft][ODBC SQL...

Loner,

Thank you for your response,

I want to be able to do this in sql server 2000, and hence I posted under forum too. I tried to use BCP utility but...

Can you please post in english, I dont understand spanish

All I want to do is the following

I have 2 select statements

select * from employee where daterecorded between '11/01/2006' and '11/31/2006'

select * from person where id in (select id from...

Thanks for the reply Roi, but I need an update statement to populate the column.

Thanks

JeffB, I think this statement would work, I have question though

will the data be inserted in the tablea in order that the names appear in the source table, I...

Sorry about that I reformatted and posted it

Guys,

I have a follow scenario which I am trying to solve

gr# toname fromname

_________________________________

1 John Doe John...

I created a tempid column and populated it as an identity column (this way I have a unique column) but still that doesn't work in my cursor any better ideas???

role   seq     ...

new id will allow me to display the single combination of role 1 and 2 with same id (new one), which is not possible with the existing id

role seq          id             ...

right now as shown in the subset data only ID is populated, I need a way to populate 'modifiedid' column with the values shown in the example

Thanks