All of the procedures (over 60 of them) need to be in the same format.  I created a process that executes each of these and moves the data into a...

That works, thanks.  Now I am running into the problem with the SELECT INTO and no column names being specified.  I want the process of making these procedures real easy...

I just tried it with a real table and that worked.  Thanks!

I tried this and it keeps returning 0.  The syscolumns isn't updating with the temp table.

Does anyone use SQL Source Control from Skilled Software?  I think I have decided on purchasing this, I am just a little skeptical if I don't have any real people...

Thanks everyone for their input, I am going to try a bunch of options.  Since this is an overnight process that crunches and rebuilds all the data, it's going to...

Thanks Wayne!

We don't really have a development server so it's all on the fly and the process runs overnight and the business doesn't...

Thanks everyone for your suggestions, I think I am going to go ahead and break out the procedure and put the smaller procs into a job (like Jordan suggested). ...

That's no good! Thanks anyways. I don't have a client that does this, it was just going to be a job.

Antares, is this what you use? This is what our dba uses as well and every once in a while the CPU peaks between 85 and 95% and so...

Check out the IDENTITY function.

IDENTITY ( data_type [ , seed , increment ] )

You have to do a SELECT INTO statement.

SELECT Name,

IDENTITY(INTEGER, 1, 1)

INTO #TempTableName

FROM tablename

SELECT...

Have you tried:

select max(col1),

max(col2),

max(col3),

max(col4),

max(col5),

max(col6)

from tablename

?

Thanks everyone for your help. The db was created this morning when the SQL Server switched to the secondary node. No one knows why it wouldn't go, I...

I just checked EM and it doesn't seem like there is anyone connected to the Model db. sp_who returns too much to scan through to see if anyone is...

I've always tried to steer clear of indexing varchar columns, is this a good practice or am I stuck in the 16bit processor days?