Matt Miller (10/19/2007)

---

I figured that was the general direction you were heading in. A lot of that's improved with the newer updates to the framework. Certainly after them...

Bloody site!

Wiped out...

Funny story guys is that your UDF's don't work.

No matter how hard you try to perfect it.

They don't work by definition.

And nobody can do anything about it.

At least they don't...

Sorin,

Your query returns columns only from table "s".

Why you need those joins at all?

Jeff Moden (10/18/2007)

---

Ah... sorry, it doesn't work as expected... it includes weekends which is what Greg is trying to exclude... in terms of your example, he wants to add 30...

Another name for "View with parameters" is "Table function".

BTW, my Tally table holds 65k dates, it's the whole range of "smalldatetime" dates.

So, "Working Days" table contains 65k - 14 rows.

Jeff Moden (10/18/2007)

---

Heck of a good try... but still a bit of RBAR there... looks almost like a date table but limited to 365 days. No doubt it works...

Jeff Gray (10/16/2007)

---

I'm not pointing out anything other than the fact that the order in which the rows are added changes the result, thus suggesting that addition of floats is...

[font="Courier New"]--Create 2 tables to hold normalized data

IF Object_ID('dbo.PrefixCode', 'U') IS NOT NULL

DROP TABLE dbo.PrefixCode

CREATE TABLE dbo.PrefixCode (

ID smallint IDENTITY(-32767, 1) NOT NULL PRIMARY KEY NONCLUSTERED,

Code nvarchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS...

Jim Howell (10/18/2007)

---

That could be the answer! In the real world, these numbers are barcoded on envelopes and we send and receive a couple hundred thousand a month. ...

System functions are as bad here as UDFs.

But it does not mean you cannot use functions in WHERE clause at all.

You should not use it to modify values in table...

You can declare computed column using a function.

And function...

There is only risk of fooling yourself.

Here is one trick which can help to understand it.

There is one variable which you can see declared.

It's table variable.

[font="Courier New"]----------------------------------

SELECT * FROM tempdb..sysobjects WHERE name LIKE '#%'

GO

SELECT * FROM...