Grant Fritchey (1/17/2009)

---

Ninja's_RGR'us (1/17/2009)

---

So what?, only 2 people on that thread answered without reading (or understanding) the question.

Since when reading the full question a requirement of posting an answer?

😀

Maybe it's...

Jeff Moden (1/16/2009)

---

Rayven (1/16/2009)

---

Jeff: Any jobs going at your place? Initiative here tends to be welcomes with a ".. and why were you wasting company time?" before they have even...

Probably having an issue with execution plan because I am running 2008 on my laptop now.

Here's the Statistics Time On Stats:

--IsNull(IsNull(Nullif()))

SQL Server Execution Times:

CPU time =...

Okay, I loaded up the following tables with 1,000,000 rows using RedGate SQLDataGenerator (I needed to play with it since I have it).

CREATE TABLE [dbo].[test_a]

(

...

Jeff Moden (1/16/2009)

---

By the way... if you do contact CCMI, the wizard behind the curtain that makes it all work is called Ed Sullivan. Laugh if you want, that's...

I don't get a suite, but I like to stay at the Marriot Hotels (Courtyard, Fairfield Inn, Springhill Suites). I avoid places like Days Inn.

Steve,

Have a safe trip.

Do you have any support (even online)?

You may be able to if you can find out what was used to create the backup. Backup Exec, Litespeef, RedGate SQLBackup are all possibilities. Where did you...

It would be interesting to see...

I know you said you don't want to use a Database Role, but I think that's the easiest way.

Are you granting execute rights on ALL stored procedures or specific stored...

Steve Jones - Editor (1/16/2009)

---

Interesting perspectives. I've heard a lot of people say it's their business and to some extent they're right. Perhaps salary ranges are enough, but stop and...

If you have no Domain, then running using Windows Authentication is not going to work. How would SQL Server authenticate the user? You should use a SQL Login.

Right, the between got me. This will actually scale better because using a function on a column in a JOIN or WHERE will eliminate the possibility of an Index...

Interesting, Jeff. I am in process of developing a system that needs to handle international phone numbers and we decided to go with this design:

Countries (country_code (iso), name, international_dialing_code,...

If I understand your question correctly then I think this will work (assumes you have the code to get the end time):

CREATE PROCEDURE fill_schedule

AS

SET NOCOUNT ON

-- code to populate #schedule...