Try this:

SELECT Metal, min(Result), max(Result), count(Result), stdev(Result)

FROM Metals

GROUP BY Metal

By the way, stdev() is the statistical standard deviation, if you want the standard deviation for a population ,...

Glad I could help.

Sherjon (6/19/2008)

---

Hi RBarryYoung,

Please do. That Save button would be awesome.

BTW, I did not mean to offend you in any way with the 'winner' comment. It just happened to be...

Perhaps they just rolled back. Are you tracing Commits and Rollbacks also?

marin (6/19/2008)

---

Hello all,

I'm trying to split a text (e.g. "MR. JOHN SMITH" or "MRS. JANE AUSTIN SMITH") into chunks in order to be able to extract certain blocks: in this...

Sherjon (6/19/2008)

---

The winner is grasshopper, because, although it is a little cumbersome, the Script Wizard does indeed produce ANSI text output.

The SQL Server 2000 script would generate an...

By the way, his name isn't Grasshopper, that's his posting rank. His name is asdfgh.

Did you try what I suggested?

Try this:

select *

from table1

cross join (select '0' as N

Union All Select '1' as N

Union All Select '2' as N

...

Sherjon (6/19/2008)

---

Hey Grasshopper,

We installed the x86 version of SP2 because we have 32 bit machines. We have the 'script' entry for Tools which is nice because...

Put it in its own schema, Deny acces to the Schema, then grant access to the object.

This will list them all:

select *

from Information_Schema.Tables

Where Table_Type = 'View'

And Table_Schema = '-Your Schema Name-'

Of course, if you want to Delete them, you don't have to...

Ouch! :w00t:

Here you go:

ALTER function [dbo].[fnSplit1](

@parameter varchar(Max)-- the string to split

, @Seperator Varchar(64)-- the string to use as a seperator

)

RETURNS @Items TABLE(

ID INT-- the element number

, item VARCHAR(8000)-- the...

Does this article help?: http://www.sqlservercentral.com/articles/SSIS/63152/