Perhaps something like?

declare @example table

( id int,

specification int,

date datetime

)

insert into @example

select 1, 14, '1/1/8' union all

select 1, 14, '1/5/8' union all

select 1, 15, '2/1/8' union all

select...

The short version of the answer is, "No, this is not allowed."

I disagree -- at least nominally; the problem with this statement:

and dbo.DateOnly(R2.evFieldValKey) <= '31/05/2008'

is that you have wrapped the "R2.evFieldValKey" in the dbo.DateOnly() function. This makes this...

Good question! I do not know how beause of scoping problems. If you execute:

exec ('create table #what(id int)')

select * from #what

/* -------- Sample Output: --------

Msg 208, Level 16,...

You might want to download "SQL Server 2005 Express Edition" with the advanced features and also the AdventureWorks database. That is the easy part. The next part is...

Are you also ultimately wanting to omit holidays?

Is it possible to change the design of this table? This design is weak. You would be better off if your data was normalized rather than this single...

Here is an article that gives an overview of a couple of approaches to solve this problem:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=CreateACommaDelimitedList&referringTitle=Home

When I am using SQL Server 2005 I tend toward...

I agree.

Really, I had more in mind what is discussed on this page:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=273443

No.

I have clearly not communicated well so I will let this fall; sorry. Also, I think this is a large diverge from the original post. I started a...

Fair enough. My semantics are wrong. What I am talking about is something in which there is no procedural code. This is what I incorrectly thought G...

I am not referring to "Inline table function", I am referring to "Inline Scalar Functions". I understand the concept and yes, I use them in DB2, but I have...

G:

I have used inline scalar functions in DB2 but I was not aware that they were available in MS SQL Server. Is this a Katmai feature or is this...

Well done. 🙂