GSquared (12/14/2010)

---

That won't "round" correctly if...

Right now I have a rather old-standard cell phone (no iPhone, pretty much all I can do is make and receive phone calls 🙂 ) and a laptop. That's the...

Stefan Krzywicki (12/14/2010)

---

GilaMonster (12/14/2010)

---

Thunderstorms here, but no snow storms. (I'd worry if there were)

Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.

It almost...

Alvin Ramard (12/14/2010)

---

Sure. ...

Another option not using any of the ROUND/FLOOR/CEILING functions:

PRINT (CAST(12307.96 AS INT)/1000 + 1)*1000

Does it make sense to use it? I don't think so.

But I hope you'll allow Jeff to let the iPad go before....

Craig Farrell (12/13/2010)

---

Alright, I'll bite. Anyone know how to turn a column from a stream in an SSIS package into a non-nullable version of itself? Data Conversion seemed...

Here's an example of the concept I mentioned in my previous post:

CREATE TABLE #temp

(

id INT IDENTITY(1,1),

val INT,

grp AS val-id persisted

)

INSERT INTO #temp (val)

SELECT 0 UNION ALL

SELECT 2...

Paul White NZ (12/13/2010)

---

Yes :laugh:

All things...

Hi Paul,

that really is a very interesting approach to deal with large volume tables. I guess the partition sturcture of some of our archive tables might change soon! (We're currently...

Based on your sample data, what is your expected result?

And what have you tried so far?

Steve Bergkamp (12/13/2010)

---

Thank you for the reply. I forgot one crucial piece of information. This has to run on SQL Server 2000 so the Over syntax, ...

I'd recommend you use a grouping concept like

Id-ROW_NUMBER OVER(ORDER BY Id)

So you Batches would be -1,0 and 1.

petervdkerk (12/12/2010)

---

Sorry if I wasnt clear, but by this "what I'd rather not have to do is individually insert the column names that are to be selected and inserted.", I...

If your ReallyComplicatedCode is based on columns of the same row in the same table you could add a computed (persisted) column to the table and use that in your...