Insert into #table (col1)

select TOP 100 ROW_NUMBER ( ) OVER (order by sys.columns.object_id) as 'rownum'

from sys.columns ,sys.tables

Gail

Now i could be completely wrong....but

would'nt it make derived table queries slightly more resource intensive than using temp tables. I mean to say that using temp tables we could do...

Hi

IMHO.. there is no need for a GUID. They come with a performance drag specially when you want to query a large number of rows. RbarryYoung's solution would work...

Are you sure that such a value '8d8r57h4r774gqt649rj90rkjdfnhnd9' exists in the column.

What does select pass_word from login where oldpass_word='8d8r57h4r774gqt649rj90rkjdfnhnd9' return?

Whats the size of datatypes

Hi

Why do you want to insert the production data in to development. ? And what are the triggers for? Do they have any purpose other than inserting data into devlopment...

Does'nt seem to work.

Are both the databases identical in every way - table structures , constraints etc

How much data are you looking at?

I assume you would want to port the data from production...

Are you able to connect to the remote machine?

I agree with all the wonderful things said about SSC.. it could not be more true.

How ever i hv seen a couple of wall flowers who joined long time back,...

Brilliant Divya and Lynn

check this great article

http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/

Mostly...;)

Hi

Iam working on a proj with a very similar scenario.

First Iam the DBA and i change the procs and have the final call on them. This makes it easier to...

Check out PIVOT operator