LutzM (1/10/2012)

---

an the missing last date in Pauls code: gaps in data are covered by a dynamic calendar table in Pauls code. To include the last date, just change

...

Please do. It can do everything you have asked easily, you just need to invest a little time trying it. I know...

Essex (1/10/2012)

---

Hi Paul, sorry but I dont follow. Where does the function come into play since your merge doesn't use it, you're still literally listing column names and values...

I didn't mean to imply there was only one, though I see it could be read that way. Didn't really think it through at all, come to think of...

The tunnel is a fine achievement to be sure. Some regard the stuff that is in the tunnel as more impressive still.

The site is usually pretty good at handling spam reports so my personal view is we don't need moderators, in general. Judging from an automated out-of-office email I received...

This works for me:

Function definition:

USE AdventureWorks

GO

CREATE FUNCTION dbo.TableColumnList(@TableName sysname)

RETURNS TABLE

AS

RETURN

SELECT

STUFF

(

...

Example:

SELECT

STUFF

(

(

SELECT

...

Essex (1/10/2012)

---

Hi, it's literally the very basic MERGE command syntax and it's being used to re-insert deleted records from a table. there are no conditions apart from the WHERE NOT...

elogen (1/10/2012)

---

I guess what I need for my purposes is to set the isolation level to SNAPSHOT since my function will actually be a more complicated multi statement function. ...

Try an in-line function instead of that scalar one:

CREATE FUNCTION dbo.GetNextMonthFirstThursday

(

@ReferenceDate date

)

RETURNS TABLE

WITH SCHEMABINDING

AS

RETURN

/*

...

Agreed. ...

Could you provide some sample code to illustrate your problem?

I've tried to work out what you are doing from the information provided. Please try the following example, based on your code, and let me know if I have...

It's been some...