Is your logon enabled in the SQL Server? Is there a default database defined? Dose that default database exist? And does you logon have access to that...

Lynn Pettis (12/15/2008)

---

Jeff Moden (12/15/2008)

---

Just to be sure... you're a heck of a better man than me, Lynn... I looked at your posts and you were quite the gentleman in...

Yeah, that's weird. I don't think that you should be able to do an EXEC in a function. You might want to try taking that out or changing...

David:

Are you saying that you do not know how to generate the CREATE TABLE script or the data INSERT's as described in the article?

Not anymore 🙂

Well there are lots of kinds of rolling (or moving) averages, but assuming that you mean a simple moving average of N values, then it should be something like this:

Declare...

You can do it either way, however, I prefer to put the DELETE's at the end because I find that it makes the failure modes much safer, and the recovery...

The thing is there are still a lot of options and different ways to go here and it is hard to say which may be "best" for you.

For instance, who...

Sure it's relatively straightforward. Some folks would rather schedule & drive this from DOS that SQL, but either way works.

The SOP approach would be a SQL Agent Job scheduled...

Glad we could help, and thanks for the kudos Gamache.

But Joining is the best way to get it.

Besides, is: dbo.fnSchoolName(SiteID)

really that much easier than this?: [Left] Join Schools on Schools.SiteID = tblBase.SiteID

Sure, it's a little...

gamache (12/12/2008)

---

CREATE PROCEDURE dbo.TEST_SS2K5_PAGING

@slice_size INT = 1,

@slice_start INT = 1

[highlight]DECLARE @user_buffer TABLE (user_id INT)[/highlight]

INSERT INTO @user_buffer

SELECT user_id FROM Users ORDER BY lastname, firstname, user_id

IF...

Exporting to a file is easily done with BCP.

An important question here though is, what benefits do you (or your boss/company) hope to derive by making some of the data...

A better way would be to join to a table of School Names keyed by SiteID.

Access: If you are still on ASP, then ADO...