Why would you want to do this?

I think the only way might be to write your own extended procedure or instantiiate a wrapper Active X Dll via sp_OA* procedures. But...

...and incorrect

Since we want 5 minutes buckets, it should read something like this:

SELECT [Hour],

 REPLACE(STR(StartingInterval,2),' ','0') + '-' + REPLACE(STR(StartingInterval+4,2),' ','0') AS interval,...

I might be missing something, but when you pass DATETIME parameters and compare with DATETIME values, there is no conversion needed at all. However, if LogTime is a varchar, CAST...

See if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

I like to think that this is not only a techie place, but a community where those thoughts can be shared. Echoing Steve: Thanks for that and best of luck!...

Read this http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx closely and decide then which way to go.

...too quick. I would still schedule this for off-peak usage hours. Depending on how large your table actually is.

Yes, there is. But when you use Enterprise Manager, it will use the interim table method.

One method might be to have Enterprise Manager create the change script and save...

Are you looking for this?

SELECT 

 LEN(CLPHN) AS PhoneLength

 , CASE 

  WHEN LEN(CLPHN)>7 THEN substring(CLPHN,1,3)

  ELSE ''

  END  AS ClientAreaCode

 , rtrim(ltrim(CLPHN)) AS ClientPhoneNumber

 , CLPHN

FROM CLIENTPF

ORDER BY CLNUMBER

When you recreate the clustered index on that new filegroup, you don't need an interims table.

Yes, Enterprise Manager uses another way. It will create an interims table, move data there, create target table and move the data from interims table to target table. Not terribly...

Recreate the clustered index on that new filegroup. To speed this up you can use WITH DROP EXISTING. See BOL "CREATE INDEX" for complete syntax.

http://www.sqlservercentral.com/columnists/fkalis/abriefhistoryofsql.asp

I like to think it is S-Q-L

Where are those check boxes? I can only find CREAT / DROP < object >

Now it's my turn to apologize. My wording was a bit inappropriate, I guess

Btw, is the original question finally answered?