ifila (12/5/2008)

---

I tried again and it did. duh!

What i need to do is manage the records in unique order based on the temp field which equals 'field1+field2+field3'

Would i need to...

Why won't it work?

That works. However, in the large SP, the logic goes:

Create Temp Table

...

Insert into Temp Table

Update a bunch of fields in the temp table for various reasons

...

Alter Temp Table if...

GilaMonster (12/5/2008)

---

I ran your...

My curiosity aside, the dynamic SQL alter statement may work for you baumgaertner, as it is only having issues on a 2000 server, and I'm assuming you're using 2005.

Indeed, I can run it fine on 2K8 as well, our production server is still 2K though, and it fails there.

The other procedure is running fine on the...

It's a datatype issue. This is why it's best to give all the information you can the first time, as I'd have warned you about this. You need...

This is in one of the SP's that I wrote quite a while back, and it works fine.

...

CREATE TABLE #temp_final_results (

... -- A whole bunch of fields, but...

No problem Stu, glad we could help.

Joe,

Once again... Please refer to the link in my signature for how to provide proper sample data. You'll get better and faster answers to your questions if you do...

You mean something like?

SELECT A, B, A + B, A + ', ' + B

FROM Something

Just saw the end part about wanting the EOD. This EOD friday seems a bit sloppy and could likely be improved upon.

[font="Courier New"]SET DATEFIRST 1

SELECT    

   DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0)...

Just had to do one of these this morning actually.

SET DATEFIRST 1

SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) Monday,

DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0)+4 Friday

sisernhagen,

Note that Peso's solution won't work if you're using SQL 2000.

From a simplicity standpoint... it *might* be easier to have the database send it to...