You DO realize that if you keep running this, your sales amount will keep skyrocketing (because you haven't fixed the duplication). This is a one-shot deal, unless you want...

One way to speed that up is to put calculated fields in place which grab the left(...) and substring(...) functions. Index those and you should get very good behavior....

Per the BOL:

In multistatement table-valued functions, function_body is a series of Transact-SQL statements that populate a TABLE return variable.

Also (definition of Exec - notice it doesn't mention table-valued functions)

Executes...

Actually - I was coding for sat-sun to mean start day =monday, not friday. That's where we have THAT difference. I was rolling the start date forward, not...

Then I am not understanding what you're doing. You included it on line 1 of your query - is it not one of your fields in a table?

The indexes ain't going to matter much because the function in the where clause is going to cause a table scan.

Mathieu - you don't happen to have the AutoClose option...

Now it just got personal :). Amazing how some good ol' fashion testing seems to work better (I keep trying with not quite enough data to see the flaw,...

Make sure you TEST that the file is there. A lot of FTP clients don't report timeouts very well (meaning - I started to DL the file, and the...

Let's put the challenge here. If the cert were structured in such a way that it captured knowledge of Best Practices and practical experience, vs rote knowledge without any...

You're right - I'm not accounting for the "extra days" right. the modulo is misapplied there.

Try this:

declare @dateStart datetime

declare @daysToAdd int

declare @dateEnd datetime

declare @baseday datetime

select cast(cast('1/1/1900' as datetime) as int)%7

select...

Andy - just curious - What value do you see another certification bringing to the community? There certainly seem to be more than enough already.

I'm not shooting your idea...

your CASE is not the problem it's that you're trying to return a boolean value from

(calculation1)=(calculation2) in a select. That particular syntax doesn't work without wrapping IT in...

I prefer to have it in there when I'm popping in char values like I was for testing (i.e. not count on the implicit conversion). Sounds like you already...

Also - as far as the deletion issue is concerned - you get the same behavior if you're using a stored proc somewhere. You referencing an object from something...

Two relatively easy ways to do that:

- use DTS' "copy objects". It should duplicate most everything. Then - delete what records you don't want in the archive.

...