Neuromasts

sudhanva (8/10/2010)

---

Hi,

I have a table with 3,000,000 records for one year. It has only a primary key.

Just select query without any where clause is taking 15-20min of time.

My question is,...

This is worth a look.

Please provide table creation scripts and sample data as in the link below. Without this,...

Lynn Pettis (8/9/2010)

---

bitbucket-25253 (8/9/2010)

---

Celko is at it again

http://www.sqlservercentral.com/Forums/Topic965546-1292-1.aspx#bm966047

For a community which attempts to help, even the most inept, and helps so many this guy Celko is a real detriment .......

CirquedeSQLeil (8/9/2010)

---

That is scary - check the timestamps of...

It's a forestry expression.

crookj (8/9/2010)

---

Chris Morris-439714 (8/9/2010)

---

Copper.

Valuable metal found in signal- and power-carrying cables. Train signalling, for instance. Sufficiently valuable to be cut and stolen in broad daylight on friday, in an area...

Copper.

Valuable metal found in signal- and power-carrying cables. Train signalling, for instance. Sufficiently valuable to be cut and stolen in broad daylight on friday, in an area just outside Reading,...

snehalata_d (8/9/2010)

---

Hello,

I have a table Orders

By applying sql query on it I am getting result set(table) as follows

sum(freight) | YEAR(orderdate)

-------------+------------------

----------- +------------------

25000 ...

The link doesn't work.

karin.askeroth (8/9/2010)

---

I'm beginning to think I'm in the wrong forum, maybe this isn't a place for any questions concerning how to use sql? I don't think it matters which programs...

Declare @timeZone varchar(10)

Declare @ZoneTime varchar(30)

Set @timeZone='CT'

Set @ZoneTime = CASE

WHEN (datepart(hour,dateadd(hh,dbo.GetTimeZoneDiff(@timeZone),getdate())) - datepart(hour,'00:00') < 12) THEN 'Morning'

WHEN (datepart(hour,dateadd(hh,dbo.GetTimeZoneDiff(@timeZone),getdate())) - datepart(hour,'00:00') < 17)...

SELECT CONVERT(DECIMAL(18,2),NULL) AS finalpremium

...works just fine. What datatype is the column finalpremium?

What client are you using to run the statement?