Although I see nothing wrong with the script, there is a perferred method.

So I suggest that you use the method recommended by MS which is to use the sp_help_revlogin procedure.

If you want a 2000 version of the query perhaps you should ask for one (Or offer one yourself) I don't see the point in being critical of a...

You realize that the only ones who will read that article are those that know how to post 🙁 However, is it just me or did Jeff's post of...

Oh great... Helping a Bengal. Hoping to be at the 12/2 game 🙂

Pittsburgh (EST) so I have a few hours yet, and I won't be back to work until next Monday. Thanksgiving Holiday. I am sure I will check in...

Ok. Then that is the exact opposite that I thought you wanted.

The index should be ASC not descending, and the part where the substrings are needs adjusted slightly. ...

kipp (11/20/2007)

---

awesome it works!!

THe only thing it is doing is the last date is not getting populated...

11256.001 1995-07-05 00:00:00

11256.001.01 1995-07-05 00:00:00

11256.001.02 NULL

11256.001.03 NULL

11256.001.04 NULL

it is flowing down to .03 and...

Do you have this line?

@dt = ISNULL(proj_start_dt,@DT),

Can you post your final code, because what I have does work.

Before:

After:

DROP TABLE #proj -- my temp table

CREATE TABLE #Proj(

[Proj_ID] [varchar](50) NOT NULL,

[Proj_Start_Dt] [smalldatetime] NULL,

[Proj_End_DT] [smalldatetime] NULL,

CONSTRAINT PK_Proj PRIMARY KEY CLUSTERED

...

kipp (11/19/2007)

---

ok, this is what I have, but it does not seem to be updating for some reason...

DROP TABLE proj_id_11256; -- my temp table

SELECT * INTO proj_id_11256

FROM PROJ order...

Just makes it a little harder, but this was a trick that I was shown a few weeks back.

/*

CREATE TABLE [tblTest](

[ProjProjID] [varchar](50) NOT NULL,

[ProjStartDt] [datetime] NULL,

[ProjEndDT] [datetime] NULL,

CONSTRAINT [PK_tblTest]...

Can you change the clustered index on the table?

I'm with Jeff on this. Why do you need to do this? But more that that, have you verfied there are no FK's against this table?

Thanks Jeff!

Even the blind squirrel occasionally finds a nut 🙂