Stefan Krzywicki (6/21/2010)

---

Lynn Pettis (6/21/2010)

---

A) I can't see the corelation between worrying about the fouls and cards and worrying about goals and strategies. First, why are you worrying...

Stefan Krzywicki (6/21/2010)

---

Lynn Pettis (6/21/2010)

---

Stefan Krzywicki (6/21/2010)

---

How do they (anyone but the main ref) know how much time is left? I certainly have no idea. This is one reason I...

Okay, I guess I'll have to agree to disagree. I like the game the way it is, wether it is youth competitive, high school, whatever. I see no...

Hard to tell from what is provided. Can you script the jobs and their schedules and post that code? Maybe that would help us see what is going...

Stefan Krzywicki (6/21/2010)

---

How do they (anyone but the main ref) know how much time is left? I certainly have no idea. This is one reason I don't watch soccer. It...

endeavour (6/21/2010)

---

Depends on the db usage - mine was used 24/7 with 20million site users so I needed to spread the load out -

and deleting 50m rows in a...

Check out this blog post: Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions.

endeavour (6/21/2010)

---

I found a nice calm way to delete specific chunks of 200,000+ rows from a table, getting around the mass-logging issue you would run into if you just ran...

Totally untested (passed the parse) as you didn't provide any DDL for the table(s) involved, sample data, or expected results.

create function dbo.fn_myFunction(@MRN sometype1, @Date datetime, @SchedNo sometype2, @Section sometype3)

returns table

as

return(

...

Looks like it could be rewritten as an inline tvf and called using cross apply. How is the results of the function used again?

Check out this article: Deleting Large Number of Records[/url].

If you still have questions, just ask.

Is this function a scalar function or a table-valued function? Can't tell from the code posted as it looks like a snippet, not the entire function.

I got it right, but I had to research BOL to figure out some of the operators. Guess I should have started at the end, would have saved a...

Oh NO! Urgent problem, need help now!

As if everyone's problem isn't urgent! 😛

First, we are volunteers on this site. We answer questions when we can and if we are able to assist.

Second, have you checked with the administrator of your mail...