Heh... I like the "downtown" explanation better.

Light on = True... Light off = False... NULL = who the hell stole my lamp 😛

Heh... good... not my eyes... just time of day. Thanks, Matt.

Ah... got it... Looked more like VBS. Not sure why folks don't just write real code... doesn't take any longer 😛

DECLARE @A INT --Defaults to NULL on...

Even more interesting... the...

Sergiy (10/22/2007)

---

I said - I could not test.

There was a typo in the formula.

Also I corrected small logical error in the code:

[Code]

IF OBJECT_ID('dbo.fnAddWeekdays_Sergiy','fn') IS NOT NULL

DROP FUNCTION dbo.fnAddWeekdays_Sergiy

GO

CREATE FUNCTION dbo.fnAddWeekdays_Sergiy...

Peter Larsson (10/24/2007)

---

Matt, excellent testing.

BUT... I am missing data from SQL Profiler regarding CPU/DURATION/READS and WRITES for the different methods used.

When I started out with SQL Server 2005 and PIVOT...

VAIYDEYANATHAN.V.S (10/23/2007)

---

Sometimes it is necessary to rotate results so that columns are presented horizontally and rows are presented vertically. This is known as creating a PivotTable®, creating a cross-tab report,...

rog pike (10/23/2007)

---

(This is not directed at anyone in particular. At most it

rises to the level of a shot across the bow of a ship

whose course needs dire correction).

Exactly what...

Bob Bridges (10/23/2007)

---

I've got a problem that I can't figure out... I'm using the following as suggested to get the data to the right of the delimiter...

(SELECT STUFF(GL_SWT,1,CHARINDEX('.', @col+'.'),'')

It works...

Hmmm... I wonder how Pivot in 2k5 would do against these simple 3 value pivots on a million rows? ...

Yep... mine definetly fails for different languages... that's why I said you need to modify it for other languages. 😀

Ken's DATEFIRST solution would fix that.

mrpolecat (10/23/2007)

---

Just for S&G I removed your index completely and it didn't change performance time. Still 20 seconds. Here is the table I am using to test with...

rog pike (10/23/2007)

---

RAC will never be amongst the fastest solutions. It is a simple tradoff, performance for functionality. RAC does not build a single SELECT statement to execute against a...

mrpolecat (10/23/2007)

---

I thnk it would make sense to move the...

I'll check it out, Peter... thanks for the feedback.