if the parent table uses an identity field for the primary key, you can assign a variable to the identity inserted with the scope_identity() function.

I'm cool with it. Oh wait. You were talking to SKYBVI.... 😀

Here are the steps:

1) drop the foreign keys

2) Add the identity column to the table

3) Add a field to the related tables to hold the new identity column

4) Update the...

I'm still confused about how the page is full. Since data pages are 8K and we are only using 4K, how is that full?

Also, in my opinion, the question...

--Removed--- 🙂

Instead of using LEFT(RTRIM(LTRIM(ARMNAME)),25)

use

LEFT(RTRIM(LTRIM(ARMNAME))+SPACE(25),25)

You'll end up with 25 characters everytime.

SQL Server 2005 only has the datetime field type. A date type field was added in SQL 2008.

Your conversion should give you a date with all zeros for the...

I'm glad it helped!

yeah that looks like homework. If it is, ask your classmates or teacher.

drop the cursors and rethink your approach.

I would ask why you need to use a temp table at all. The CTE option described would likely help (but again we need the details.

Let us know how it goes!

Sounds like historical records without dates or status flags 🙂

Anyway, I hope the new version works well for you. A non-clustered index on those two fields should dramatically speed...

I'm with you on that one. I didn't want to clutter up the quick answer, but that is a great question. I think i'm afraid to hear the...

Well let's hope it helps. Just based on the numbers you replied back with they should at least look at other "options".

This query should do what you are looking for (i think...i'm not entirely sure what you are looking for):

(I also don't see why you need the RAWH table, but i...